Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kingmanish
Yes ofcourse
Use any of the unload utilities
| Is This Answer Correct ? | 2 Yes | 1 No |
Yes,
That is how we are unloading data from table to dataset.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi...............
Use the Following jcl to retrived the Db2 table data.
//SYSREC00 DD DSN=COOL.UNLOAD.SYSREC02,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(MOD,CATLG)
//SYSPUNCH DD DSN=COOL.UNLOAD.SYSPUNC1,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(MOD,CATLG)
//SYSIN DD *
SELECT * FROM SYSIBM.SYSTABLES WHERE OWNER = 'COOL123';
/*
//
THANKS
| Is This Answer Correct ? | 3 Yes | 4 No |
Explain the contention situations caused by locks?
What is subquery ?
how can i pull up a query which was previously stored in qmf
What is the purpose of using commit?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the usage of open cursor command?
What are db2 tables?
What is the purpose of the DSNC transaction ?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
COBOL 
