Re: field usage in different modes

[Buck Calabro <kc2hiz@xxxxxxxxx>]

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.