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
- 1 Answers
- 4533 Views
- I also Faced
- E-Mail Answers
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 |
for which platforms is uni-rexx available?
How to code the db2 queries using rexx?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
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
I want to set position for a particular text in a certain position in several of my cics maps.Please provide me with a solution. Ex: If "F1-Help" has to be set to pos(4,27) always in all the maps within a PDS.
can oorexx run ibm object rexx programs?
i want to code a rexx program in order to get the inputfile and output files of jcl. i want code snippet or the coding for this , please
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 new rexx tool which will perform jcl chk without submitting it
When will a port of ooRexx to "XYZ" be available?
I am tryin to select one records(SQL) using Rexx.Here is the code ADDRESS DSNREXX "EXECSQL FETCH C1 USING DESCRIPTOR :TBSQLDA" IF SQLCODE = 0 THEN DO LINE = '' DO I = 1 TO TBSQLDA.SQLD LINE = LINE TBSQLDA.I.SQLDATA END I SAY LINE END ADDRESS DSNREXX "EXECSQL CLOSE C1" ADDRESS DSNREXX 'DISCONNECT' i am getting the following errors and also i dont know wr to see the ouput.Can anyone please hlep me in solving this? 28 +++ ADDRESS DSNREXX 'DISCONNECT' Error running DB2REXX, line 28: Incomplete DO/SELECT/IF
is there an aix version of oorexx?
COBOL 
