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 8817

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 11343

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 6264

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

Accenture, Cap Gemini,

4 11960

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 6619

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 4693

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 6081

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

IBM,

2222

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

IBM,

2 7113

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

IBM,

1 6101

can you use symbolic parameters in JOB?

IBM,

5 8018

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 4820

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

IBM,

1 7112

What is usage pointer in cobol?

IBM,

3 16391

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 8179

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is coalesce in db2?

1139

What is cursor stability in db2?

1363

How and when does the db2 enforces the unique key?

1086

How is a typical db2 batch pgm executed?

1182

what is the responsibility of the construction superintendent

2151

Can we delete records from view?

972

Is db2 a programming language?

1054

Why do chiropractors use drop table?

1114

What do you mean by between and in? Is between inclusive of specified range values?

1092

What is the cobol picture clause of the db2 data types date, time, timestamp?

1069

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1078

How can you find out the # of rows updated after an update statement?

1116

What is dpf in db2?

1115

What is cloudant database?

1104

What is view db2?

1085

For More Un-Answered { DB2 } Questions Click Here