i have a db2 variable how do u declare tht into working storage section ?

Question Posted / visu.kanchamreddy

i have a db2 variable how do u declare tht into working storage section ?..

Answer / guest

the db2 variable can be declared in the working-storage
section by using the DCLGEN of the particular table.
Eg:
EXEC SQL
INCLUDE DCB0XXX
END-EXEC.

Is This Answer Correct ?

2 Yes

1 No

More DB2 Interview Questions

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

What do the initials DDL and DML stand for and what is their meaning?

What is db2?

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

List out the three types of page locks that can be held.

Name the lockable units in DB2?

what is utility for parm lib

How many databases can be created inside an instance in db2 ?

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

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

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.

When is the results table for the query in a DECLARE CURSOR statement created?

For more DB2 Interview Questions Click Here