OnDemand User Group
Support Forums => z/OS Server => Topic started by: Ed_Arnold on March 11, 2014, 11:11:19 AM
-
PI05686 needs to be installed if you receive the following -518:
> Fetch row failed -1
> ODF SQL entry print_error rtn
> ODF SQL SQLSTATE: 07003
> ODF SQL Native Error Code: -518
> ODF SQL buffer: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015}
> DSNT408I SQLCODE = -518, ERROR: THE EXECUTE STATEMENT DOES NOT IDENTIFY A
> VALID PREPARED STATEMENT
> DSNT418I SQLSTATE = 07003 SQLSTATE RETURN CODE
> DSNT415I SQLERRP = DSNXERT2 SQL PROCEDURE DETECTING ERROR
> DSNT416I SQLERRD = -280 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
> DSNT416I SQLERRD = X'FFFFFEE8' X'00000000' X'00000000' X'FFFFFFFF'
> X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
> ERRLOC=5:10:2
Ed
-
The previous append's error was found with DB2 V11 in NFM.
With DB2 V11 in Compat Mode we've had a report of -501's received until the fix was applied.
PI05686 is like American Express - don't leave home without it.
Better yet, just put on all fixes available for the ODBC FMID. ;D
Ed
-
We have also found a problem when using DB2 V11 resolved by CA PTF RO66822 .
Ed