Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AS400 query manager 1
- Thread starter zaker25
- Start date
-
1
- #2
AS400 Query Manager is used to run SQL statements which are saved
within members of Source Physical Files.
After entering the SQL statements into a member, the following
three commands can be used to Create, Start (Run) and the Delete
the query.
CRTQMQRY QMQRY(LIB/QRYMBR) SRCFILE(LIB/SRCFILE) REPLACE(*YES)
STRQMQRY QMQRY(LIB/QRYMBR)
DLTQMQRY QMQRY(LIB/QRYMBR)
Listed below is a link to an article regarding using
AS400 Query Manager:
- vbMax
within members of Source Physical Files.
After entering the SQL statements into a member, the following
three commands can be used to Create, Start (Run) and the Delete
the query.
CRTQMQRY QMQRY(LIB/QRYMBR) SRCFILE(LIB/SRCFILE) REPLACE(*YES)
STRQMQRY QMQRY(LIB/QRYMBR)
DLTQMQRY QMQRY(LIB/QRYMBR)
Listed below is a link to an article regarding using
AS400 Query Manager:
- vbMax
Download a copy of DB2 UDB for AS/400 Query Management
Programming from IBM. go to and search for QMQRY
Programming from IBM. go to and search for QMQRY
- Status
Similar threads
- Locked
- Question
- Locked
- Question