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
- 20384 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / islam
date pic x(10)
time pic x(08)
timestamp pic x(26)
| Is This Answer Correct ? | 40 Yes | 3 No |
Answer / kalyani
DATE PIC X(10)
TIME PIC X(8)
TIMESTAMP PIC X(26)
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / 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 |
How to select the duplicate rows from a table?
What is netezza database?
Q3. How will you fetch duplicate values from a DB2 table?
How to check table size in db2 sap?
wht steps we need will coding cobol and db2 pgm ?
How to resolve -407 sql code in DB2?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
When can an insert of a new primary key value threaten referential integrity?
What is a page?
What is blu acceleration in db2?
What is Declaration Generator(DCLGEN)?
COBOL 
