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 |
How to find the number of rows in db2 tables?
How many buffer pools are there in DB2?
Which is faster delete or truncate?
How to run db2 command in windows?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
Define predicate?
How to fetch the last row from the table in SQL (db2)?
What is db2 bind?
What will the COMMIT accomplish?
What is scrollable cursor in db2?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
my project is insurance management system,how to explain my work environment in interview?