Re: SQL in CL.

["Martin Rowe" <dbg400.net@xxxxxxxxx>]

On 21/04/06, Jake M <jakeroc@xxxxxxxxx> wrote:
> if I want to use EXCSQL, does it have to be special installation?

It should be fairly straightforward - instructions are in the top of
the xml file in the download zipfile from
http://www.dbg400.net/excsql.html There are just four source members
(CL, QMQRY, PNLGRP & CMD) to compile to install it.

> Mark
> Waterbury helped me to run the RUNSQLQRY on my iSeries and I love the little
> tool. EXCSQL seems like a similar tool, am I right in assuming that? Please
> feel free to correct me if I am wrong.

I'm not familiar with RUNSQLQRY but EXCSQL lets you run pretty much
any SQL statement, and if it's a SELECT, divert the results to an
*OUTFILE or report.

Regards, Martin
--
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X
TWiki - an Enterprise Collaboration Platform - http://twiki.org/   / \