Loading table partially
Posted: 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.
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.