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.

 1644

How to select the duplicate rows from a table?

 4 7133

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

Satyam,

1667

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

Satyam,

1 6694

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,

1701

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

IBM,

2 5353

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

IBM,

2 6226

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 8977

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 5945

how 2 resolve the -311 sqlcode

 1 17744

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

 3 9948

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

Mphasis,

1808

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

 1 4166

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

ANZ,

4 8414

how can you access index

IBM, Tech Mahindra,

4 8070

Post New DB2 Questions

Un-Answered Questions { DB2 }

B37 abend during spufi?

970

What is isolation level in db2?

571

What is ibm db2 client?

512

What is database alias db2?

589

What is null in db2?

567




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

609

Which component is responsible for processing sql statements and selecting access paths?

646

Define check constraint.

633

How would the varchar column remarks defined?

621

How do I start db2 in windows?

553

What is a storage group (stogroup)?

766

How does coalesce work?

574

What is page size in db2?

559

What is the use of runstats in db2?

567

What is the maximum No of rows per page?

618

For More Un-Answered { DB2 } Questions Click Here