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 for Me (Login required).

Search for additional results

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