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
Answer Posted / 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 |
Post New Answer View All Answers
can oorexx run normal rexx programs?
What are various loop types supported by rexx?
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?
for which platforms is uni-rexx available?
Is it possible to port existing applications from the mainframe or os/2? Are there major changes required to do this?
what would I use uni-rexx for?
What does the sample library of uni-rexx consist of?
How to run my rexx exec?
what is uni-rexx?
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 the various error conditions seen in rexx?
how to pass parms to ispf edit macro?
can oorexx run ibm object rexx programs?
Can I combine uni-REXX with a compiled language in my application? What application programming interfaces are available? For example, can I share variables between uni-REXX and a compiled language?