SAP Knowledge Base Article - Preview

2008619 - Informix Dynamic SQL Format 2 returning -201: A syntax error has occured

Symptom

After successfully connecting to an Informix 11.7 database using the I10 driver, a sql statement in the dynamic SQL format 2 is executed and returns the following error:

sql error -201:  A syntax error has occurred

The embedded sql uses an argument and it appears that the argument value is not replacing the placeholder ('?') in the sql.
This has worked successfully in PowerBuilder 9.   After migrating to PowerBuilder 12.5.2, it is returning the above error.  

 


Read more...

Environment

  • SAP Sybase PowerBuilder 12.5.2
  • Informix

Product

SAP PowerBuilder 12.5

Keywords

PowerBuilder, DisableBind,Embedded SQL, Dynamic SQL Format 2, Informix, placeholder, bind variable     , KBA , BC-SYB-PB , PowerBuilder , 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.