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 |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
How do I copy a table in db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
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 .
How can you classify the locks in db2?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is concurrency?
What is dbrm?
Where would you find information about the type of database authority held by the user?
What is ACQUIRE/RELEASE in BIND?