You are here:
DBG/400
>
DBG400 Web
>
SourceCodeList
>
PnlGrpSource
>
PnlGrpEXCSQL
(24 Jun 2005,
MartinRowe
)
(raw view)
E
dit
A
ttach
<verbatim> .* ******************************************************************** .* 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. </verbatim> -- Main.MartinRowe - 24 Jun 2005
E
dit
|
A
ttach
|
P
rint version
|
H
istory
: r1
|
B
acklinks
|
V
iew topic
|
Edit
w
iki text
|
M
ore topic actions
Topic revision: r1 - 24 Jun 2005 - 05:56:20 -
MartinRowe
DBG400
Log In
DBG400 Web
Index
Search
Changes
Notifications
Statistics
Site Map
Downloads
Webs
DBG400
Jamaro
Main
Sandbox
Sandtub
System
Send a link to this page
Copyright © 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