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.

2065

How to select the duplicate rows from a table?

4 8626

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 7566

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,

2180

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

IBM,

2 6398

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

IBM,

2 7096

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 10829

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 6683

how 2 resolve the -311 sqlcode

1 18958

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

3 11395

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

Mphasis,

2253

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

1 4890

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

ANZ,

4 9936

how can you access index

IBM, Tech Mahindra,

4 9642


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is database reorganization?

1125


What's The Error Code For Unique Index Voilation?

1237


Explain what are the various isolation levels possible?

1044


What is db2? Explain.

1043


How do I add a column to an existing table in db2?

1032


What is bind in db2?

1042


How do I delete a table in db2?

1071


Explain dclgen.

1199


What is ibm db2 used for?

1080


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044


what is a corelated subquerry?

1122


How can deadlocks be resolved?

936


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

2126


What are db2 tables?

1125