Re: field usage in different modes

SQL is not really the best tool to parse content out of spooled files.

I strongly suggest that you create a table of the information you want
(program, library, file, field), and then write an RPG program to
process the spooled file by way of CPYSPLF. Once you have an actual
database table, you can use SQL to process it as you prefer.

As for DSPPGMREF, the same thing applies; direct the output of
DSPPGMREF to OUTPUT(*OUTFILE) and you can use SQL to work with that
file.

Once you have these two files, you can JOIN them any way you need with SQL.
--buck

On Thu, 2 Mar 2023 at 08:03, tim ken <timk2574@xxxxxxxxx> wrote:

In Hawkeye when field /file usage list is generated and from that list i
want to prepare all the program list where a particular field/file set is
used then from that spool file which was generated from this hawkeye tool
how can i run sql query to filter out such records where i just can see
program names library names and field name and file name.

Also is there a way to compare this list with the DSPPGMREF command ?
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.