1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

 1586

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

 2 4676

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

8 11847

wht happens if we close cursor with cursor with hold option?

Valtech,

3 11119

what is main use of table space and index object? please its urgent

CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

5 14064

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

IBM,

3 16861

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

IBM, TCS,

1682

How can we define a table? How can we apply SEARCH ALL on it ?

 1 3762

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

Deloitte,

2 5631

what is the use of commit ? and what is the syntax?

Deloitte,

2 9255

what is the difference between declaring the cursor in WS section and Procedure division?

HCL,

1 7471

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

Cap Gemini,

9 11402

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

 1 9152

Can any one tell me about Restart logic in DB2.

 2 6366

Do we need cursor for Count(*)?

iGate,

4 7587

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the downsides of page level lock.

719

Comment whether the cursor is closed during commit or not.

680

Define data page.

639

Explain dclgen.

730

Give the name of some fields form sqlca.

616




What is meant by explain?

668

How do you eliminate duplicate values in db2?

692

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3799

What is phantom read in db2?

650

How to access db2 tables in mainframe?

619

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

593

What is db2? Explain.

609

Explain db2.

626

What are db2 tables?

653

What is dbrm? What it contains?

688

For More Un-Answered { DB2 } Questions Click Here