Troubleshooting
Problem
Finding a particular field used by Query/400 queries on the system
Resolving The Problem
This document discusses a way to find a particular field used by Query/400 queries on the system. It is useful when there is a change on the field and you want to find out what queries are affected by the change. There is no easy way to do this but the below steps allow you to create source files of your queries and search the results for a file or field name.
1. Create source PF to store the information, for example: CRTSRCPF FILE(LIB_NAME/QQRYSRC)
2. WRKOBJPDM over your query library, you may specify *QRYDFN type to filter for queries for example: WRKOBJPDM LIB(LIB_NAME) OBJ(*ALL) OBJTYPE(*QRYDFN)
3. Add pdm option(F16 then F6) (EQ=Extract Query) for RTVQMQRY QMQRY(&L/&N)
SRCFILE(QQMQRYSRC) ALWQRYDFN(*ONLY)
4. Run the PDM option against all queries (putting EQ next to each query).
5. WRKMBRPDM over the library/QQMQRYSRC file (these will be SQL source members now, one for each member).
6. Scan the members for the keyword(taking option 25 next to each member you want to search)
1. Create source PF to store the information, for example: CRTSRCPF FILE(LIB_NAME/QQRYSRC)
2. WRKOBJPDM over your query library, you may specify *QRYDFN type to filter for queries for example: WRKOBJPDM LIB(LIB_NAME) OBJ(*ALL) OBJTYPE(*QRYDFN)
3. Add pdm option(F16 then F6) (EQ=Extract Query) for RTVQMQRY QMQRY(&L/&N)
SRCFILE(QQMQRYSRC) ALWQRYDFN(*ONLY)
4. Run the PDM option against all queries (putting EQ next to each query).
5. WRKMBRPDM over the library/QQMQRYSRC file (these will be SQL source members now, one for each member).
6. Scan the members for the keyword(taking option 25 next to each member you want to search)
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Component":"DB2 for IBM i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Historical Number
580569032
Was this topic helpful?
Document Information
More support for:
IBM i
Software version:
Version Independent
Operating system(s):
IBM i
Document number:
706513
Modified date:
11 November 2024
UID
nas8N1011882
Manage My Notification Subscriptions