Interested to Buy Any Domain ? << Click Here >> for more details...
Where are plans stored?
- 2 Answers
- 7041 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
The Bound plans are stored in the SKCT tablespace in
DSNDB01 directory.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the use of COMMAREA ?Minimum how much data we can pass from it?
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?
What is a DB2 catalog?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
what are the bind parameters?
Why do we use cursor?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Where can you declare a cursor in a cobol-db2 program?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a buffer in memory?
what is consistency token
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
COBOL 
