What is declare cursor?
No Answer is Posted For this Question
Be the First to Post Answer
What is iseries database?
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?
is it possible to get -811 error when you use cursors. why?
What is pagespace?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
How is a typical DB2 batch program executed ?
How is the SUBSTR keyword used in sql?
What does it mean if the null indicator has -1, 0, -2?
What is buffer pool?
What is buffrpool? Where we use it ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is database alias db2?