ca.portal.admin

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
idms-l

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
Zone





Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com

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
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
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
operation:

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

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

Outcomes