SQL Code -204

CICS fan · Posted: Thu May 14, 2009 4:36 pm

Hello All.

We have wrote a program which connects to DB2 database on Unix.While trying to add it to Endevor(i.e. while trying to compile) we are facing the following error:

DSNX200I -DBD1 BIND SQL ERROR
USING DB2CBSP AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=IMST862
STATEMENT=150
SQLCODE=-204
SQLSTATE=42704
TOKENS=DB2CBSP.TRIP
CSECT NAME=DSNXOTL
RDS CODE=-500

Can anyone please help in decoding this?

bipinpeter · Posted: Thu May 14, 2009 5:08 pm

SQL code -204 is returned when the object name(DB2 table) is not defined in the subssytem.Please check the table is existing or not.

Regards,
Bipin Peter

dbzTHEdinosauer · Posted: Thu May 14, 2009 5:15 pm

db2 could not find DB2CBSP.TRIP.
is TRIP a table name?
do all the db2 programs at your site qualify the table name?