2130159 - 'sql syntax' parameter for DB2 is incorrect - ECDA DB2 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2130159 - 'sql syntax' parameter for DB2 is incorrect - ECDA DB2

Symptom

  • Incorrect default value of 1 for 'sql syntax' parameter 
  • In files dcany.cap (DB2) and db2.cap (DB2 z/OS)
  • Causing (syntax) errors which include, but may not be limited to, error 30291 on delete :

  

Msg 30291, Level 19, State 0
Line 1: [[Message Iteration=1|Data Source Name=SQL_DB2|SQL Function=DELETE WHERE|
SQLState=42000|Native Error=- 104| - Token $PRDEISRCV was not valid. Valid tokens: FROM.]
Command has been aborted.

 


Read more...

Environment

Enterprise Connect Data Access (ECDA) for DB2 or DB2 on z/OS, versions 15.0.1 and 15.7

Product

Sybase EnterpriseConnect Data Access 15.7

Keywords

"DirectConnnect" , "DirectConnect DB2" , "DirectConnect for DB2", "ECDA DB2", "ECDA for DB2" , "Msg 30291" , "error 30291" , "message 30291" , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , Bug Filed

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.