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
- 4291 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 |
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
I have one input file and some 40 tables, I want to read input file and compare the input file value with the table value if it is present then we have to update with new value, this should be repeated for all 40 tables and we are reading only one input file, for this is there any REXX program or job or routine to accomplish above requirement. components of the requirements; 1. One input file 2. 40 DB2 tables 3. we have to read from the input file and compare with table value, if present then update with new value (this should be recurssive for all 40 tables for every record of input file). 4. quick help is appreciated.
why is there no os/2 (ecs) port of oorexx?
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. e.g - The value of X is Y. Wot is its value? Do u know its value? I want to know its value.
Enlist the features of rexx as a programming language.
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.
What is the use of uni-rexx?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?
How do I find or access the current level of a GDG?
how to pass parms to ispf edit macro?
How do I access data in control blocks such as jobname?
COBOL 
