Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 10197 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 a composite index and how does it differ from a multiple index?
Why cursor is used in db2?
What is the role of schema in the db2 database?
How can you display the current date & current time ?
What is dpf in db2?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is the use of DELGEN in DB2? Can we Write the program with out using it?
where will u check for sqlcode ?
What is ACQUIRE/RELEASE in BIND?
what is REORG? what is the use?
how to resolve -811 error. give clear explination
What are simple, segmented and partitioned table spaces ?
COBOL 
