DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

how can u retrieve the data from null values using applicaion program.

TCS,

3 8784

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 11330

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

IBM,

1 6227

what is the differences between spufi and qmf and which is better?

Accenture, Cap Gemini,

4 11930

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 6603

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

L&T, UST,

2 4676

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

UST,

1 6067

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

IBM,

2210

is it possible to get -811 error when you use cursors. why?

IBM,

2 7090

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

IBM,

1 6098

can you use symbolic parameters in JOB?

IBM,

5 8001

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

IBM,

1 4807

How to solve S0C7 abend with out using DISPlay in 10 mins?

IBM,

1 7100

What is usage pointer in cobol?

IBM,

3 16361

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

IBM,

3 8155

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to take backup of table in db2?

1070

Define db2 and its databases?

1054

define clustering index.

1023

What is host variable in db2 cobol?

1075

How does coalesce work?

1012

What is runstats db2?

1017

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

Is db2 free?

1093

What is sqlca?

1065

What are concurrency issues?

1094

What is database alias db2?

1123

List down the data types in the db2 database.

1115

what is the responsibility of the construction superintendent

2140

What is the function of logging in the db2 database?

1120

Name the lockable units in DB2?

1126

For More Un-Answered { DB2 } Questions Click Here