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 syntax of SELECT statement when embedded in a COBOL program?
What is Declaration Generator(DCLGEN)?
What is collection in db2 bind?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
how to resolve -805 . how to see dbrm and package not found
Which components manage deadlocks in db2?
How do I import data from excel to db2?
What techniques will be used to avoid deadlock??
What is the usage of open cursor command?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the difference between static and dynamic SQL?