|
Question |
Rating |
View Answer |
|
What are the advantages of using a PACKAGE? |
|
View Answer |
|
What is a collection? |
|
View Answer |
|
What are the 2 sqlcodes that are returned? ? |
|
View Answer |
|
How would you print the output of an SQL statement from SPUFI? ? |
|
View Answer |
|
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? |
|
View Answer |
|
What is dynamic SQL? |
|
View Answer |
|
When is the access path determined for dynamic SQL? |
|
View Answer |
|
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? |
|
View Answer |
|
How does DB2 store NULL physically? |
|
View Answer |
|
How do you retrieve the data from a nullable column? ? |
|
View Answer |
|
What is the picture clause of the null indicator variable? ? |
|
View Answer |
|
What does it mean if the null indicator has -1, 0, -2? ? |
|
View Answer |
|
How do you insert a record with a nullable column? |
|
View Answer |
|
What is RUNSTATS? |
|
View Answer |
|
When will you chose to run RUNSTATS? |
|
View Answer |
|
Give some example of statistics collected during RUNSTATS? |
|
View Answer |
|
What is REORG? When is it used? |
|
View Answer |
|
What is IMAGECOPY ? |
|
View Answer |
|
When do you use the IMAGECOPY? |
|
View Answer |
|
What is COPY PENDING status? |
|
View Answer |