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

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,


List out the buffer pools in db2

0 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  


What is data manager?

0 Answers  


What are the various locking levels available?

3 Answers  






Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  


What is auditing?

2 Answers  


Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,


How to compare data between two tables in db2?

0 Answers  


What is the physical storage length of time data type?

0 Answers  


What is a storage group (stogroup)?

0 Answers  


Categories