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

Mention the different locking levels that are available in db2.

How can we define a table? How can we apply SEARCH ALL on it ?

What is precompiler in db2?

what are bind concepts in db2 cobol?

what is the difference between join and union?

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

What are the prerogatives?

What are the rules for db2 programming?

How do you check for a null value in a db2 column?

What is the SQL Communications Area and what are some of its key fields?

What kind of database is db2?

How to execute stored procedures?

For more DB2 Interview Questions Click Here