TCP/IP connection status

["Dwayne Allison" <Dwayne.Allison@xxxxxxxxxxxxxxxxxxxxxxxx>]

Our TCP/IP connection status Local port 46 went down.  How do I restart it?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Alan Campin
Sent: Wednesday, June 15, 2005 12:02 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Passing parm to query


Query Manager Query supports parameters (STRQM) and indicated in one of the 
responses you can convert an old RUNQRY to a STRQM. 

The other way I have seen people attack this problem is to create a parameter 
file and then join to the parameter file in their query. So you load the 
parameter file and then call the query but my recommendation should be to use 
STRQM is at all possible. It is a lot more powerful and it has a simple mode 
like RUNQRY and an advanced mode. SQL is the way of the world. Like I said, you 
can create queries through RUNQRY and then convert them STRQM's to see what 
they look like. 

------------------------------

message: 9
date: Wed, 15 Jun 2005 08:33:17 -0700 (PDT)
from: Jeffrey Young <cooljeff913@xxxxxxxxx>
subject: Re: Passing parm to query

I do not know of any way using the RNQRY, but if you use the SQL Query Manager 
Query, you can specify a variable selection criteria and even include variables 
in your report headings.


"Condon, Mike" <M1C@xxxxxxxxxxxxxxxxx> wrote:
Is there a way to pass a parm to the "Select Records" section of a query
& run in batch (example below):

RUNQRY QRY(GALP/IIQ90MP) OUTTYPE(*PRINTER) +
OUTFORM(*DETAIL) PRTDFN(*NO) +
PRTDEV(*PRINT) FORMSIZE(200 200) +
OUTFILE(*RUNOPT *FIRST *RPLFILE)