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

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.

2109

How to select the duplicate rows from a table?

4 8776

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

Satyam,

2172

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

Satyam,

1 7663

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,

2219

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

IBM,

2 6508

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

IBM,

2 7196

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 10992

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 6746

how 2 resolve the -311 sqlcode

1 19056

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

3 11518

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

Mphasis,

2308

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

1 4958

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

ANZ,

4 10104

how can you access index

IBM, Tech Mahindra,

4 9798


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 stogroup?

1220


what is the role of the cursor in db2?

1109


How to create db2 table in mainframe?

1214


What is dclgen (declaration generator)?

1110


Explain dclgen.

1266


Explain about rct.

1129


What is a storage group (stogroup)?

1284


What is buffer pool?

1156


What is db2 bind?

1127


How can you do the explain of a dynamic sql statement?

1106


What is a cursor in programming?

1111


What is a bind in db2?

1100


What is a db2 tablespace?

1116


How can we read records for specific member in CL? AND rpg?

756


What db2 400?

1249