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 ONE Support launchpad (Login required).

Search for additional results

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