Re: (no subject)

At the previously mentioned client site, their application vendor and IBM
basically abandoned the customer, and now they're working on migrating to
ORACLE. Their software vendor wouldn't make the source code available to
them, and told them that PDM was unnecessary. With the source code and PDM,
they could have come up with the mods they needed to keep them on the 400
platform. It's not like they don't have the money to spend ($600 million
construction company), it's just the way they were treated. Now ORACLE has a
new customer.

I'm using SEQUEL to create the data to pump from the 400 to the ORACLE
system, but I had to use my own machine to create the FTP batch stuff to
actually move the files.

Wouldn't it be nice if IBM threw in a CL creation and editing tool (more
than CRTCLPGM) as part of the operating system? There is supposedly a
project going on to introduce a new and improved version of CL. Come on,
IBM, please GIVE AWAY an editing tool. Pretty please? :-))

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
----- Original Message -----
From: "Jeff Bull" <Jeff.Bull@itm-group.co.uk>
To: <midrange-l@midrange.com>
Sent: Wednesday, July 24, 2002 5:22 AM
Subject: RE: (no subject)


> ... 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
> ________________________________________________________________________
> _______________________________________________
> 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.
>
>