mainframe discussion forum - cobol, db2,cics, interview questions, quizs
Interview Questions 1 |  Interview Questions 1 |  Interview Questions 2 |  Interview Questions 3 |  Interview Questions 5 | 
Interview Questions 6 |  Interview Questions 7 |  Interview Questions 8 |  Interview Questions 9 |  Interview Questions 10 | 
Interview Questions 11 |  Interview Questions 12 |  Interview Questions 13 |  Interview Questions 14 |  Interview Questions 15 | 
Interview Questions 16 |  Interview Questions 17 |  Interview Questions 18 |  Interview Questions 19 |  Interview Questions 20 | 
Interview Questions 21 |  Interview Questions 22 | 

DB2 INTERVIEW QUESTIONS - Page 10
Java inteview questions
DB2 SQL Tutorial
Mainframe inteview questions
DB2 Discussion Forum


 

46) Where is the output of EXPLAIN stored?

In userid.PLAN_TABLE

47) EXPLAIN has output with MATCHCOLS = 0. What does it mean?

a nonmatching index scan if ACCESSTYPE = I.

48) How do you do the EXPLAIN of a dynamic SQL statement?

1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement

2. Include EXPLAIN command in the embedded dynamic SQL statements

49) How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

Use a question mark in place of a host variable ( or an unknown value ). e.g.

SELECT EMP_NAME

FROM EMP

WHERE EMP_SALARY > ?

50) What are the isolation levels possible ?

CS: Cursor Stability

RR: Repeatable Read

 
DB2 INTERVIEW QUESTIONS - advertisement

Previous Page -  DB2 Interview Questions faqs Next Page - DB2 Interview Questions faqs





Java inteview questions     DB2 SQL Tutorial     Mainframe inteview questions >    Mainframe inteview questions


DB2 DISCUSSION TOPICS IN MAINFRAMEGURUKUL.COM

DB2 query !!
DB2 Certification
db2 703 application developmetn certification
DB2
db2 query
How to know the Primary and Foriegn keys?
Inserting NULL
bulk insert
Call & Execute a COBOL-DB2 from a COBOL program?
Important Links Mainframes
SQL update query - need help urgently please
Reg: DCLGEN copybook compilation
Testing a field in db2.
Using Index
doubt in db2
Locking Heirarcy and Compatibility?
what s the difference between DB2 & ADB2?
Performance tuning..
Various Locking mechanism for cursors and other SQL?
IJKEFT01 or IJKEFT1A
Calling a COBOL DB2 subroutine using non-DB2 program
PERFORMANCE TUNING.
Finding PLAN(or Package)
Updating a Table?
DB2 References
SINGLE ROW
A query in DB2 with "<>".
Query on SQL
How to handle the null indiactor
Reg: CASE usage in DB2
Reg : DB2 700 certification
DB2 table -selective download to a flat file
db2 certification
latest and best DB2 certification
DB2 Questions - answers required.
DB2 catalog tables
Reg:Performance of a DB2 query
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram - Sugg
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram
Reg : DB2 certifications
DSNTIAUL
Deleting large numbers of rows quickly
NULL value
DB2 Certification Guidelines
date -updation
DB2 PERFORMANCE TUNING TIPS
DB2 Certification
how to reteieve the cursor randomly??
Db2 DBA training needed
current date,time
Stored procedure parm limit
chords---help
db2
db2 doubt
FOREIGN KEY
VSAM LDS used in DB2
PACKAGE VS PLAN ?
to overcome -407 error in Db2
ROWID
SQLCA
CURSOR
To update a Comment in Lower case in DB2
What is the diff between declaring a cursor in WSS or PD?
How to display in SYSOUT?
DB2 Cursor
new member
query on sql
how to proceed
which is the best
pls help me abt these questions..
foreign key
CAST function
thanks
DB2 checkpoint-restart doubts
db2 begginer
cursors
cursors
how to resolve abends
CONSTRAINT with ON DELETE CASCADE
DB2 Query
with Hold cursor in a stored procedure
Difference between IBMLOAD and BMCLOAD
How you add column in between a table?
Partition 1 is in Copy Pending
I am beginer in db2 , why r using bind ,plan & packge?
sql query required
DB2 SQL CODE -904 Explainations
how to see VSAM DATASET
Hi, query for table structure?
Array setup
can any one tel something about db2 loading
Get week from date
How to add two coloumns of table inm DB2
Db2 Certificaiton Info needed
DB2 certification
DB2 basic
DB2 COMMIT??
Regarding Host variables
Doubt in cursor
HOME
DB2 Interview Questions  |  COBOL Interview Questions  |  JCL interview questions  |  JCL interview questions  |  vsam Interview Questions  |  cics Interview Questions  
|
DB2 Interview Questions  |  COBOL Interview Questions  |  JCL interview questions  |  JCL interview questions  |  vsam Interview Questions  |  cics Interview Questions 1