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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Can a Db2 table data be retrived through JCL?

Question Posted / naliniknayak@gmail.com

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 page?

2 Answers  

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

What is the use of dclgen in db2?

0 Answers  

What does runstats do in db2?

0 Answers  

What is query_cache_limit?

0 Answers  

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

Where are plans stored?

2 Answers  

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

Why db2 is called db2?

0 Answers  

can we drop column from a table

7 Answers   INDUS,

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

For more DB2 Interview Questions Click Here
Categories