Rational Developer for System z

Setting preferences for EXEC SQL statements

Use the EXEC SQL statements preference page to set options for content assist and real-time syntax checking for EXEC SQL statements in COBOL and PL/I programs.

About this task

The options on this page set preferences for content assist and real-time syntax checking in the System z® LPEX Editor, COBOL Editor, and PL/I Editor.

Procedure

  1. From the menu bar, click Window > PreferencesWindow > Preferences and then expand Data Management and SQL Development.
  2. Click EXEC SQL statements.
  3. You can set the following preferences:
    • Validate statement syntax: Enables real-time syntax checking for EXEC SQL statements.
    • Validate database references: Enables real-time validation of database elements.
    • Show database objects: Enables a database connection to be queried for content-assist.
    • Start connections when needed: Enables Rational® Developer for System z to attempt to connect to a database when needed to complete a requested content-assist or validation request. If the password is not stored in the connection profile, you are prompted to enter it when the connection is made. If you clear this option, you will need to connect to the database to enable content assist or validation.
    • Work offline when possible: Enables Rational Developer for System z to complete a content-assist or validation request by using an offline database cache. This preference takes precedence over the Start connections when needed option. If both options are enabled, the offline option is preferred.
    • These databases are ready for working offline: Lists databases that have an offline cache available. If no offline cache files are available, this area is hidden.
  4. Click OK to save your changes.

Feedback