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 14408

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 17979

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

3 18498

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

2 5858

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 11706

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 12820

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

CTS,

1 6651

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

Cap Gemini,

1 8467

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 11476

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

Cap Gemini,

3 9912

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

Cap Gemini,

2 9276

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 6624

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 12839

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.

2392

How Plan is created while executing the query using SPUFI?

3 8638

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is buffer pool in the db2 database?

1103

What is cloudant database?

1096

What is the use of runstats in db2?

1109

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

What is the use of reorg in db2?

1084

What is cascading rollback?

1214

What is access path in db2?

986

Can there be more than one cursor open for any program?

1169

What is scrollable cursor in db2?

1055

What is cursor stability in db2?

1356

How does db2 sample database connect?

1029

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

1168

How does a cursor work?

985

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1437

What is bind in db2?

1042

For More Un-Answered { DB2 } Questions Click Here