Re: SQL in CL

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----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)

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin



+---
| 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
+---