RE: (no subject)

[Jeff Bull <Jeff.Bull@xxxxxxxxxxxxxxx>]

... I think it is about time the there was a PDM-like set of basic tools in
the public-domain for those with no desire or cash to buy the full WDS.  I
was quoted over £5K for a model 170, I only want to write a bit of CL ...
outrageous.

As for the query NOT-RANGE, would the following have the desired effect:

     &flda *LT &rnglow
*OR  &fldb *gt &rnghigh

Jeff

-----Original Message-----
From: Paul Nelson [mailto:p_nelson-br@pop.inil.com]
Sent: 24 July 2002 11:17
To: midrange-l@midrange.com
Subject: Re: (no subject)


Not that I've found in Query, but in SEQUEL from Advanced Systems Concepts,
you can have a where clause like this:

WHERE     value  NOT BETWEEN x and y

I don't work for them, but I've got a bunch of customers who are using the
product. I'm even using their scripting tool to develop applications for one
customer who doesn't own IBM's PDM product. Most CL commands can be prompted
and used by the scripting tool, and the scripts for batch jobs can be
submitted to a job queue. The really cool thing is that unlike query, the
SEQUEL views and scripts can be set up to allow for run time variables, so
you can build something once, and then turn it over to the users.

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
----- Original Message -----
From: <pedro.reis@valeo.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, July 24, 2002 4:39 AM
Subject: (no subject)


> Hello,
>
> On query/400, is  there any operator for doing the negation of the
operator
> RANGE? ...like not range ?
>
>
>
>
> Cordialement,
> Best regards,
> -------------------------------------------------------------------
> Pedro Reis
> e-mail: pedro.reis@valeo.com
> Phone: 351-258 350 725
> Fax: 351-258 350060
> --------------------------------------------------------------------
> VALEO - Electronics & Connective Systems
> Viana do Castelo - Portugal
> --------------------------------------------------------------------
>
> "This e-mail message is intended only for the use of the named
> recipient(s).
> The information contained therein may be confidential or privileged, and
> its
> disclosure or reproduction is strictly prohibited. If you are not the
named
> recipient, please return it immediately to its sender at the above address
> and destroy it."
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> 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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


DISCLAIMER

Any opinions expressed in this email are those of the
individual and not necessarily the Company. This email
and any files transmitted with it, including replies and
forwarded copies (which may contain alterations)
subsequently transmitted from the Company, are
confidential and solely for the use of the intended recipient. If you are not 
the intended recipient or the
person responsible for delivering to the intended recipient,
be advised that you have received this email in error and
 that any use is strictly prohibited.

If you have received this email in error please notify the IT
manager by telephone on +44 (0)870 871 2233 or via
email to Administrator@itm-group.co.uk, including a copy
of this message. Please then delete this email and
destroy any copies of it.

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________