I know this is not a DB2 list, but I'm hoping someone here can give me a hint.
We're trying to BIND wiht OPTHINT but DB2 refuses to use the hint with the
following msg:
DSNX105I -DAF2 BIND SQL WARNING
USING S100447 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=A5PO356
STATEMENT=16423
SQLCODE=395
SQLSTATE=01628
TOKENS=32
Explanation of SQL code +395 list a number of Reason Codes, but what in the
above message is the reason code?
Is it "TOKENS="? if so, 32 means "CREATOR or TNAME is invalid." but that does
not help me, since Owner and TNAME seem to be reasonable values.
Any issue when the SQL in the program is using a table name that actually is a
synonym to the real table name? Which name would have to be in the PLAB_TABLE
in this case: real table or synonym?
--
Peter Hunkeler
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
