how many bytes timestamp token occupies?
Answers were Sorted based on User's Feedback
Answer / sarath
Timestamp token has 26 characters ad it will stores 10 bytes
| Is This Answer Correct ? | 21 Yes | 1 No |
Badically a Timestamp has 20 unsigned packed decimal digits
i.e. YYYYMMDDHHMMSSNNNNNN and thus occupy 10 bytes.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santhosh vayathuri
TIMESTAMP ::
DB2 IT WIL TAKE ==> 10 BYTES WHERE AS IN
(YYYYMMDDHHMMSSNNNNNN)
COBOL ==> 26
| Is This Answer Correct ? | 2 Yes | 0 No |
What techniques are used to retrieve data from more than one table in a single SQL statement?
Describe the elements of the SELECT query syntax?
What is difference between alias and synonym in db2?
Explain about dbrm.
What is an asychronous write?
What is the difference between static and dynamic SQL?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What does CURRENTDATA option in bind indicate
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How to insert more than one record using insert?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .