Loading table partially



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Loading table partially

Postby biotech4amar » Wed Apr 06, 2011 1:03 pm

Hi,

I need to load Table1 from a Table2. Now, this table2 is a daily transaction log table and has huge number of rows in it. Is there a way that I can use the load utility here and only load Table1 with entries which were added/updated in Table2 for that particular day. Please let me know any solutions on this problem. I have to do the same using JCL only and not any COBOL program.
biotech4amar
 
Posts: 2
Joined: Wed Apr 06, 2011 12:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Loading table partially

Postby NicC » Wed Apr 06, 2011 2:10 pm

What tables? Are you talking about DB2 tables? If so, why is this not in the DB2 section?

JCL cannot do it. JCL tells the operating system what programs you want to run and what resources those programs need and, also, if programs are to be by-passed depending on the result of previous programs. JCL itself does not touch data.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Loading table partially

Postby biotech4amar » Wed Apr 06, 2011 2:15 pm

Thanks. I will post it there. I wanted to execute the LOAD utility using JCL hence i posted it here.
biotech4amar
 
Posts: 2
Joined: Wed Apr 06, 2011 12:57 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post