Page 1 of 1

comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 2:16 am
by subaviji
If i want to copy 30,000+ data from one region to other region of DB2 tables (approx 15 tables), will COBOL or REXX will be efficient?

Re: comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 2:19 am
by enrico-sorichetti
in IT effective communication is essential for problem solving
Your way of expressing the issue You are facing is ... clear as mud
30,000+ data
what 30000 things are You referring to ?

Re: comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 3:39 am
by dick scherrer
Hello and welcome to the forum,

With the little/sparse info you have provided, i suggest you unload from 1 and load into the other. You might also consider using an image copy. . .

If you provide some useful details about what you really want to do, someone may have more useful suggestions.

What "comparison" (COBOL vs REXX) are you looking for?

Re: comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 4:21 am
by subaviji
I need to copy 30,000 users from one region to other region. This copy meaning, copy DB2 data... I have 15 Db2 tables in one region say production. I need to copy data from prod to test for those 30,000 users. Depeneding on the table, the number of rows to copy per table will exceed 30,000 or equal to 30,000 for those 15 tables. For this copy, i am curious to know which coding will be efficient. Coding in COBOl or coding in REXX...

Re: comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 4:23 am
by subaviji
This is going to be a repetitive task in which i need to run them in batch as and when i need to copy..

Re: comparison of COBOL vs REXX

PostPosted: Wed Mar 09, 2011 9:01 am
by dick scherrer
Hello,

For high-volume data REXX is often the worst choice. . .

How do you identify the 30,000 users to work with? Is there a db2 table containing these "ids"? If not, creating one may help.

Once the user-id table contains the 30,000 user-ids, unload it. Unload the 15 tables individually and sort each by the user-id in the row. Using your sort product JOIN the user-ids with each of the unloaded tables creating a file of the data for the 30,000. Load this subset into the darget table(s).