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
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?
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 is the use of uni-rexx?
can oorexx run normal rexx programs?
i want new rexx tool which will perform jcl chk without submitting it
why is there no os/2 (ecs) port of oorexx?
does uni-rexx give me any capabilities designed specifically for the unix environment?
Suppose if there are a set of statements and each has a word “value” in it, if I want to display all these statements so that the word “value” is aligned, then how do I code this in rexx?
how long does the install of oorexx take?
How to code the db2 queries using rexx?
How to find or access the current level of a gdg?
what would I use uni-rexx for?
have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?
is oorexx compatible with rexx?
I want to set position for a particular text in a certain position in several of my cics maps.Please provide me with a solution. Ex: If "F1-Help" has to be set to pos(4,27) always in all the maps within a PDS.