[DB2 z/OS v9 - SYSPACKSTMT column unreadable

Daniel Luksetich

[DB2 z/OS v9 - SYSPACKSTMT column unreadable
I have an example statement on db2expert.com download page you can try.

Sent from Samsung mobile

Irwin Deutsch <[login to unmask email]> wrote:

>Hi,
>
>The STMT column in SYSIBM.SYSPACKSTMT is unreadable after my SELECT. All
>other columns look good. I'm using SPUFI. Do I need to specify some code
>or translation option? Or is this just some internal representation of the
>statement that isn't meant for human consumption?
>
>
>Thanks,
>
>Irwin
>
>
>The information contained in this email and any attachment may be
>confidential and/or legally privileged and has been sent for the sole use
>of the intended recipient. If you are not an intended recipient, you are
>not authorized to review, use, disclose or copy any of its contents. If
>you have received this email in error please reply to the sender and
>destroy all copies of the message. Thank you.
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>** The best DB2 technical sessions in the world
>** Independent, not-for-profit, User Run - the IDUG difference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Tony Saul

Re: DB2 z/OS v9 - SYSPACKSTMT column unreadable
(in response to Daniel Luksetich)
Depending on your z/OS version; in Browse you can issue the command DISPLAY
ASCII and in EDIT/VIEW you can isue SOURCE ASCII and  the values will be
displayed.
 Regards,
Tony




________________________________
From: Irwin Deutsch <[login to unmask email]>
To: [login to unmask email]
Sent: Fri, 24 December, 2010 6:59:11 AM
Subject: [DB2-L] DB2 z/OS v9 - SYSPACKSTMT column unreadable


Hi,

The STMT column in SYSIBM.SYSPACKSTMT is unreadable after my SELECT. All other
columns look good. I'm using SPUFI. Do I need to specify some code or
translation option? Or is this just some internal representation of the
statement that isn't meant for human consumption?



Thanks,

Irwin


The information contained in this email and any attachment may be confidential
and/or legally privileged and has been sent for the sole use of the intended
recipient. If you are not an intended recipient, you are not authorized to
review, use, disclose or copy any of its contents. If you have received this
email in error please reply to the sender and destroy all copies of the message.
Thank you.

________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.





_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv