Interested to Buy Any Domain ? << Click Here >> for more details...
When is the access path determined for dynamic SQL?
- 2 Answers
- 9240 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kamalakar
At runtime when the PREPARE statement is issued.
| Is This Answer Correct ? | 3 Yes | 0 No |
Mention the different locking levels that are available in db2.
What does runstats do in db2?
What is a DBRM, PLAN ?
What are the isolation levels possible ?
max number of columns in a db2 table?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What information is used as input to the bind process?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
COBOL 
