sqlDB

The sqlDB build descriptor option specifies the default database used by a generated Java program that runs outside of J2EE. The value is a connection URL; for example, jdbc:db2:MyDB.

The sqlDB build descriptor option is case-sensitive, has no default value, and is used only when you are generating a non-J2EE Java program. The option assigns a value to the vgj.jdbc.default.database Java runtime property, but only if the genProperties build descriptor option is set to GLOBAL or PROGRAM.

To specify the default database for a J2EE program, set the sqlJNDIName build descriptor option.

If you set the validateSQLStatements build descriptor option to YES, the location of the database used for generation-time validation of the SQL statements is determined in the following manner:
  • 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.