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
- 20416 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 are the various locks available?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
How to create backup table in db2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Define data page.
On which levels locks can be applied?
Highlight all the advantages that are attached to a package.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
what is the difference between where clause and having clause
COBOL 
