Re: Determining which fields are updated or written in a program

I don't know that it's quite as monumental as you think. You don't need to create objects, you only need to compile source. You can reasonably spin through source members and execute an appropriate command (CRTRPGBND, etc.) based on the source type. Once done, you scan through the compile listing. As long as your library list is properly set to find all external references, you should get the information you need.

There may a bit of nuance as to creating modules vs. programs. That depends on the shop standards, but generally speaking I think you can do a CRTRPGMOD on anything you can do a CRTRPGBND, so just do that. CRTRPGMOD on RPGLE, CRTSQLRPGI OBJTYPE(*MODULE) on SQLRPGLE, and so on.

Joe

Alan,
I was hoping that I did not have to recompile (potentially) hundreds of programs to retrieve that information. What I am trying to do is to analyse a company's custom programs that are using a software database to assist in the conversion process. If I can see what programs are accessing specific files (which I can get from the DSPPGMREF) and then further define which fields are actually being used, I can increase my productivity for the project.

I was hoping that the information was stored somewhere that could be accessed. Not only would recompiling be a monumental task, it would be impossible to know what parameters were used to compile the programs for binding, sqlrpgle, etc.

Eric