What is the COBOL picture clause of the following DB2 data
types: DATE, TIME, TIMESTAMP?
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 |
What are the different types of base tables?
What is QUIESCE?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What are the rules for db2 programming?
How many databases are there?
What is a composite index and how does it differ from a multiple index?
What is DCLGEN ?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What if we fail to give values in columns declared as NOT NULL ?
What is copy book?
When DB2 connection fails, will online program work or give errors.
What is a DB2 access path?