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
- 20515 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 |
what is the role of the cursor in db2?
What is a plan and package in db2?
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.
How does db2 sample database connect?
How to resolve -502 sql code in DB2?
What is host variable?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is node in db2?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What are some characteristics of columns that benefit from indexes?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
COBOL 
