Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 9976 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
What is package in db2 mainframe?
Is db2 a mainframe?
What is multi row fetch in db2?
List down the types of triggers in the db2 database?
Is ibm db2 open source?
Before you give the explain statement, what are the prerogatives?
What does sqlcabc has?
What is scrollable cursor in db2?
What are the uses of db2 optimizer?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
List some fields from sqlca?
What are packages in db2?
What is null value in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
