MVSFORUMS.com

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

As of DB2 version 8, the contents of the SYSPACKSTMT (and the SYSSTMT) catalog tables could contain rows which are either UNICODE or EBCDIC characters, depending on when the package was last bound and which version of DB2 the package was bound under. A package bound under version 7 of DB2, when re-bound, will cause the contents of the STMT column on the SYSPACKSTMT table to be changed from EBCDIC to UNICODE.

My real question is:
Is there a way to determine whether the STMT column of the SYSPACKSTMT table contains UNICODE or EBCDIC characters without looking at the contents of the STMT column?

Is there some way to determine this by querying the system catalog or even within the contents of the STMT column itself?

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

I just got my answer from my DBA who went to IBM to get a response. It's fairly long, so I'll try to filter through the information and provide a readable post. Very Happy

kolusu · Posted: Mon Jan 14, 2008 2:44 pm Post subject:

jim haire,

Try this

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

Kolusu,
That is very similar to what I was sent. I will try both. Thanks for the quick response!

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

Based on the brief reading I've done and Kolusu's response, here is the additional information you need to look for.

If the DBRMMRIC (48th character of the STMT column) is less than or equal to "K",
the STMT column will be in EBCDIC.

If the DBRMMRIC (48th character of the STMT column) is equal to "L" and the DBRMPDRM (47th character of the STMT column) is also equal to "L", the STMT column will contain UNICODE characters. Otherwise, the STMT column will be in EBCDIC.