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 14401

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 17964

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

3 18487

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

2 5852

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 11697

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 12816

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

CTS,

1 6644

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

Cap Gemini,

1 8461

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 11461

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

Cap Gemini,

3 9910

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

Cap Gemini,

2 9273

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 6621

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 12838

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.

2387

How Plan is created while executing the query using SPUFI?

3 8631

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the bind parameters ibm db2?

1046

What is host variable?

1054

How to resolve deadlock issue

20113

What is a db2 collection?

1035

Is db2 free?

1094

Why db2 is called db2?

1036

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

1036

What is the latest version of ibm db2?

1267

Mention the different locking levels that are available in db2.

1127

What is host variable in db2 cobol?

1077

Mention the various locks that are available in db2.

1035

What type of database is db2?

965

Define predicate?

1129

How to create backup table in db2?

1089

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2363

For More Un-Answered { DB2 } Questions Click Here