.* ********************************************************************
.* EXCSQL: Help text for Execute SQL statement
.* Copyright (C) 2001  Martin Rowe  <martin@dbg400.net>
.*
.* This program is free software; you can redistribute it and/or modify
.* it under the terms of the GNU General Public License as published by
.* the Free Software Foundation; either version 2 of the License, or
.* (at your option) any later version.
.*
.* This program is distributed in the hope that it will be useful,
.* but WITHOUT ANY WARRANTY; without even the implied warranty of
.* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
.* GNU General Public License for more details.
.*
.* You should have received a copy of the GNU General Public License
.* along with this program; if not, write to the Free Software Foundation,
.* Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307   USA
.* ********************************************************************
.* First panel
:PNLGRP.
.**********************************************************************
:HELP NAME=EXCSQL .
Execute SQL - Help.
:P.
This command executes a prepared SQL statement via the QMQRY interface.
The output from the SQL (if any) can be diverted to the screen, a report or
an outfile. The interactive SQL interface (STRSQL) is not required to be
installed for this command to run.
:EHELP.
:HELP NAME='EXCSQL/SQL'.
SQL (SQL) - Help.
:P.
:HP3. SQL :EHP3.
A valid SQL statement enclosed in single quotes is required. This can be
any of the supported SQL commands; SELECT, INSERT, DELETE, UPDATE, etc.
A maximum statement length of 825 is permitted, but interactive
prompting is limited to 512.
:EHELP.
:HELP NAME='EXCSQL/OUTPUT'.
Output (OUTPUT) - Help.
:P.
:HP3. OUTPUT :EHP3.
Specifies whether the output from the command (if any) is displayed on
screen, dumped to a report or written to an output file.
:P.
Three options are available.
:P.
:HP3. * :EHP3.
:P.
The output is shown on screen.
:P.
:HP2. *PRINT :EHP2.
:P.
The output is diverted to a (named) printer file.
:P.
:HP2. *OUTFILE :EHP2.
:P.
The output is written to a database file.
:EHELP.
:HELP NAME='EXCSQL/SRTSEQ'.
Sort sequence (SRTSEQ) - Help.
:P.
:HP3. SRTSEQ :EHP3.
Specifies the sort sequence to be used for string comparisons when the
SQL statement is run. This just runs a CHGJOB SRTSEQ() prior to executing
the SQL command, and resets it back to the job's original value afterwards.
:P.
Six single choice options are available, or you can specify any valid
sort sequence table (*TBL) that you have access to. See the help text for
CHGJOB SRTSEQ() for full details (from which some of the following was
taken).
:P.
:HP3. *SAME :EHP3.
:P.
The sort sequence is not changed. The job's setting is used.
:P.
:HP2. *SYSVAL :EHP2.
:P.
The system value QSRTSEQ is used.
:P.
:HP2. *USRPRF :EHP2.
:P.
The sort table specified in the user profile under which this
job was initially running is used.
:P.
:HP2. *HEX :EHP2.
:P.
A sort sequence table is not used.  The hexadecimal values of
the characters are used to determine the sort sequence.
:P.
:HP2. *LANGIDUNQ :EHP2.
:P.
A unique-weight sort table is used. This is generally case-sensitive.
:P.
:HP2. *LANGIDSHR :EHP2.
:P.
A shared-weight sort table is used. This is generally case-insensitive.
:EHELP.
:HELP NAME='EXCSQL/PRTF'.
Printer File (PRTF) - Help.
:P.
:HP3. PRTF :EHP3.
If OUTPUT(*PRINT) is selected, then this parameter determines the choice
of printer file used by the report. The default is *EXCSQL which uses this
utility's own 99x198 width report. Any valid non-described printer file
(such as QSYSPRT) could be used instead.
:P.
:HP2. Printer file Library :EHP2.
:P.
The printer file's library, *CURLIB or *LIBL, is required.
:EHELP.
:HELP NAME='EXCSQL/OUTFILE'.
Output file (OUTFILE) - Help.
:P.
:HP3. OUTFILE :EHP3.
The name of the database file to hold the output of the SQL statement
of OUTPUT(*OUTFILE) is selected. If the file already exists, then the format
should match that of the output, otherwise the command will fail.
:P.
:HP2. Output file Library :EHP2.
:P.
The output file's library, *CURLIB or *LIBL, is required.
:EHELP.
:HELP NAME='EXCSQL/OUTMBR'.
Output member options (OUTMBR) - Help.
:P.
:HP3. OUTMBR :EHP3.
The name of the database file member to receive the command output.
:P.
:HP2. *FIRST :EHP2.
:P.
The first member in the database file is used.
:P.
Three options are available for output to a database member.
:P.
:HP3. *REPLACE :EHP3.
:P.
The member is cleared prior to the command output being added to the file
:P.
:HP2. *ADD :EHP2.
:P.
Any new records are added to those (if any) already in the member.
:P.
:HP2. *UPDADD :EHP2.
:P.
Records with duplicate key values are used update existing records in the
target *OUTFILE. New unique records are added to the end of the member.
:EHELP.
:EPNLGRP.

-- MartinRowe - 24 Jun 2005
Topic revision: r1 - 24 Jun 2005 - 05:56:20 - MartinRowe
 
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding DBG/400? Send feedback