Generate SQL
Use 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.
In some job configurations, the Table name property is disabled and you cannot provide a table name value. If you either generate a data definition language (DDL) SQL statement by clicking Generate, or generate the data manipulation language (DML) SQL statement by selecting , when the Table name property is disabled, then the generated SQL statement uses the placeholder <TABLENAME> instead of the table name. You can then replace <TABLENAME> with the actual table name