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
DB2 Interview Questions
Questions Answers Views Company eMail

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

 2071

How to select the duplicate rows from a table?

 4 8645

How do we specify index to include or not during bind process.

Satyam,

2132

How to test SQL -911 error while developing COB-DB2 program

Satyam,

1 7584

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

IBM,

2185

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

IBM,

2 6405

can we view the access paths created by dbrm ? how ? thx

IBM,

2 7104

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

IBM,

5 10850

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

IBM,

1 6693

how 2 resolve the -311 sqlcode

 1 18973

how can i pull up a query which was previously stored in qmf

 3 11409

What r the comman abends in db2, jcl and cobol???????

Mphasis,

2259

what is diffrence b/w file-aid tool and file-aid utility???

 1 4898

how to get duplicate records from tables?write qurey for this?

ANZ,

4 9957

how can you access index

IBM, Tech Mahindra,

4 9656

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can we retrieve the total number of records in RPG & CLLE?

659

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1202

What is a page in db2?

1029

What is the result of open cursor statement?

1085

Mention the downsides of page level lock.

1165

Explain in detail about buffer manager and its functionalities?

1073

What is collection in db2 bind?

1021

What is precompiler in db2?

1026

Explain in brief how does db2 determine what lock-size to use?

1047

What is isolation level in db2?

1015

What is reorg?

1165

What is role in db2?

1113

What do you mean by rollback?

993

what is the sqlcode -501

13170

What is buffer pool?

1110

For More Un-Answered { DB2 } Questions Click Here