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 |
Differentiate between cs and rr isolation levels? Where do you specify them?
How does DB2 determine what lock-size to use?
How to connect to db2 database from windows command line?
What are the two types of logging in the db2 database? Explain them.
How do I import a csv file into db2?
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?
What is the difference between nvl and coalesce?
explain about index with examples
Are views updatable ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
How to execute stored procedures?
What is the use of value function?