That what I want to know.  I was there and now it's gone

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: Wednesday, June 15, 2005 12:25 PM
To: Midrange Systems Technical Discussion
Subject: RE: TCP/IP connection status


What's port 46?

> -------- Original Message --------
> Subject: TCP/IP connection status
> From: "Dwayne Allison" <Dwayne.Allison@xxxxxxxxxxxxxxxxxxxxxxxx>
> Date: Wed, June 15, 2005 1:14 pm
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> 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)
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].