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 |
Mention data types used in db2 ?
How and when does the db2 enforces the unique key?
What are the 4 environments which can access DB2 ?
why we go for SPUFI for creating tables or for sql queries?
How do you pull up a query which was previously saved in qmf?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
How can you display the current date & current time ?
What does DSNDB07 database do?
How to resolve deadlock issue
What is a LIKE table and how is it created?
what is differnece between DROP TABLE & DELETE TABLE .