Interested to Buy Any Domain ? << Click Here >> for more details...
Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
- 2 Answers
- 5224 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the cascade rule and how does it relate to deletions made with a subselect?
What is correlated subquery?
What is concurrency?
What is the physical storage length of date data type?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How to select the duplicate rows from a table?
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?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
how can u retrieve the data from null values using applicaion program.
COBOL 
