AS/400 HELP

"QFILES”

QFILES provides a QUERY INPUT FILES WHERE-USED inquiry.

QFILES extracts the file specs from each query via RTVQMQRY embedded in a ile program. The file QFILES is displayed with program QFILESI.

QFILES was developed and tested at V5r1 but is not limited to this release if you recompile the source code.

DISCLAIMER: QFILES extracts the file detail from the information provided by RTVQMQRY. The layout of the info in V5r1 was used but this may be different in earlier and subsequent releases. The rpg program GETFILES may need some mods for releases other than 5.1

PC INSTRUCTIONS:

Download "FILEQRY” to your PC.

Go to a DOS session and enter the following;

FTP SYSTEM (system = your AS/400’s name or IP address)

Enter a valid user id and password

CD QGPL

LCD C:\DIRECTORY (directory= the directory on your pc where you downloaded “ fileqry.savf”

QUOTE SITE NAMEFMT 1

BIN

PUT FILEQRY.SAVF

QUOTE RCMD RSTLIB SAVLIB(FILEQRY) DEV(*SAVF) SAVF(QGPL/FILEQRY)

 Note: If there is a security problem restoring all objects with the command above, sign on to your as/400 as Qsecofr and run RSTLIB from the command line.

Download FILEQRY.SAVF

To extract query input files:

Enter Addlible fileqry

Enter QFILES & cnd 4

Enter a library

Enter (leave) Y to clear QFILES or enter anything else to add to QFILES. By not clearing QFILES the extraction process will add each (library) run to QFILES. In other words enter Y for the first library and N for each subsequent library.

To view all the files;

CALL QFILESI