What is the format (internal layout) of ?TIMESTAMP??
Answer / s
yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is an intent lock?
what's the error code for Unique Index Violation?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
Can I use LOCK TABLE on a view?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is precompiler in db2?
How does DB2 determine what lock-size to use?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is ibm db2 used for?
wht steps we need will coding cobol and db2 pgm ?
How to retrieve rows from a db2 table in embedded sql?
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?