comparison of COBOL vs REXX



IBM's flagship relational database management system

comparison of COBOL vs REXX

Postby subaviji » Wed Mar 09, 2011 2:16 am

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?
subaviji
 
Posts: 3
Joined: Wed Mar 09, 2011 2:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: comparison of COBOL vs REXX

 

Re: comparison of COBOL vs REXX

Postby enrico-sorichetti » Wed Mar 09, 2011 2:19 am

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 ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: comparison of COBOL vs REXX

Postby dick scherrer » Wed Mar 09, 2011 3:39 am

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: comparison of COBOL vs REXX

Postby subaviji » Wed Mar 09, 2011 4:21 am

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...
subaviji
 
Posts: 3
Joined: Wed Mar 09, 2011 2:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: comparison of COBOL vs REXX

Postby subaviji » Wed Mar 09, 2011 4:23 am

This is going to be a repetitive task in which i need to run them in batch as and when i need to copy..
subaviji
 
Posts: 3
Joined: Wed Mar 09, 2011 2:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: comparison of COBOL vs REXX

Postby dick scherrer » Wed Mar 09, 2011 9:01 am

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).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post