![]() The object information repository data is stored with the *QRYDFN object. This would not need to be ran again, unless the query definitions were re-restored. However, any *QRYDFN object save/restored from V6R1 or V7R1 may require program QQUIWHOI to be run. V7R2 (no PTF necessary) - Any newly created query definitions will have accurate file usage information. The program must be called every time a new query definition is added or query definition changes its file references, or you may see file references of '8' (Not specified). V&R1 (SI46908) - PTF supplies the support listed above, but you must run the following program to update the OIR information for file usage:ĬALL PGM(QSYS/QQUIWHOI) PARM(-library name-) It does NOT supply the file usage and does not have outfile support. Find all input file references for query definition TESTQRY in library QGPL: You can use the WHERE clause to filter out results: ![]() Like in the compilation spool file at the bottom, in the cross referecene section. It should be fine if you had a command that tell you fields usage in the same way, with the source available or without. instead of a / as in library.outfile in FROM clause)ĭSPFFD of the outfile will give you the field names and text descriptions if you wish to craft your own queries. DSPPGMREF simple tell you the usage of files. SELECT WHPNAM, WHLIB, WHFNAM, WHLNAM, WHFUSG Once the command completes, you can run a query over the outfile you just created Use Display Program References (DSPPGMREF) with *OUTFILE supportĭSPPGMREF PGM(*ALL/*ALL) OUTPUT(*OUTFILE) OBJTYPE(*QRYDFN) OUTFILE(-your library-/-your outfile-)
0 Comments
Leave a Reply. |