Defining Editor Preferences

You can set options for content assist and real-time syntax checking fort the SQL Editor as well as 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 editors.

To enable these features, a local cache of your database's schema, table, and column names will be automatically managed based on the database you linked from this page.

Procedure

  1. In the Preferences window, expand Db2 for z/OS and select Editors.
  2. 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 for EXEC SQL statements.
    • Include Schema, Table and Column Proposals: Contributes database-specific proposals to the content assistant for the COBOL, PL/I and SQL Editors.
    • Start connections when needed: Enables Developer for z/OS® to attempt to connect to a database when necessary 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 must connect to the database to enable content assist or validation.
    • Work offline when possible: Enables Developer for z/OS® 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 and the date of their last modification. If no offline cache files are available, this area is hidden.
    • Filters: This button will open the Filters property page for the selected Db2 for z/OS connection. These filters can be used to limit which database schemas are in scope for syntax validation and content assistance.
    • Reload: Use the Reload button to refresh the offline database cache with the latest values from the database's catalog.
  3. Click OK to save your changes.