i have a db2 variable how do u declare tht into working storage section ?
- 1 Answers
- 5512 Views
- TCS, I also Faced
- E-Mail Answers
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 types of tables are there in the db2 database?
When Can you be sure that a query will return only one row?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Q3. How will you fetch duplicate values from a DB2 table?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the function of buffer manager?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Which catalog table stores referential constraints?
Define sqlca.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Explain various types of locks in db2?
What is the error code -803 ?
COBOL 
