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.
- 0 Answers
- 1996 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to code the db2 queries using rexx?
can I redistribute oorexx freely with commercial software?
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 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???
what would I use uni-rexx for?
is oorexx compatible with rexx?
Enlist the features of rexx as a programming language.
what if I need to have the same application running on multiple platforms, such as unix and the mainframe? Does that mean I have to maintain two separate sources?
why is there no os/2 (ecs) port of oorexx?
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 held on the JES spool?
How do I pass parms to my ISPF Edit macro
COBOL 
