Interested to Buy Any Domain ? << Click Here >> for more details...
Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4612 Views
- IBM, I also Faced
- E-Mail Answers
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
| Is This Answer Correct ? | 1 Yes | 0 No |
wht r the requirements for writing a cobol-db2 pgm ?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
can any body explain about plan and pakage in detail....
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is correlation names?
how can you access index
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What should be specified along with a cursor in order to continue updating process after commit?
How do we specify index to include or not during bind process.
What is the syntax for seeing the columns and data types of a table in the db2 database?
COBOL 
