Illustrative RLX/Compile Program Preparation Jobstream
RLX
/Compile Program Preparation JobstreamProvides an example of a
RLX
/Compile job that prepares the REXX exec that is named EXAMPLE that runs as a compiled REXX procedure with an associated static SQL application plan.The following sample provides an example of a
RLX
/Compile job that prepares the REXX exec that is named EXAMPLE that runs as a compiled REXX procedure with an associated static SQL application plan. This jobstream produces the following three entities that together run in place of the REXX SQL exec named EXAMPLE.(1)
(2)
(3)
S
. The name of the SQL load module EXAMPLES
must be different from the compiled REXX load module name because they are two discrete entities that are loaded and active at the same time.The numbers in the right margin correspond to the numbered paragraphs that follow:
//RLXCOMP JOB (...) //*-------------------------------------------------------------------- //* RLX/COMPILE THE RCSDEMO EXEC //*-------------------------------------------------------------------- //STEP1 EXEC RCSPC,// SQLEXEC=EXAMPLE,(1)// SQLREQ=EXAMPLE(2)//RCSP.RCSPARMS DD *(3)NAME(EXAMPLE) //*-------------------------------------------------------------------- //* ACCELEREXX COMPILE PRECOMPILED EXEC RCSDEM1 //*-------------------------------------------------------------------- //STEP2 EXEC RCXC,(4)// EXEC=EXAMPLE(5)//RCXPARMS DD *(6)CSECT(EXAMPLE) //*-------------------------------------------------------------------- //* LINK EDIT THE COMPILED REXX LOAD MODULE RCSDEMO //*-------------------------------------------------------------------- //STEP3 EXEC RCXLKED,(7)// CSECT=EXAMPLE, // LMOD=EXAMPLE //*-------------------------------------------------------------------- //* CREATE THE SQL REQUESTOR LOAD MODULE //*-------------------------------------------------------------------- //STEP4 EXEC RCSRCP,(8)// SQLLREQ=EXAMPLES,(9)//RCSPARMS DD *(10)RLXSQL,EXAMPLE //*-------------------------------------------------------------------- //* BIND THE STATIC Db2 APPLICATION PLAN //*-------------------------------------------------------------------- //STEP5 EXEC RCSBIND(11)//RCSPARMS DD *(12)RAI2,EXAMPLE,DSX,61,EXAMPLE(13)
(1)
(2)
(3)
It is only necessary that the SQL requestor load module and compiled REXX load module names be different since these two modules are active at the same time. The compiled SQL and compiled REXX object modules that comprise them may have the same names -- provided they are compiled into separate object libraries.
(4)
(5)
(6)
(7)
(8)
(9)
(10)
S
) is different from the name EXAMPLE that is assigned to the compiled REXX load module.(11)
RLX
SQL object module is specified first, followed by the static SQL object module named EXAMPLE.(12)
(13)