I want to code a REXX Program in order to load many tables
in a database simultaneously in a batch fashion. Currently
batch codes ar available in which only one job is submitted
at a time and this loads only one table. My requirement is
that many tables should be loaded at a time when one Job is
submitted and can this be done using REXX Tool??? I want
code snippet or the coding for this , please
Answer / wolfgang
Hi,
you may code different jobs for each tables to be loaded.
e.g.
//LOADJOB1 JOB
.
.
//LOADJOB2 JOB
.
.
//LOADJOBn JOB
.
.
Each Job must have a different jobname and must run in a
Jobclass that supports parallel execution of Jobs.
Then you may code a REXX Batchjob which submits the
different Loadjobs.
//TSO EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD DUMMY
//SYSTSIN DD *
SUBMIT 'Datasetname holding JCL for Loadjob 1'
SUBMIT 'Datasetname holding JCL for Loadjob 2'
.
.
SUBMIT 'Datasetname holding JCL for Loadjob n'
| Is This Answer Correct ? | 2 Yes | 0 No |
I am new to rexx db2 ,can anyone help me by expalinin how to code the db2 queries using rexx,and also plz send some link and examples using db2 queries.
Can I cleanly uninstall oorexx?
how to pass parms to ispf edit macro?
How to run my rexx exec?
What does the sample library of uni-rexx consist of?
Suppose if there are a set of statements and each has a word “value” in it, if I want to display all these statements so that the word “value” is aligned, then how do I code this in rexx?
I want to code a REXX Program in order to load many tables in a database simultaneously in a batch fashion. Currently batch codes ar available in which only one job is submitted at a time and this loads only one table. My requirement is that many tables should be loaded at a time when one Job is submitted and can this be done using REXX Tool??? I want code snippet or the coding for this , please
How do I access data in control blocks such as jobname?
is oorexx compatible with rexx?
I executed one job and I forget to save the final JCL. But took an XDC from SPOOL. Now I want to recover the JCL from XDC dataset. Is there any process to do this?. (Manually it takes a lot of time). Is there
Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?
how to access data in control blocks such as jobname?