Rational Developer for System z

DB2 precompiler step options

Use the DB2 Precompiler Step Options to specify properties and options to be passed to the DB2® precompiler.

Purpose

The options you specify on this window are used to generate JCL for the selected procedure. The information you provide on this window pertains to remote COBOL or PL/I compiler options.

Fields

Options: Specify DB2 preprocessing options; separate multiple options with spaces. This field is limited to 100 characters.

SYSLIB: Specify SYSLIB for DB2 preprocessing; separate multiple entries with spaces.

Database Request Module Location (DBRM): The main output from the precompiler is a database request module (DBRM). A DBRM is a data set that contains SQL statements and remote system variable information that is extracted from the source program during program preparation. The purpose of a DBRM is to communicate your SQL requests to DB2 during the bind process. Specify only one entry.

SYSTSIN Instructions: Type DB2 Plan instructions in this field. The field is echoed into the generated JCL. Currently, a sample is specified but commented out. You can uncomment the sample and make any necessary changes. The entry field should start with //SYSTSIN DD * followed by instructions or with a pointer to a data set containing the instructions.

Note: For fields that take partitioned data sets as their value, you can drag a partitioned data set name from the Remote Systems view, z/OS Projects or Enterprise Projects view, or Remote z/OS® Search results view and drop it in the field. To change the order of partitioned data set names in a field, place the cursor in the field and click Change Order from the pop-up menu.

Feedback