Interested to Buy Any Domain ? << Click Here >> for more details...
how many bytes timestamp token occupies?
- 6 Answers
- 15635 Views
- Boss Global, Cap Gemini, TCS, I also Faced
- E-Mail Answers
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 |
Describe major components of db2?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is consistency token in db2?
What is meant by explain?
What do you need to do before you do EXPLAIN?
Can one database have multiple instances?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is a composite index and how does it differ from a multiple index?
wht displays the number of times a query modified ?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Explain the EXPLAIN statement?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
COBOL 
