validateSQLStatements

The validateSQLStatements build descriptor option indicates whether SQL statements are validated against a database at generation time. EGL connects to the database in one of the following ways:

• If you are generating in the workbench, EGL uses the connection currently specified in the EGL Preferences. You can find those preference settings by following these steps:
  1. Open the Preferences window by clicking Window > Preferences.
  2. On the left side of the Preferences window, expand EGL and click SQL Database Connections.
  3. Under Connection details, fill in the connection information in the field, or click New to use the wizard to set up a new connection.
• If you are using the EGL SDK, EGL uses the sqlJDBCDriverClass and sqlValidationConnectionURL build descriptor options.

In either case, you might need to set the sqlID and sqlPassword build descriptor options.

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 might 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 information, see the documentation for your JDBC driver.