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



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

Post New Answer

More DB2 Interview Questions

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  


How does DB2 determine what lock-size to use?

2 Answers  


How to connect to db2 database from windows command line?

0 Answers  


What are the two types of logging in the db2 database? Explain them.

0 Answers  


How do I import a csv file into db2?

0 Answers  






If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  


What is the difference between nvl and coalesce?

0 Answers  


explain about index with examples

2 Answers   Syntel,


Are views updatable ?

4 Answers  


What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,


How to execute stored procedures?

0 Answers  


What is the use of value function?

0 Answers  


Categories