Hi there Kolusu, I messed up my format, and should have had colons
instead of commas. Here is what I should have written:
OUTFIL REPEAT=1500
BUILD=(1:C'TLX1',
5:SEQNUM,12,ZD,START=123456000000,INCR=1, <<==This is the
one to change from a number to a dynamic timestamp
17:SEQNUM,5,ZD,START=10001,INCR=3
22:C'This is my data field 1',
52:C'This is my data field 2' ,
82:C'This is my data field 3',
102:C'AZ',
104:C'111110000')
I checked the APG, and could not find a way to use only the timestamp.
What I want in column 5 is a 12 numeral value (let's say 125110104322)
that represents the HHMMSSmmmmmm for each record as it is built. I have
seen examples using a static date for the entire execution, but I am
hoping for multiple milliseconds to show up in these records.
Thank you and best regards,
Billy Ashton
------ Original Message ------
From "Sri h Kolusu" <[email protected]>
To [email protected]
Date 1/31/2024 12:06:40 PM
Subject Re: Generating output in SORT with a time value
We have this so far:
OUTFIL REPEAT=1500
BUILD=(1,C'TLX1',
5,SEQNUM,12,ZD,START=123456000000,INCR=1,
17,SEQNUM,5,ZD,START=10001,INCR=3
22,C'This is my data field 1',
52,C'This is my data field 2' ,
82,C'This is my data field 3',
102,C'AZ',
104,C'111110000')
Billy,
Looks like you created your own syntax as that is NOT a valid for both DFSORT
and Syncsort.
IS there a way I can say "In column 5, put the right-now-time-millisecond value as
HHMMSSmmmmmm". We will create multiple files at different times for our test, which
is why we want to have the real time instead of a generated number.
No idea, what column 5 is. If you want a 26 byte date of the format
C'yyyy-mm-dd-hh.mm.ss.nnnnnn', then use DATE5. Look at examples in the DFSORT
Application programming Guide.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
