SAP Knowledge Base Article - Preview

2651859 - SQLCODE -518 error messages being reported

Symptom

You observe the following dumps reported in tcode ST22:

------------------------------------------------------------------------------------------------------------------------------------------------
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 06/01/2018 00:15:02

Short text
SQL error "-518" when accessing table "<tablename>".

What happened?
Error Text of the Database: "[IBM][CLI Driver][DB2] THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT"
------------------------------------------------------------------------------------------------------------------------------------------------

and in the work process logs (tcode ST11, dev_w):

------------------------------------------------------------------------------------------------------------------------------------------------
C Fri Jun 1 00:15:02:037 2018
C *** ERROR => DB2 Call 'SQLSetStmtAttr CHAINING_END' Error: conHdl = 01 SQLCODE = -518 : [IBM][CLI Driver][DB2] THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT
------------------------------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

Netweaver
DB2 z/OS

Product

SAP NetWeaver all versions

Keywords

db2 z/OS bind package cli jdbc sqlcode collection id , KBA , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.