how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 9095 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 |
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How to define the data items to receive the fetch items for the SQL?
How can you count the number of rows from a table tab?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Define sqlca.
What is cursor stability?
What are db2 objects?
What techniques will be used to avoid deadlock??
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can record locking be achieved in those DB2 versions which do not support it?
How does DB2 determine what lock-size to use?
List out the buffer pools in db2
COBOL 
