RE: Query

How can I pass a numeric variable to a QMQRY from a CL?  I need to
select on a field that is 8 signed.  To further complicate things... the
value I'm trying to pass is retrieved through a call to another
program... and being returned as an 8 *CHAR to the calling CL.

Thanks!!
  =)

-----Original Message-----
From: Rob Berendt [mailto:rob@dekko.com]
Sent: Tuesday, June 01, 1999 11:13 AM
To: MIDRANGE-L@midrange.com
Subject: RE: Query


There are some steps you can do to pass parms to Query/400.

Method 1:
Convert the Query/400 query into QM/400 and modify it.

Method 2:
Set up your parameters in a separate file and join with this file.
Details available upon request.





LDiRosa@GIBRALTAR1.COM on 06/01/99 01:04:11 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: Query

DB2 Query Manager for the AS/400 would be an excellent choice if you
want to
control user queries to only run in BATCH mode.  Another nice feature is
that you can pass parameters to a query written in this app.  One
downfall
of AS/400 wrkqry, another potential choice for you, is that it cannot
receive parms.  They both function very similar and can both take
advantage
of the predictive query govenor that comes with most AS/400's past V3R1.
This query govenor can monitor a query and not allow it to take all the
AS/400 resources.  Hope this helps.

Thanks,
Lynn P. DiRosa
Gibraltar Steel, Corporate 
Information Services


> -----Original Message-----
> From: Paul A Troup IV [SMTP:ptroup@gulftel.com]
> Sent: Tuesday, June 01, 1999 12:52 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Query
> 
> I'm looking for a query program to run onÿthe 400.ÿ Does anyone have
any
> recommendations?ÿ 
+---
| 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.comm
+---


+---
| 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
+---
+---
| 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
+---