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
- 5531 Views
- I also Faced
- E-Mail Answers
Answer / nbohr02
Not exactly sure what you are asking.
Can a REXX exec submit multiple jobs via the internal
reader? Yes.
Can you update multiple tables in a RDBMS? Yes, however
referential integrity could be compromised and RDBMS
overhead could be a serious issue.
Let's assume that you have that you are seeking to load DB
tables from a 100K+ 1NF file which has some 6257 bytes per
recode You would use REXX (CMSPIPES) to split the file while
keeping a common key. You would split this 1nf record in 3nf
tables. You would need to know the data and some aspects on
how it will be used --- Remember Data Privacy is important too.
| Is This Answer Correct ? | 0 Yes | 2 No |
i'm getting error while editing macro, its not even entering into the macro, getting error like 31 *-* "EDIT DATASET('"DSN"("MEM")') MACRO("CHGLINE")" +++ RC(-3) +++ ? any idea why?
Can I cleanly uninstall oorexx?
What does the sample library of uni-rexx consist of?
how long does the install of oorexx take?
how to pass parms to ispf edit macro?
i want new rexx tool which will perform jcl chk without submitting it
Suppose 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?
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?
How do I access data held on the JES spool?
I want to open particular list of members inside pds.Let me know whether below code will work.if not tell me how it works INPUT='DDM.DATASET(AAA*)' X = OUTTRAP(MEMS.)
What are various loop types supported by rexx?
COBOL 
