actually I am working on a preedited file with some SMF-record information included.
The file looks like follows:
Code: Select all
00110186 02000268 00110186 02000310 PJDTED71 00000007
00110186 20040443 00110186 20292051 PJDTTG12 00012542
The rows represent the following informations:
startdate - starttime - enddate - endtime - jobname - cputime.
Date values are given in the format '001'yyddd (julian date),
time values format is hhmmssxx (xx = hundredths of a second),
cputime format is ssssssxx (seconds and hundredths of a second).
I would like to rearrange and reformat the given file using dfsort to a format as follows
Code: Select all
PJDTED71 02:00:02 02:00:03 00:00:00,42 0'00,07" 20100705
PJDTTG12 20:04:04 20:29:20 00:25:16,08 2'05,42" 20100705
The content of the rows is now:
jobname - starttime - endtime - duration - cputime - startdate
Time values are now given in format hh:mm:ss,
duration with additional hundredths of a second, separated with comma,
cputime in mmmm'ss,xx" (minutes, seconds and hundredths of a second with separators shown),
and the date in eight digits format without separators.
As a special challenge I would like to subtract the starttime from endtime given in the original file to get the duration of the job run in 'real' time as a result.
*
Of course it was easy to get the first three rows by using OUTREC:
Code: Select all
OUTREC BUILD=(40,10,11,6,ZD,M8,C' ',31,6,ZD,M8,C' ',
But I cannot find a solution for the other rows. I tried
(11,8,TE4,SUB,31,8,TE4),EDIT=(TT:TT:TT,TT) -
there is no error, but the result I received is not the difference between start- and endtime ??
*
Any idea to help me doing this with sort?
Thanks in advance !
Martin