MVSFORUMS.com

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

I am in the middle of writing a REXX command which will identify the SQL statements in a program. I am looking at the SYSPACKSTMT as one source of this information. I provide the REXX command with the name of a program and it identifies the SQL.

In DB2 Version 8, the system catalog has been converted to Unicode. In order to read this, your SQL has to be written to convert it to EBCDIC. However, some of the rows on the SYSPACKSTMT table are already in EBCDIC while the "newer" rows are in Unicode.

My question is this:
Is there anywhere within the system catalog tables where it would indicate if the information for the program is in Unicode?

The reason I need to know this is if you try to convert it from Unicode to EBCDIC and it is not Unicode in the first place, a -330 is returned from the SQL.

kolusu · Posted: Fri Jun 08, 2007 8:54 am Post subject:

Jim,

Check this link which answers your question

http://www.idugdb2-l.org/adminscripts/wa.exe?A2=ind0611c&L=db2-l&T=0&I=-&P=9506

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

Thanks. I'll try this out and see if it helps identify which rows are Unicode.

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

No need to worry about the encode of the table in your application. You REXX can read the data no matter the table is stored in UNICODE or EBCDIC. It's the function of DB2 system. It will convert to right encode schema before return to applaiction.

Usually no changed of your REXX code if the table converted to UNICODE, only the SORT sequence will be changed.