S/390 SQL Command Processor V1.5

execsql is a rough and ready SQL command processor which runs on
OpenEdition.  It connects to an MVS subsystem name (the subsystem needs
to be set up by an MVS system administrator) and executes the SQL
statements in the named script file.  Execution is invoked by:

execsql script-filename

The SQL script file can contain a number of commands (each of which must
be terminated with a semicolon).  Long SQL commands can be broken over
several lines (no special line delimeter character is required although \
can be used as a line terminator).

Any SQL errors produced during execution are written to standard output.
Full SQL error message output (SQLCODE, SQLSTATE and text messages) is
provided in the event that an SQL error occurs.

execsql also supports SELECT commands along with the more usual SQL
commands (DELETE, INSERT, UPDATE, table/index creation and dropping,
etc.)

The output from SELECT matches (pretty closely) the output produced by a
SELECT statement run on an AIX version of DB2.  The main difference is
that the output of several sequential SELECT statements can be produced
by the utility rather than the single SELECT statement model used in the
interactive DB2 command interfaces.

The SELECT statement formats allowed are:

SELECT * FROM...WHERE...
SELECT col1,col2...col n FROM...WHERE...
SELECT COUNT(*) FROM ...WHERE...
SELECT COUNT(DISTINCT col-n) FROM ...WHERE...

The actual syntax of the SELECT statements is the same as that used in DB2.