Interested to Buy Any Domain ? << Click Here >> for more details...
What is the COBOL picture clause of the following DB2 data
types: DATE, TIME, TIMESTAMP?
- 3 Answers
- 20405 Views
- I also Faced
- E-Mail Answers
Answer Posted / kkings
DATE • Represented as a sequence of eight unsigned
packed decimal digits (yyyymmdd), occupying four bytes.
• Range 00010101 to 99991231 A.D.
TIME • Represented as a sequence of six unsigned
packed decimal digits (hhmmss), occupying three bytes.
• Range 000000 to 240000.
TIME STAMP • Is a combination of date and time,
accurate to the nearest microsecond.
• Represented as a sequence of 20 unsigned packed
decimal digits (yyyymmddhhmmssnnnnnn), occupying ten bytes.
• Range 00010101000000000000 to 99991231240000000000.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is db2 connect?
What is declare cursor?
What is database manager in db2?
What are host variables in db2?
What is a cursor in programming?
What is isolation level in db2?
What is the max length of sqlca?
Explain correlated sub-queries.
What are the full forms of spufi and dclgen and why are they used?
What is the syntax for FETCH in DB2 ?
What is the function of logging in the db2 database?
what is the role of the cursor in db2?
What are db2 tables?
What is cloudant database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
