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


Please Help Members By Posting Answers For Below Questions

Enlist the features of rexx as a programming language.

623


can oorexx run ibm object rexx programs?

604


is oorexx compatible with rexx?

570


is there an aix version of oorexx?

564


How to run my rexx exec?

565






can I port my existing applications from the mainframe or os/2? Will there be extensive changes required to do this?

578


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?

575


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

593


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

529


Is it possible to combine uni-rexx with a compiled language in any application? What applications interfaces are there?

548


how to access data held on the jes spool?

661


What are various loop types supported by rexx?

539


How to find or access the current level of a gdg?

486


Can I cleanly uninstall oorexx?

580


why is there no os/2 (ecs) port of oorexx?

586