how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 9385 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raghu
by using DSNUTLIB utility .
in dsnutlib of unload utility we first unload table data into file ,from that file we can load data into gdg/vsam files by idcams .
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anilkumar
do you need to unload more than 2 tables in a single unload step
Then need to specify sysrec01,syrec02 in jcl step
and in sysin
specify like this
select * from tab1 with ur; ---- data extrcat into sysrec01
select *from tab2 with ur; ----- data extract into sysrec02
this sort of jcl's we used in our project
but the same thing is not work for if you used union and
union all in the queries.
| Is This Answer Correct ? | 0 Yes | 1 No |
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What Utility is used to migrate DB2 from one release to the next?
Which catalog table stores referential constraints?
What is phantom read in db2?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is sqlcode -922 ?
What is a precompiler?
What is reorg and runstats in db2?
What are the contents of dclgen?
What are the isolation levels possible ?
What can the Locate option of the Repair Utility accomplish?
How to find last record before record through SQLRPGLE?
COBOL 
