Rational Developer for System z

Content assistance for EXEC SQL statements

The System z® LPEX Editor, COBOL Editor, and PL/I editor provide content assist for EXEC SQL statements in COBOL and PL/I source files. When the file is associated with a property group that defines a DB2® for z/OS® database connection, content assist can also provide assistance for database elements being used by the source file.

Before you begin

To obtain content assistance for database elements, you need to associate a property group with the local COBOL or PL/I project or with the MVS™ subproject that contains the source file you are editing. This property group must contain a DB2 for z/OS database connection definition. For more information about property groups and database connections, see the following topics: If you open a file from an SCLM view, such as the SCLM Explorer View, SCLM Developer View, or SCLM Member View, specify the database connection properties in the Team > SCLM Preferences > Local Syntax Check preference page rather than a property group.

To set preferences for validation and content assist for EXEC SQL statements, use the EXEC SQL Statements preference page. For more information about setting preferences for EXEC SQL statements, see Setting preferences for EXEC SQL statements.

About this task

Content assist for EXEC SQL statements provides the following functions:

Procedure

To use content assist for EXEC SQL statements, position the cursor within an EXEC SQL statement and press Ctrl+Spacebar.


Feedback