Page 1 of 1

Loading table partially

PostPosted: Wed Apr 06, 2011 1:03 pm
by biotech4amar
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.

Re: Loading table partially

PostPosted: Wed Apr 06, 2011 2:10 pm
by NicC
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.

Re: Loading table partially

PostPosted: Wed Apr 06, 2011 2:15 pm
by biotech4amar
Thanks. I will post it there. I wanted to execute the LOAD utility using JCL hence i posted it here.