additional info on jreport 008 and time-based reporting

Discussion created by ca.portal.admin on Oct 20, 2009
Latest reply on Oct 20, 2009 by ca.portal.admin
ya know - sometimes i think they should take away my license to post on

much of what i posted previously was misleading (read WRONG)

since the timestamps i referred to are NOT on bfor/aftr records - one
would need to attack the jreport on 3 steps

1) identify the run units that started or ended during the service
2) go back and get all bfors/aftrs for those run units

3) if you had a run unit that either started before or ended after the
time period, try to find a bgin/endj/comt closest to the endpoints of the
time period - note their sequence numbers - and then exclude BFORS/AFTRS
that fell before the sequence# that corresponds to the beginning of the
time period, or falls after the sequence# that corresponds to the end of
the time period

i hope this is closer to correct - it is late in the Eastern (US) Time

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc

you only need to test the programs that you want to work correctly

The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.
IDMS 3rd-party providers forum


Re: additional info on jreport 008 and time-based reporting
"Without having my documentation in front of me: I think this is a two pass

1) Run a jreport 8 selecting for TIME records that meet the time

2) Use the journal sequence number information from that report to run a
report that selects on journal sequence number.

Don Casey
Principal Consultant
Run Right, LLC