RE: Find programs and service programs that contain embedded SQL

Some of these services do a pretty good job of masking the complexity of
getting the information, such as the suggested sysprogramstat.
Some of them have a performance advantage of doing it on your own as IBM
has access to internals and might be able to bypass calling an
intermediate API that you and I would have to do instead.
Some of them still run for a long period of time because, while masking
the complexity to you or I, there is still a lot of work to be done.

Some just take an unwieldy amount of time. And, if there's the slightest
chance that you may want to rerun it (like clean up a where, add an order
by, select different columns, etc) then you may want to reevaluate
previous methods. For example Display_Journal vs copying the journal to
an output file and querying that.

I'm not sure where sysprogramstat fits as I didn't end up running it
myself.

Rob Berendt