IBM InfoSphere Information Server, Version 8.5 IBM InfoSphere Information Server, Version 8.5Use this property to specify whether the connector generates the SELECT, INSERT, UPDATE, or DELETE statement at run time.
If you set Generate SQL to Yes, the SQL statements are automatically generated at run time. You cannot specify them at design-time. The statements are generated by using the table name that you specify in Table name and the information that you specify on the Columns tab. Schema reconciliation is performed on this data.
If you set Generate SQL to No, you must specify your SQL statements at design-time. You must specify a value for Table name only if you also want to generate Data Definition Language (DDL) statements and you set Table action to Create, Drop, or Truncate.
The default value is No.
This topic is also in the IBM InfoSphere DataStage and QualityStage Connectivity Guide for ODBC.
