What happens to the PLAN if index used by it is dropped?
Answer / s
The plan is invalidated and an automatic rebind is
attempted next time is the plan is executed.
Is This Answer Correct ? | 4 Yes | 0 No |
What is the reason behind not using select * in embedded sql programs?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
is it possible to get -811 error when you use cursors. why?
What is package in cobol db2?
What is the difference between cursor and select statement?
What is db2 purescale?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is ibm db2 client?
What is an inner join, and an outer join ?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is schema in db2?
What are the abend codes occour in ur latest PROJECT in DB2