Interested to Buy Any Domain ? << Click Here >> for more details...
What is the physical storage length of each of the
following DB2 data types: DATE, TIME, TIMESTAMP?
- 1 Answers
- 10171 Views
- CTS, I also Faced
- E-Mail Answers
Answer / sadiq afroze
DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes
| Is This Answer Correct ? | 17 Yes | 1 No |
Outputs of explain are with matchcols = 0. What does this signify?
What are some characteristics of columns that benefit from indexes?
what is the use of cursors?
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.
How can record locking be achieved in those DB2 versions which do not support it?
I use CS and update a page. Will the lock be released after I am done with that page?
What action db2 takes when a program aborts in the middle of a transaction?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How will you delete duplicate records from a table?
Which components manage deadlocks in db2?
What are db2 tables?
Is the primary key a clustered index?
COBOL 
