compile COBOL+CICS+DB2 error (bind plan/package error)??

Young zhang · New User Joined: 13 Jun 2008 Posts: 15 Location: china

WHEN I COMPILE THE PROGRAM, THEN IT SHOW ME THE MESSAGE:

DSNX200I -DB2A BIND SQL ERROR
USING GELTP AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=IBAUPD
STATEMENT=260
SQLCODE=-551
SQLSTATE=42501

Here is the error, how to solve it. Thank you!

dbzTHEdinosauer · Posted: Thu Sep 25, 2008 2:17 pm

here is the direct link for this sql error code:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J12/2.3.248?SHELF=&DT=20070111144235&CASE=

in the future, if you do not want to download a copy of msgs and error codes for your db2 version, which can be found at this link:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/FINDBOOK?filter=DB2&SUBMIT=Find&Collection=0

you can always access the ibm lookat site which will provide you links for any ibm msg/error msg:
www-03.ibm.com/systems/z/os/zos/bkserv/lookat/

dbzTHEdinosauer · Posted: Thu Sep 25, 2008 2:17 pm

by the way, what you received was a message from the db2 bind step, not your compile step.

Young zhang · New User Joined: 13 Jun 2008 Posts: 15 Location: china

Hi dbzTHEdinosauer,
Thanks for your help, I will try to solve it.

enrico-sorichetti · Posted: Fri Sep 26, 2008 12:14 pm

why do You double post for the same issue ??
it will not get You double help, it will only bother people