Re: Open queries

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

This has been discussed in the archives.  Please check there for the
URL to the manual for this.

I seem to recall when you create a query and use :Varname that you can
then use :Varname as a variable in the query.  I could never get it to
work on my V3R7M0 box and the V4R4 box doesn't have query installed.  But
everyone else insisted it worked for them.

Regards,

Jim Langston

Date: Wed, 9 May 2001 14:40:26 -0500 
From: Shelly.Sommerfeld@state.sd.us
Subject: Open queries

I am having a little bit of difficulty with the OPNQRYF.  What I would like
to do is on the QRYSLT, I would like to have a parameter that is being
passed into my CL as one and also would like to pick out of my file another
field.  

Here is my example:

OPNQRYF   FILE((FNAME)) QRYSLT('VAR1 *EQ "M" and also VAR2 *GE DATE ')  (
that is being passed in)

for some reason I am unable to get this to work.

I hope that one of you could help me..

Thanks
Shelly Sommerfeld
BIT Development Team 3
(605) 773-5808
shelly.sommerfeld@state.sd.us
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---