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 4679

What is copy book?

Thomson Reuters,

1 4481

Write a query to retrive partial string.

 2 4738

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 7141

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 4783

what is plan? is plan executable or package?

 4 9728

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

 3 6089

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

 2 5423

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

CTS,

5 17747

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

2 7694

how many bytes timestamp token occupies?

Boss Global, Cap Gemini, TCS,

6 13714

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

 4 8108

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,

2757

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 11140

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 5967

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between nvl and coalesce?

600

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

582

What is a collection in db2?

579

Define declaration generator (dclgen).

665

What is runstats utility in db2?

569




What are the contents of dclgen?

652

What is image copy in db2?

566

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

644

What is the physical storage length of timestamp data type?

640

What type of database is db2?

523

How would the varchar column remarks defined?

633

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1799

How is a typical db2 batch pgm executed?

638

Define sqlca.

647

How many databases can be created inside an instance in db2 ?

597

For More Un-Answered { DB2 } Questions Click Here