validateSQLStatements

The build descriptor option validateSQLStatements indicates whether SQL statements are validated against a database. Successful use of validateSQLStatements requires that you specify option sqlValidationConnectionURL and, in most cases, other options that begin with the letters sql, as listed later.

Valid values are YES and NO, and the default is NO. Validation of SQL statements increases the time required to generate your code.

When you request SQL validation, the database manager accessed from the generation platform prepares the SQL statements dynamically.

SQL statement validation has these restrictions:

• No validation is possible for SQL statements that use dynamic SQL and are based on SQL records

• The validation process may indicate errors that are found by the database manager in the generation environment but that will not be found by the database manager on the target platform

• Validation occurs only if your JDBC driver supports validation of SQL prepare statements and (in some cases) only if you have configured the driver to do such validation; for details, see the documentation for your JDBC driver

Related reference
Build descriptor options
sqlID
sqlPassword
sqlValidationConnectionURL
sqlJDBCDriverClass