By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,823 Members | 730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,823 IT Pros & Developers. It's quick & easy.

-805 Error

P: n/a
Ali
Binding error

< SQLSTATE = 51002, SQLCODE = -000000805 >.
< DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DBD2SYSTEM..SB0A0Q00.174
< PLAN CGEY001D. REASON 03 >.
< DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE >.
< DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR >.
< DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION >.
< DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF' X'00000000
< DIAGNOSTIC INFORMATION >.
DSNX200I =DD21 BIND SQL ERROR
USING SS3MDU02 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=SB0A0Q00
STATEMENT=675
SQLCODE=-401
SQLSTATE=42818
TOKENS=
CSECT NAME=DSNXOBFC
RDS CODE=930
DSNT233I =DD21 UNSUCCESSFUL BIND FOR
PACKAGE = DBD2SYSTEM.SS3MDU02.SB0A0Q00.()
Any ideas would be much appreciated.
A
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Ali" <al***********@cgey.com> wrote in message
news:d3**************************@posting.google.c om...
Binding error

< SQLSTATE = 51002, SQLCODE = -000000805 >.
< DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DBD2SYSTEM..SB0A0Q00.174 < PLAN CGEY001D. REASON 03 >.
< DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE >.
< DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR >.
< DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION >.
< DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF' X'00000000 < DIAGNOSTIC INFORMATION >.
DSNX200I =DD21 BIND SQL ERROR
USING SS3MDU02 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=SB0A0Q00
STATEMENT=675
SQLCODE=-401
SQLSTATE=42818
TOKENS=
CSECT NAME=DSNXOBFC
RDS CODE=930
DSNT233I =DD21 UNSUCCESSFUL BIND FOR
PACKAGE = DBD2SYSTEM.SS3MDU02.SB0A0Q00.()
Any ideas would be much appreciated.
A


Did you look up the -401 in the Messages and Codes manual? It appears to be:

THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE

In the future, please include your OS and DB2 version number.
Nov 12 '05 #2

P: n/a
For those interested, the DSN* messages in the sysout can be found using
lookat on the web.
http://www-1.ibm.com/servers/s390/os...at/lookat.html

Following the links for DSNT418I, you can get the -401/42818, etc
descriptions.
http://publibz.boulder.ibm.com/cgi-b...18150520&CASE=

2.1.6 Error SQL codes
http://publibz.boulder.ibm.com/cgi-b...18150520&CASE=
click on the -805 to see what's reason code 3.

PM
"Ali" <al***********@cgey.com> a écrit dans le message de
news:d3**************************@posting.google.c om...
Binding error

< SQLSTATE = 51002, SQLCODE = -000000805 >.
< DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DBD2SYSTEM..SB0A0Q00.174 < PLAN CGEY001D. REASON 03 >.
< DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE >.
< DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR >.
< DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION >.
< DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF' X'00000000 < DIAGNOSTIC INFORMATION >.
DSNX200I =DD21 BIND SQL ERROR
USING SS3MDU02 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=SB0A0Q00
STATEMENT=675
SQLCODE=-401
SQLSTATE=42818
TOKENS=
CSECT NAME=DSNXOBFC
RDS CODE=930
DSNT233I =DD21 UNSUCCESSFUL BIND FOR
PACKAGE = DBD2SYSTEM.SS3MDU02.SB0A0Q00.()
Any ideas would be much appreciated.
A

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.