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



I want to code a REXX Program in order to load many tables in a database simultaneously in a batch..

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

Post New Answer

More REXX Interview Questions

What are various loop types supported by rexx?

0 Answers  


does uni-rexx give me any capabilities designed specifically for the unix environment?

0 Answers   IBM,


When will a port of ooRexx to "XYZ" be available?

0 Answers  


Can I cleanly uninstall oorexx?

0 Answers   IBM,


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.

0 Answers  


How to code the db2 queries using rexx?

0 Answers  


have you already used rexx - even for limited purposes? Do you need to maintain a high level of productivity during your transition to unix?

0 Answers   IBM,


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

0 Answers   Wipro,


how to access data in control blocks such as jobname?

0 Answers   IBM,


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.)

0 Answers   Mind Tree,


can oorexx run ibm object rexx programs?

0 Answers   IBM,


Enlist the features of rexx as a programming language.

0 Answers  


Categories