SAP Knowledge Base Article - Preview

2261384 - DataWindow does not show sql syntax when tables are not found - SAP PB 12.6

Symptom

  • You are connected to IBM Informix using the I10 driver and you open a datawindow where you are not the owner of the table;
  • When you try to view the datasource, the following message appears:

SQL Error -410: Prepare statement failed or was not executed.
Please check to see if the active DB Profile is correct.

 inf_error.png

  • Once you hit, 'No', the datawindow syntax is blank.   
  • You have no way to edit the sql select statement.  This behavior is different in PowerBuilder 12.1.


Read more...

Environment

  • SAP PowerBuilder (PB) 12.6
  • IBM Informix

Product

SAP PowerBuilder 12.6

Keywords

dw,datawindow,informix,-410,graphic,sql,syntax, CR791479, 791479 , KBA , BC-SYB-PB , PowerBuilder , 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.