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

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

 2 4653

What is copy book?

Thomson Reuters,

1 4465

Write a query to retrive partial string.

 2 4725

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

IBM,

4 7112

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

CTS,

1 4776

what is plan? is plan executable or package?

 4 9714

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

 3 6053

For Read Stability locks are not applicable for phantoms, What is Phantoms?

 2 5405

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

CTS,

5 17706

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 7678

how many bytes timestamp token occupies?

Boss Global, Cap Gemini, TCS,

6 13694

why we go for SPUFI for creating tables or for sql queries?

 4 8092

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

ITC Infotech, Syntel,

2745

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

Syntel,

2 11121

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

Syntel,

1 5953

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain dclgen.

714

What is buffer pool?

604

How do I change the column size in db2?

583

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

1812

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

1668




What language is db2 written in?

591

What is access path in db2?

554

How to compare data between two tables in db2?

652

Why do we use cursor?

589

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2369

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

3782

What is host variable?

585

Why do we need reorg in db2?

553

What os does db2 run on?

565

What is the clustering index in the db2 database?

575

For More Un-Answered { DB2 } Questions Click Here