-805 Error

[Ali]

Binding error

< SQLSTATE = 51002, SQLCODE = -000000805 >.
< DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DBD2SYSTEM..SB0 A0Q00.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.SS3M DU02.SB0A0Q00.( )


Any ideas would be much appreciated.
A

[Mark A]

Re: -805 Error

"Ali" <alistair.ross@ cgey.com> wrote in message
news:d3fde5eb.0 312161011.41764 b4e@posting.goo gle.com...[color=blue]
> Binding error
>
> < SQLSTATE = 51002, SQLCODE = -000000805 >.
> < DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME[/color]
DBD2SYSTEM..SB0 A0Q00.174[color=blue]
> < 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'[/color]
X'00000000[color=blue]
> < 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.SS3M DU02.SB0A0Q00.( )
>
>
> Any ideas would be much appreciated.
> A[/color]

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.

[PM \(pm3iinc-nospam\)]

Re: -805 Error

For those interested, the DSN* messages in the sysout can be found using
lookat on the web.

http://www-1.ibm.com/servers/s390/os390/bkserv/lookat/lookat.html

Following the links for DSNT418I, you can get the -401/42818, etc
descriptions.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.131?SHELF=&DT=20010718150520&CASE=

2.1.6 Error SQL codes

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6?SHELF=&DT=20010718150520&CASE=

click on the -805 to see what's reason code 3.

PM


"Ali" <alistair.ross@ cgey.com> a écrit dans le message de
news:d3fde5eb.0 312161011.41764 b4e@posting.goo gle.com...[color=blue]
> Binding error
>
> < SQLSTATE = 51002, SQLCODE = -000000805 >.
> < DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME[/color]
DBD2SYSTEM..SB0 A0Q00.174[color=blue]
> < 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'[/color]
X'00000000[color=blue]
> < 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.SS3M DU02.SB0A0Q00.( )
>
>
> Any ideas would be much appreciated.
> A[/color]