RE: pass parms to qry400

A possible alternative to qry400:

Do you have access to STRQM "DB2 Query Manager"?  Queries created using
Query Manager can be created either as a prompted query or as SQL.  When
using these queries, you can pass in variables at run time.  You run these
queries by using the command STRQMQRY.  I've successfully used these type of
queries many times when there is a need to pass in variables such as date
ranges.


Date: Thu, 29 Jun 2000 09:31:19 EDT
From: JGracetri@aol.com
Subject: pass parms to qry400

Does anyone know if you can do the following.

cl pgm
    dcl &item
    dclf screen
    rcvf screen 
    runqry xxxxx parm &item
end pgm

I do not want the user to have access to the select on qry itself.

thank you jeff G.
                       

This Message Has Been Scanned By Interscan Viruswall at Railcar Management.

A possible alternative to qry400:

Do you have access to STRQM "DB2 Query Manager"?  Queries created using Query Manager can be created either as a prompted query or as SQL.  When using these queries, you can pass in variables at run time.  You run these queries by using the command STRQMQRY.  I've successfully used these type of queries many times when there is a need to pass in variables such as date ranges.

Date: Thu, 29 Jun 2000 09:31:19 EDT
From: JGracetri@aol.com
Subject: pass parms to qry400

Does anyone know if you can do the following.

cl pgm
    dcl &item
    dclf screen
    rcvf screen
    runqry xxxxx parm &item
end pgm

I do not want the user to have access to the select on qry itself.

thank you jeff G.