Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 10205 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 synonym? How is it used?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What is cursor stability?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is DCLGEN ?
How to find the number of rows in db2 tables?
what is the maximum number of tables that can be joined ?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is the logical entity between plan and Package?
What is the maximum No of rows per page?
What is ACQUIRE/RELEASE in BIND?
How to test SQL -911 error while developing COB-DB2 program
COBOL 
