|
Question |
Rating |
View Answer |
|
2) How do you eliminate duplicate values in DB2 SELECT ? |
|
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 |
|
At what stage db2 must be up?
|
|
View Answer |
|
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
|
|
View Answer |
|
When will you chose to run RUNSTATS? |
|
View Answer |
|
Can GROUP BY and ORDERED BY used in a single query?
|
|
View Answer |
|
What is diff b/w check pending and copy pending?
|
|
View Answer |
|
How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) |
|
View Answer |
|
Can you have more than one cursor open at any one time in a program ? ? |
|
View Answer |
|
What are the three lock types?
|
|
View Answer |
|
Are views updateable ? |
|
View Answer |
|
What is the indexset and sequence set in vsam ksds?
|
|
View Answer |
|
38) Is it mandatory to use DCLGEN? If not, why would you use it at all? - |
|
View Answer |
|
63) What else is there in the PLAN apart from the access path? � |
|
View Answer |
|
33) What is the physical storage length of each of the following DB2 data types: |
|
View Answer |
|
How do you eliminate duplicate values in SELECT? ? |
|
View Answer |
|
What is sqlcode -922 ? |
|
View Answer |
|
What is index cardinality? |
|
View Answer |
|
How to pass return codes from Cobol to jcl?
|
|
View Answer |
|
In my jcl ,the 1st step is delete step, if the data set is existing, I want to delete, that one ,if dataset is no existing, I do not want abend the job, how can I code in disp?
|
|
View Answer |