SQL Compile Processing
This article describes SQL Compile preprocessing.
The SQL compile phase of the
RLX
/Compile process (which can be discretely invoked as Option 4) accepts a RLX
Request Module (RRM) produced by the RLX
precompiler as input. It produces an assembly language source module which contains the static SQL statements that are extracted from the original RLX
EXEC as output. This assembly language module is then processed by the Db2 precompiler, the assembler, and the linkage editor to produce a DBRM and an NCAL load module. These outputs provide input to the final link-edit / BIND phase which eventually produces an executable load module and Db2 application plan.The SQL Compile dialog provides a similar look and feel to the single pass program preparation dialog. Through the SQL Compile dialog that you can specify a single
RLX
request module for processing. Alternatively, you can select one or more RRMs from a RLX
request module library or concatenated set of libraries. The following panel illustrates how to display all the members of a RLX
request module library.-------------------------- RLX/Compile - SQL Compile ------------------------- Command ===> RCS053 - Specify 1 or more RLX request modules whose SQL should be compiled RLX Request Module Libraries (produced by RLX precompiler) Project ===> RAI Group ===> R200===> ===> ===> Type ===> RCSRRM Member ===> (Blank or pattern for member selection list) Other partitioned or sequential data set: Data set name ===> RLX SQL Compiler options: ===> ===>
The next panel illustrates the resulting scrollable member list. Once you complete your selections, press the END PF key to tailor a jobstream which compiles each of the
RLX
request modules you selected.SQL Compile: RAI.R200.RCSRRM -------------------------------- ROW 1 OF 11 Command ===> Scroll ===> HALF Name Action Lib VV.MM Created Changed Size Init Mod ID RCSDEMO 1 RCSDEM2 1 RCSDEM3 1 RCSDMULT 1 RCSHDEMO 1 RLXESEL 1 RLXESEL3 1 RLXEUPDT 1 RLXEUPD3 1 SEMSGEN 1 SEMSLMOD 1