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 |
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What are foreign keys in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are bind parameters in db2?
Give some example of statistics collected during RUNSTATS?
How to check last update on table in db2?
When is the skeleton cursor table created?
Are view updateable?
What is the difference between plan and package in db2?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What does DSNDB07 database do?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?