Re: CL & SQL

[Martin Rowe <martin@xxxxxxxxxx>]

On Tuesday 08 May 2001 22:43, you wrote:
> Hi All,
>
> I'm new to imbedded SQL.  Can SQL statements be executed from within a
> CL program and if so, what resource should I be looking for to guide me
> in how to do it.  Thanks.
>
> Buzz Fenner
> mailto:bfenner@jonesborocwl.org

Hi Buzz

I don't think there is a CL equivalent to SQLRPG, but there are a few 
options for running SQL from a CL. As long as you have Query Manager (the 
existance of STRQMQRY & CRTQMQRY commands should show that) you can use 
the RUNSQLSTM command to run an existing SQL statement held in a source 
member. An alternative is to use a third party tool that accepts an 
ad-hoc SQL request as a command parameter. There are a few of them around 
including my own EXCSQL (see the Extras section on my home page - see 
.sig below) that do this fine. It supports output (if any) to screen, 
report or *OUTFILE.

Regards, Martin
-- 
martin@dbg400.net / jamaro@firstlinux.net
http://www.dbg400.net  DBG/400 - DataBase Generation utilities 
Open Source test environment tools for the AS/400 / iSeries and 
miscellaneous database & spooled file management commands.
+---
| 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
+---