DB2 Client on DB2 V9 z/OS

Philip Sevetson

DB2 Client on DB2 V9 z/OS
I just discovered that my copy of DB2 Command Editor is lying to me about SQLCODEs.

When I issue a GRANT statement, and the privileges GRANTed are already given by the SQLID I'm using, I expect, based on my experience with DB2, to see a return code of +562. However, I just caught the DB2 Command Editor reporting SQLCODE 0 for this event. This is _NOT_ a desirable outcome; it was telling me that grants had not previously existed, yet when I checked the catalog for the DATE_GRANTED on my new grants, it was a month ago!

Has anyone else run into this?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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