DB2 z/OS v9 - SYSPACKSTMT column unreadable

Irwin Deutsch

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.

_____________________________________________________________________
* 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

David Simpson

Re: DB2 z/OS v9 - SYSPACKSTMT column unreadable
(in response to Irwin Deutsch)
In V8 and after the DBRM is stored in Unicode and the data in STMT is stored in Unicode FOR BIT DATA. This query should translate...

SELECT

CAST(

CAST (STMT AS VARCHAR(3500) CCSID 1208)

AS VARCHAR(3500) CCSID EBCDIC

)

FROM SYSIBM.SYSPACKSTMT


_____________________________________________________________________
* 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