TomLiotta Oct 23, 2009   0:53 AM GMT

In general, if you build a list of programs, you can run DSPPGMREF against each program on the list to output file references into a file of references. You can then select those that name your file as was noted above. However, you might also want to review any logical files that are built over the file you're changing. Depending on how those LFs are defined and on how you add the field to the physical file, you might also need to recompile the LFs and recompile programs that use those LFs. Maybe. You can probably ignore SQL references... unless you had some very inexperienced SQL developers. The SQL shouldn't be affected. How much detail do you need? Tom

125,585 pointsBadges:

RonKoontz Oct 30, 2009   1:26 PM GMT

Fir a quickie just go to the library source you are looking at and do an option 25 then F11. Press enter and type the string you are looking for.

1,810 pointsBadges:

reg Nov 2, 2009   3:02 PM GMT

http://systeminetwork.com/article/files-and-fields-%E2%80%93-where-are-they-used is where you can go to get a complete package to enable you to have this info at your fingertips at all times. Works great and is a stand alone package.

280 pointsBadges:

Teandy Nov 2, 2009   7:35 PM GMT

You may need to hit F13 (shift + F1) after entering 25 on the option field and before hitting enter.

5,860 pointsBadges:

Supriyob2 Jan 12, 2010   11:08 AM GMT

You can use DSPDBR or option 42 in AldonCMs

165 pointsBadges:

WoodEngineer Apr 14, 2014   5:19 PM GMT

The URL below may not work.  Try this one for a nice utility which should do what you need.

7,900 pointsBadges:

azohawk Apr 16, 2014   12:14 AM GMT

Do all of the programs need to access the new field?  If not, don't recompile the file, use the CHGPF (option 2 on the object in PDM) command to add the new field, then on the logicals. This way the file maintains it file level id (no level check errors) and you only need to recompile the programs that need to access the new file.

3,235 pointsBadges:

kitvb1 Apr 16, 2014   3:50 PM GMT

The free version of XrefIT (v1.23) will do it for you. It includes Query, DSPF, PRTF, LF, programs, etc.

65 pointsBadges:

WoodEngineer Apr 16, 2014   3:58 PM GMT

My apologies.  That link did not work.  I just confirmed that the URL below works.  I am pasting it without making it a link.  Maybe that will work better.  Just copy and paste the URL into your browser.

7,900 pointsBadges: