What is the physical storage length of each of the
following DB2 data types: DATE, TIME, TIMESTAMP?
Answer / sadiq afroze
DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes
| Is This Answer Correct ? | 17 Yes | 1 No |
List some fields from sqlca?
What is dclgen in db2?
How to get Top 10 Salaries from a Table
What is copy pending and check pending in db2?
Can there be more than one cursor open for any program?
what is the soft code for deadlock ?
What is a db2 schema?
How to resolve deadlock issue
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What if we fail to give values in columns declared as NOT NULL ?
What is the purpose of the WHENEVER statement?
What is an instance in db2?