What is the physical storage length of the data types date, time, and timestamp?
- 1 Answers
- 1170 Views
- I also Faced
- E-Mail Answers
Answer / Saurabh Yadav
The physical storage lengths for DATE, TIME, and TIMESTAMP data types in DB2 are as follows:nn- DATE: 7 bytes (YYMMDD)n- TIME: 5 bytes (HHMMSS.FF)n- TIMESTAMP: 9 bytes (YYMMDD HH:MI:SS.FF)
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we define a table? How can we apply SEARCH ALL on it ?
Name the different types of Table spaces.
What are the two types of logging in the db2 database? Explain them.
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What are the isolation levels possible ?
What is query_cache_limit?
What does sqlcabc has?
What techniques will be used to avoid deadlock??
what is db2 restart?
What is index in db2?
Mention and explain the contention situations caused by locks?
COBOL 
