Re: SQL VS QUERY -- MIDRANGE-L

Check out SEQUEL & ViewPoint from Advanced Systems Concepts.
www.asc-iseries.com

It's best-of breed, and your users will love the ViewPoint interface. You'll
like the fact that you can use it as a programming tool. I just finished a
project where there was a requirement to port formatted data from a 400 to
an Oracle box. Because of the cost of the programming tools from IBM for
that machine, I had no PDM or an RPG compiler. With SEQUEL's scripting
capability, I was able to do everything I needed to prepare the data,
perform a CPYTOIMPF, and then call my generic batch FTP program to shoot the
files over to the other machine.

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
----- Original Message -----
From: "Tyler, Matt" <mattt@wincofoods.com>
To: <midrange-l@midrange.com>
Sent: Thursday, October 10, 2002 10:17 AM
Subject: RE: SQL VS QUERY


> Bob,
> Do have them get SQL/400 tool box, it is installed for free on V5+
> development package.  You can create queries that are very complex.  You
can
> use joins other than inner joins (which QUERY/400 only allows).  It
installs
> Query Manager which is where you can create SQL objects to run with
> STRQMQRY.  You can also run some queries with RUNSQLSTM.  I would still
use
> QUERY/400.  It has far better reporting interfaces.  You can actually edit
> data how you want it just like using RPG.  Combining the two can allow you
> to create a robust report with good data formatting.
>
> The one reason I always use SQL to generate result sets is that you
> can join tables on fields of different data type, (i.e., char to numeric)
> with data conversion functions.  I use SQL to create exception results,
> results where data exists in one table but not in another.  Using left
outer
> joins is great for that.
>
>
> Thank you,
> Matt Tyler
> Mattt@wincofoods.com
>
> -----Original Message-----
> From: Bob Carl [mailto:bcarl@knapheide.com]
> Sent: Thursday, October 10, 2002 09:09
> To: Midrange Computing Technical NewsGroup for ISeries
> Subject: SQL VS QUERY
>
> This is a multi-part message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> My account is getting ready to purchase some sort of IBM ISeries Query
tool,
> SQL tools, or both.  I have been asked to provide justification for
> investment in the SQL tool over or in addition to Query.
>
> Can you use SQL in a CL in the same fashion as query, such as to create a
> file(Like OPNQRYF). I would think you can.  I am wondering if we can scrap
> query all together in favor of SQL (RUNSQL). Right now we do not use SQL
for
> anything but transferring data, such as in Excel or Client Access, but
> considering its industry presence, it seems like a no-brainer.   Please
> submit to me your best arguments for using SQL, and if it can replace
Query
> completely and easily.
>
>  Thanks in advance.
>
> Bob Carl, Senior Systems Analyst
> Knapheide Manufacturing Company
> 217-223-1848 Ext. 2397
> Fax: 217-223-1947
>
> --
>
> _______________________________________________
> 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 message scanned for viruses by CoreComm
>