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
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?
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?
When will a port of ooRexx to "XYZ" be available?
Can I cleanly uninstall oorexx?
how to access data held on the jes spool?
I just know the Panvalet dataset name, i would like to search all the members of that dataset for particular keyword through Rexx. how to achive? please suggest. Is it possible to open panvalet member in browse mode using Rexx? Your help would be appreciated very much. Thanks in advance.
how to pass parms to ispf edit macro?
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
does uni-rexx give me any capabilities designed specifically for the unix environment?
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?
what is uni-rexx?
How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?
How to find or access the current level of a gdg?