Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can a Db2 table data be retrived through JCL?

Answers were Sorted based on User's Feedback



Can a Db2 table data be retrived through JCL?..

Answer / srikant

yes

Is This Answer Correct ?    4 Yes 3 No

Can a Db2 table data be retrived through JCL?..

Answer / kingmanish

Yes ofcourse

Use any of the unload utilities

Is This Answer Correct ?    2 Yes 1 No

Can a Db2 table data be retrived through JCL?..

Answer / azharuddinsyed

Yes,

That is how we are unloading data from table to dataset.

Is This Answer Correct ?    0 Yes 0 No

Can a Db2 table data be retrived through JCL?..

Answer / mr. cooooool

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

Post New Answer

More DB2 Interview Questions

What is a data page?

1 Answers  


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  


What is the FREE command?

1 Answers  


Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,


What is schema in db2?

0 Answers  


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  


what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


Is there any advantage to denormalizing DB2 tables?

1 Answers  


what is a collection?

2 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


what is datacom db?

2 Answers   CSC,


Categories