When is the skeleton cursor table created?
Answer / s
Skeleton cursor table is created when a new plan is bound.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is dpf in db2?
List some fields from sqlca?
What is the purpose of the DSNC transaction ?
How can you compare table column after update and before update?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is db2 bind?
What is a trigger in the db2 database?
What is query_cache_limit?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
When do you specify the isolation level? How?
What is the difference between db2 and oracle?