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
- 2009 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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
When will a port of ooRexx to "XYZ" be available?
Is it possible to port existing applications from the mainframe or os/2? Are there major 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
What do unusual return codes such as -3 and 0196 mean?
If I have limited experience with Rexx or it's been a long time since I've used it, what kind of help is available to get me started?
can oorexx run ibm object rexx programs?
What is the difference between ooRexx and IBM's Object REXX for Windows?
What is the use of uni-rexx?
What are the various error conditions seen in rexx?
Can anyone provide me the source code for LOC(lines of code) counter written in REXX language which can run on IBM mainframe z/OS V1R4. The LOC counter should be able to count the comments,lines of code,blank lines in a COBOL program and JCL's
i want new rexx tool which will perform jcl chk without submitting it
COBOL 
