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.

 2062

How to select the duplicate rows from a table?

 4 8618

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

Satyam,

2126

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

Satyam,

1 7559

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,

2178

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

IBM,

2 6387

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

IBM,

2 7088

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 10822

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 6677

how 2 resolve the -311 sqlcode

 1 18951

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

 3 11389

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

Mphasis,

2250

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

 1 4888

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

ANZ,

4 9925

how can you access index

IBM, Tech Mahindra,

4 9630

Post New DB2 Questions

Un-Answered Questions { DB2 }

List down the types of triggers in the db2 database?

1022

Can we insert update delete in view?

967

What is access path in db2?

984

What is iseries database?

1046

Mention some fields that are a part of sqlca.

1016

List some fields from sqlca?

1056

What is dclgen in db2?

1143

Can one database have multiple instances?

1052

How to access db2 tables in mainframe?

1051

is it compulsory commitment control in journal?

2474

How does db2 sample database connect?

1024

How can the duplicate values be eliminated from db2 select?

1103

What is the use of with ur in db2?

1052

What is the physical storage length of time data type?

1123

What is cobol db2?

996

For More Un-Answered { DB2 } Questions Click Here