AS/400 HELP

"FIELDS"

Field locator

FIELDS runs an OPNQRYF on IBM’s QADBIFLD (database field cross reference) file. Search request looks at both the field name and field text description.

FIELDS was developed at v5r3 but is not limited to this release. Simply recompile for your release. You may need to include the ALWNULL(*INPUTONLY) parameter when running CRTBNDRPG (if you get an I/O error)

PC INSTRUCTIONS:

Download "FIELDS” 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 “ fields.savf”

QUOTE SITE NAMEFMT 1

BIN

PUT FIELDS.SAVF

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

 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.

To run ;

ADDLIBLE FIELDS

FIELDS

NOTE: FIELDS prompts in uppercase and picks up upper and lower case

NOTE: Depending on how your system each search may take a few minutes.