Part of the reason that you don't find a description is that this
an external. I like to discourage use of internals, since the
and information are not reliable. There are a couple of situations
the classic description is not accurate, such as use of the
Also, if we need to make a change for any reason, such as fixing a
extending the function, we will, without any notice. When you use
internal and something breaks, then you get to keep the pieces or
On Thu, 21 Apr 2005 13:10:13 -0500, Mike Bell
<[login to unmask email]>
>The contoken is a shifted STCK format - look in the principles
>manual for discussion of STCK instruction and format.
SA22-7832-03 is the
>most current version but the STCK instruction goes back to the
>STCK format is based on CPU time which is normally GMT and then
>display format. I don't know how the daylight savings changes
work - The
>MVS manuals describe how the date and time is handled in Z/os.
>the date/time functions from MVS.
>The CONTOKEN is the source and the other fields are derived
>If you pass a char(8) field to the TIMESTAMP function, it will
>in STCK format and return a generated date/time to match. If
you try to
>a CONTOKEN field in timestamp function, it will return a
>the precompile date/time.
>From: DB2 Data Base Discussion List
[mailto:[login to unmask email] On Behalf
>Of Dang, Tho
>Sent: Thursday, April 21, 2005 12:39 PM
>To: [login to unmask email]
>Subject: [DB2-L] Contoken -- DBRM timestamp ?
>I looked for some explanation about the relation between
CONTOKEN and DBRM
>timestamp but I didn’t find any good document to clarify
>1. Does anybody know how the DBRM timestamp convert to CONTOKEN
in DB2 ?
>How does DB2 resolve it with the daylight savings ?
>2. Do you know any link referred to it ?
>We are in DB2 VERSION 7.1, z/OS 1.4
>Thanks in advance,
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives
and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ
is at http://www.idugdb2-l.org.
List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm