Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 10106 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 |
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is the maximum size of a char data type in db2?
Explain the contention situations caused by locks?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What are some SQL aggregates and other built-in functions?
What is cursor in dbms?
difference between group clause and order clause
What is dbrm? What it contains? When it will be created?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Explain the use of the WHERE clause?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
COBOL 
