RE: SQL in CL

Addendum:

If you buy Sequel from ASC, one of the tools included is a CL command for
executing SQL statements that is equivalent in function to OPNQRYF.
Logically enough, the command is named OPNSQLF.  I've never heard of anyone
else offering anything comparable.

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

-----Original Message-----
From: R. Bruce Hoffman, Jr. 

-----Original Message-----
From: Angela Wawrzaszek <wawrzaszeka@AUSTEEL.com>
To: Midrange Mail List (E-mail) <midrange-L@midrange.com>
Date: Tuesday, August 01, 2000 1:41 PM
Subject: SQL in CL


>I would like to use SQL statements to select the records from a file for an
>inquiry screen.  Is it better to do this within an RPG program with
/EXEC
>SQL  or within the CL before I go to the RPG program.  If it is in the CL
>how do I go about doing that - is it through runsqlstm and the source of
the
>select is in QSQLSRC or can I directly put my select statements in the CL
>somehow?   Or last but not least am I just better off performance wise just
>using SETLL and CHAIN in my RPG???
>


RPG with /EXEC - yes.

CL - no, but you could use OPNQRYF (Open Query File) CL does not have a
pre-processor for SQL.

Performance - yes, better with SETLL and CHAIN.
(still in most cases, although I call it a wash, significantly less
programming effort with SQL)
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---