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
- From the menu bar, click Window > Preferences and then expand Data Management and SQL
Development.
- Click EXEC SQL statements.
- 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.
- Click OK to save your changes.