Using variable parms in STRQMQRY

[ukpi1b]

Couple weeks ago I posted an example how to use variables in QMQRY In atached example, there is extarct from ATEST table where columns in SELECT statement are a varibles, values for selection are variables as well. New column DOG with assigned value 'CAT' (as in previous example)is added to extract.

mcqmqry.doc (http://www.mcpressonline.com/images/fbfiles/files/5bfbc9d9_mcqmqry.doc)

[Guest.Visitor]

For Detailed information on using QMQRY check out the "iSeries and AS/400 Programmer's Guide to Cool Things" from MC Press http://www.mc-store.com/isasprogguid.html

[Guest.Visitor]

I would like to pass parameters to a query using the STRQMQRY command, but don't want to use "hard-coded" values. Instead, I would like to declare *CHAR type variables in the CL program and pass those to the query. Can someone give me an example or tell me how to do this?

[Guest.Visitor]

Thank you so much for the example!