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 8591

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 11199

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 6126

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

Accenture, Cap Gemini,

4 11724

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 6463

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 4548

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 5968

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

IBM,

2170

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

IBM,

2 6971

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

IBM,

1 6014

can you use symbolic parameters in JOB?

IBM,

5 7798

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 4725

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

IBM,

1 7012

What is usage pointer in cobol?

IBM,

3 16178

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 8015

Post New DB2 Questions

Un-Answered Questions { DB2 }

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1057

What type of database is db2?

913

What is database manager in db2?

968

What is db2 instance?

1019

Are views updateable?

1071

What is null value in db2?

953

what is the role of the cursor in db2?

1002

what is diffrence b/w file-aid tool and file-aid utility???

4812

How does cobol compile db2 program?

1008

Explain the function done by data manager?

1220

what is db2 restart?

2104

What is dbrm in db2 database?

1035

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9002

What is db2 look?

971

Is db2 free?

1038

For More Un-Answered { DB2 } Questions Click Here