i have a db2 variable how do u declare tht into working storage section ?
Answer Posted / 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 View All Answers
What is the default page size of buffer pools?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the result of open cursor statement?
What is lock escalation in db2?
What is a bind in db2?
How can the duplicate values be eliminated from db2 select?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Explain the contents that are a part of dclgen.
What is the use of value function?
Can we delete records from view?
What are the contents of a dclmgen?
What is the purpose of using commit?
What is db2 bind?
What is bind plan?
What is the role of union all and union