RE: SEQUEL

[Mike Cassara <MikeC@xxxxxxxxxxxxx>]

Bill,
The problem with Query is having to do multiple passes to get the data
in the correct columns.  Sequel is far easier and can easily accomplish
this task in a single pass.  Then using stream file or folder/document
you can output to excel format.  The reason Sequel is so heavily used is
because of it's functional superiority over query.  For further
information check out our web page at www.asc-as400.com

Mike Cassara
Advanced Systems Concepts, Inc
Phone 847-605-1311
Fax 847-605-1912

> -----Original Message-----
> From: brobins@ix.netcom.com [SMTP:brobins@ix.netcom.com]
> Sent: Monday, March 29, 1999 12:14 AM
> To:   RPG400-L@midrange.com
> Subject:      Re: SEQUEL
> 
> Actually, a better solution would be to cut out the middle man and
> just use
> Microsoft Query to put the data into the spreadsheet.
> 
> Bill
> 
> Rick Rauterkus wrote:
> 
> > > It's been a long while since I discussed Sequel with anyone.  How
> is it
> > > for users writing their own queries?  We have some fairly
> sophisticated
> > > Query/400 users who could do more if they had more.  Will Sequel
> also
> > > build files suitable for downloading into Excel?
> >
> > Sequel can build the actual Excel file.  You just need access to a
> shared
> > folder or networked drive on the 400 to get to it after it is
> created.  Or I
> > believe the newest version can e-mail it you.
> >
> > Lucky you for having Query-capable users.  We have only one here
> that uses
> > Query with any regularity.  He is happy with that, so we haven't
> shown him
> > Sequel yet.  So Sequel is mainly a programmer's tool here, but from
> my
> > experience with it, anybody comfortable with Query should have very
> little
> > trouble learning Sequel.  I love it, the only time I use Query
> anymore is to
> > run an old one that hasn't been converted yet.  The capabilities are
> pretty
> > much the same, I just find it easier to get the specs in with
> Sequel,
> > especially with complicated selection criteria where ( )'s come in
> very
> > handy.
> >
> > The report writer also gives you complete control over the format of
> the
> > report.  And then there is the tabler module.  You should get a
> trial of it
> > and check it out.  It has become an indispensable tool here.
> >
> > Rick
> >
> > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * * *
> > * This is the RPG/400 Discussion Mailing List!  To submit a new
> *
> > * message, send your mail to "RPG400-L@midrange.com".  To
> unsubscribe   *
> > * from this list send email to MAJORDOMO@midrange.com and specify
> *
> > * 'unsubscribe RPG400-L' in the body of your message.  Questions
> should *
> > * be directed to the list owner / operator: david@midrange.com
> *
> > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * * *
> 
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * *
> * This is the RPG/400 Discussion Mailing List!  To submit a new
> *
> * message, send your mail to "RPG400-L@midrange.com".  To unsubscribe
> *
> * from this list send email to MAJORDOMO@midrange.com and specify
> *
> * 'unsubscribe RPG400-L' in the body of your message.  Questions
> should *
> * be directed to the list owner / operator: david@midrange.com
> *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *