I keep forgetting to specify the release level we are on - which
is 5.4 so I can use neither of your suggestions
Because the file is in chronological order (timestamp) the order
number 1 may in fact be the millionth record on that particular
date, but if I can create a logical by date within that timestamp,
then order number, then order number 1 will be the first for that
I may have to create a temporary file, and populate a date field
I just thought that there may have been something equivalent to SST
for timestamp fields
Luis Rodriguez on Tuesday, April 12, 2011 4:33 PM wrote:
Are you running 6.1 or higher? If so, I wonder if using a derived
key would be of help?
Something in the order of
CREATE INDEX MYLIB/MYINDEX ON MYLIB/MYTABLE
(DATE(MY_TIMESTAMP) AS MY_DATE)
Unfortunately, we are stuck here in the dark ages (V5R3), but
maybe this would be doable...
On Tue, Apr 12, 2011 at 3:02 PM, Alan Shore<ashore@xxxxxxxx> wrote:
I have a physical file, that contains a timestamp field (type z) Is
there any way to create a logical over this physical but ONLY using
the date within that timestamp as part of the key?
As always, any and all responses MUCH appreciated