i have a db2 variable how do u declare tht into working storage section ?



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

Post New Answer

More DB2 Interview Questions

How to find the number of rows in db2 tables?

0 Answers  


How many buffer pools are there in DB2?

2 Answers  


Which is faster delete or truncate?

0 Answers  


How to run db2 command in windows?

0 Answers  


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..

1 Answers   HSBC,


Define predicate?

0 Answers  


How to fetch the last row from the table in SQL (db2)?

0 Answers  


What is db2 bind?

0 Answers  


What will the COMMIT accomplish?

5 Answers  


What is scrollable cursor in db2?

0 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,


Categories