Explore topic-wise InterviewSolutions in .

The main DISADVANTAGE is the high resource UTILIZATION if large UPDATES are to be done.

The main disadvantage is the high resource utilization if large updates are to be done.

1. BASED on the lock-size given while CREATING the tablespace
2. Programmer can direct the DB2 what lock-size to use
3. If lock-size ANY is specified, DB2 USUALLY choses a lock-size of PAGE

PAGE, TABLE, TABLESPACE

PAGE, TABLE, TABLESPACE

During the BIND PROCESS ISOLATION ( CS/RR )

During the BIND process ISOLATION ( CS/RR )

CS: Releases the lock on a page after use

RR: Retains all locks ACQUIRED till END of transaction. ISOLATION LEVEL is a parameter for the bind process

CS: Releases the lock on a page after use

RR: Retains all locks acquired till end of transaction. ISOLATION LEVEL is a parameter for the bind process

The isolation LEVELS are CS: Cursor STABILITY RR: Repeatable READ

The isolation levels are CS: Cursor Stability RR: Repeatable Read

1.  Use SPUFI or MF to EXPLAIN the dynamic SQL statement
2.  INCLUDE EXPLAIN COMMAND in the embedded dynamic SQL statements

A NON MATCHING INDEX SCAN if ACCESSTYPE = I 

A non matching index scan if ACCESSTYPE = I 

In USER ID PLAN_TABLE

In user id PLAN_TABLE

You have to ENSURE that the PLAN_TABLE is CREATED under the AUTHID

You have to ensure that the PLAN_TABLE is created under the AUTHID

You NEED to CHECK the VALUE STORED in SQLERRD(3)

You need to check the value stored in SQLERRD(3)

SQLCODE, SQLERRM, SQLERRD

SQLCODE, SQLERRM, SQLERRD

You should USE DSN UTILITY to run a DB2 BATCH PROGRAM from native TSO An example is SHOWN: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED01TOBJLOADLIB') END Use IKJEFT01 utility program to run the above DSN command in a JCL

You should Use DSN utility to run a DB2 batch program from native TSO An example is shown: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED01TOBJLOADLIB') END Use IKJEFT01 utility program to run the above DSN command in a JCL

It not mandatory to have DECLARE TABLE STATEMENT in DCLGEN This is USED by the pre-compiler to validate the table-NAME, view-name, column name etc, during pre-compile.

It not mandatory to have DECLARE TABLE statement in DCLGEN This is used by the pre-compiler to validate the table-name, view-name, column name etc, during pre-compile.

It is not always MANDATORY to use DCLGEN USING DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would GENERATE accurate host variable definitions for the table reducing CHANCES of error.

It is not always mandatory to use DCLGEN Using DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error.

EXEC SQL DECLARE TABLE statement which GIVES the LAYOUT of the table/view in terms of DB2 datatypes. A host language copy BOOK that gives the host variable DEFINITIONS for the column Names.

EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes. A host language copy book that gives the host variable definitions for the column Names.

DATE, TIME, TIMESTAMP and its PICTURE clause in COBOL. DATE: 4bytes DATE: PIC X(10) TIME: 3bytes TIME PIC X(08) TIMESTAMP: 10bytes TIMESTAMP: PIC X(26)

DATE, TIME, TIMESTAMP and its picture clause in COBOL. DATE: 4bytes DATE: PIC X(10) TIME: 3bytes TIME PIC X(08) TIMESTAMP: 10bytes TIMESTAMP: PIC X(26)

A VARCHAR column REMARKS WOULD be defined as follows: 10 REMARKS 49 REMARKS-LEN PIC S9(4) USAGE COMP 49 REMARKS-TEXT PIC X(1920)

A VARCHAR column REMARKS would be defined as follows: 10 REMARKS 49 REMARKS-LEN PIC S9(4) USAGE COMP 49 REMARKS-TEXT PIC X(1920)

YES, the CURSOR will be CLOSED.

Yes, the cursor will be closed.

USE WITH HOLD option in DECLARE CURSOR statement, it has not EFFECT in psuedo-conversational CICS PROGRAMS.

Use WITH HOLD option in DECLARE CURSOR statement, it has not effect in psuedo-conversational CICS programs.

No, DECLARE CURSOR is not EXECUTABLE.

No, DECLARE CURSOR is not executable.

YES, we can OPEN more than ONE CURSOR at a TIME

Yes, we can open more than one cursor at a time

If there is an ORDER BY clause, rows are fetched, sorted and MADE available for the FETCH statement Other wise simply the cursor is placed on the first ROW.

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement Other wise simply the cursor is placed on the first row.

Try to USE DECLARE CURSOR statement EITHER in WORKING STORAGE or in procedure division, to specify the SELECT statement Then use OPEN, FETCH rows in a loop and FINALLY CLOSE.

Try to use DECLARE CURSOR statement either in working storage or in procedure division, to specify the SELECT statement Then use OPEN, FETCH rows in a loop and finally CLOSE.

By USING SINGLE ROW SELECT.

By using Single row SELECT.

can ACHIEVE it by EITHER by USING the SINGLE row SELECT statements, or by using the CURSOR

can achieve it by either by using the single row SELECT statements, or by using the CURSOR