how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 10285 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 |
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
is it possible to get -811 error when you use cursors. why?
What is the difference between dbm cfg and db cfg file in db2 ?
how to check the table is empty or not?
How do I create a view in db2?
What is copy book?
What is a buffer pool?
pls tell me abt the normalization five types....
What is db2 optimizer?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
COBOL 
