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

DB2 Interview Questions

Questions Answers Views Company eMail

What techniques will be used to avoid deadlock??

IBM, SUN,

5 14165

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 17770

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 18320

pls tell me abt the normalization five types....

2 5703

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

Cap Gemini, Verizon,

4 11483

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

Cap Gemini, RBS,

3 12631

Can we able to find all the Table names under a Particular Plan?

CTS,

1 6549

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

Cap Gemini,

1 8369

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 11220

What if we fail to give values in columns declared as NOT NULL ?

Cap Gemini,

3 9744

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

Cap Gemini,

2 9145

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

Cap Gemini,

1 6512

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

Cap Gemini,

3 12659

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

2341

How Plan is created while executing the query using SPUFI?

3 8474

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you find the maximum value in a column in db2?

1057

what is a corelated subquerry?

1065

How is the value function used?

1082

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1027

How can record locking be achieved in those DB2 versions which do not support it?

1021

What is the role of union all and union

1071

Is db2 free?

1038

Define declaration generator (dclgen).

1068

What are union and union all?

921

What is package in cobol db2?

1079

What is the role of data manager in the db2 database?

1053

Why cursor is used in db2?

986

What is coalesce in db2?

1058

can all users have the privilage to use the sql statement select * (dml)?

1107

What is an instance database?

1007

For More Un-Answered { DB2 } Questions Click Here