Re: Good places to use "The Cycle" in today's RPG

Hi James Lampert

I think all my old cycle report programs still go like .

I Location L3
I Salesman L2
I customer L1
c* process first record of a group
c l3 exsr l3d
c l2 exsr l2d
c l1 exsr l1d
c* process detail record
c exsr detail
c* pocess totals
cl1 exsr l1t
cl2 exsr l2t
cl3 exsr L3t
clr exsr lrt

The detail time subs (l1d) clear totals and print headings. at detail
time the values from the record you just read are availavble.

the total time subs (l1t) print totals. at total time the values from the
last record of the group are still available for printing, output to a
file etc

The big gotcha is it is tough to use sql to feed the report program. this
can be fixed by using a special file in the report program and an SQL
"feeder program" if you have big old reports you don't want to rewrite,
but want to switch to sql to select the data.

I would still use it for doing summary updates from 1 file to another. I
don't do much report writing anymore, but I think I would still use it if
I did and didn't need sql to select the data.

Jim Horn

This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.
This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.