Hi,
I have an Omegamon report that lists average response time for a
transaction, the count and the name but the Period is only list for the
first transaction even though it applies to the following transactions.
I have a field in this case that is a Date/Time and I want to repeat
that field for the following records while it is blank.
The below is an example of the output before sorting
----START----- -----STOP----- NAME COUNT
RESP
01/20/12 08:00 01/20/12 08:59 XRQ0 1
1.419
X257
63 .178
01/20/12 09:00 01/20/12 09:59 ACFT 12
.001
CATA
177 .008
CATD
34 .005
CDTS
9 .003
CESN
204 .010
CITS
161 .017
CQRY
177 .013
After sorting the Start and Stop date/time has been repeated for the
following records while that field is blank.
----START----- -----STOP----- NAME COUNT
RESP
01/20/12 08:00 01/20/12 08:59 XRQ0 1
1.419
01/20/12 08:00 01/20/12 08:59 X257 63
.178
01/20/12 09:00 01/20/12 09:59 ACFT 12
.001
01/20/12 09:00 01/20/12 09:59 CATA 177
.008
01/20/12 09:00 01/20/12 09:59 CATD 34
.005
01/20/12 09:00 01/20/12 09:59 CDTS 9
.003
01/20/12 09:00 01/20/12 09:59 CESN 204
.010
01/20/12 09:00 01/20/12 09:59 CITS 161
.017
01/20/12 09:00 01/20/12 09:59 CQRY 177
.013
Thanks
James
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[email protected]] On
Behalf Of Elardus Engelbrecht
Sent: 30 January 2012 12:55
To: [email protected]
Subject: Re: Sort repeating date field
Chambers, James wrote:
>I am trying to repeat the Start and end Date/Time for an Omegamon Cics
report. Is it possible using DFSORT repeat a field for all the records
after that have a blank for that field?
>The below is an example of the output
I'm not really sure what you want, could you be kind to post the example
you received and what you actually want. With both outputs (received and
expected) available for comparision, someone can probably see exactly
what you want.
Thanks in advance.
Groete / Greetings
Elardus Engelbrecht
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send
email to [email protected] with the message: INFO IBM-MAIN
--
This is a confidential communication and is intended only for the addressee
indicated in the message (or duly authorised to be responsible for the delivery
of the message to such person). You are specifically prohibited from copying
this message or delivering the same, or any part thereof, to any other person,
whomsoever or howsoever, unless you receive written authorisation from us to
do.
If you are anyone other than the intended addressee, or person duly authorised
and responsible for the delivery of this message to the intended addressee, you
should destroy this message and notify us immediately.
Please note that we accept no responsibility whatsoever in the event that this
message or any other email message or any part thereof becomes known or is
communicated to anyone other than the intended recipient or other person
authorised in writing by us to receive it, howsoever arising and disclaim all
liability for any losses or damage which may be sustained by any person as a
result thereof.
Irish Life Assurance plc is regulated by the Central Bank of Ireland.
Irish Life Financial Services Limited is regulated by the Central Bank of
Ireland.
"Irish Life" is a member of the Irish Life and Permanent plc group. Irish Life
Assurance plc is a company registered in Ireland. Registered office is situated
at Irish Life Centre, Lower Abbey Street, Dublin 1. Registered Number 152576.
Irish Life Financial Services Limited is a company registered in Ireland.
Registered office is situated at Irish Life Centre, Lower Abbey Street, Dublin
1. Registered Number 489221.
==============================================================================
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
