Which transaction use a command thread ?
Answer / renu gupta
DSNC transaction uses the command thread to give command to
Db2
| Is This Answer Correct ? | 2 Yes | 0 No |
List out the three types of page locks that can be held.
Why cursor is used in db2?
how can we find nth max salary from A table
What techniques are used to retrieve data from more than one table in a single SQL statement?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Can I use LOCK TABLE on a view?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What does an outer join do?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is the primary key a clustered index?
How to update more then one record using update?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?