CL Command Reference - CRTQMQRY

CL Command List > CRTQMQRY Reference

Description:

The Create Query Management Query (CRTQMQRY) command allows you to create a query management query from a specified source file member. The source for a query is a single Structured Query Language (SQL) statement that can contain variable substitution values and embedded comments. It can be spread over multiple records in a source file member.


Examples:

CRTQMQRY QMQRY(NEWQRY) SRCFILE(RPTLIB/QRYSRC)

This command creates a query named NEWQRY in the current library. The query source is in member NEWQRY, which is located in source file QRYSRC in library RPTLIB.