SQL 
|
| SQL | | SET, SHOW and CLEAR |
SET
ON.
CLEAR
OFF.
SHOW
Specify the name of the parameter and, optionally, any values with these commands. Certain parameters can also be set by options on the SQL execution statement.
The values of some settings are used to set column formats when a table is created. Altering these settings has no effect on existing tables. You can update the format of columns in existing tables with the column command.
| |
AUTODISP
AUTOSAVEAUTOD CLEARCASESET, there is an implicit CIR record
type added to the records in the FROM list of a
SELECT. Joins and aggregations are done within each case
rather than over all the records in the database. There is an implied
Join by caseid. When aggregations are performed, there is an implied
GROUP BY caseid clause on the SELECT
specification. The setting of case has no effect on caseless databases.
CLEAR disables use of the database case structure during
retrieval processing. In join operations, records are joined across all records
in the database. System and user created paths may join records within case even
with cases cleared. Aggregations occur within records or tables.SETCASELIM n
SELECT.
When the limit is reached, the process stops and prompts to continue with three
options; continue and receive a further warning after another
CASELIM number of rows are created; continue with a different
CASELIM; stop the SELECT.
CLEAR disables the check. CLIMCMPTRIM
SETCMPUPPER SETCOLHEAD
DISPLAY command. SETCONTINUE '-'CONTINUE cannot be CLEARed though it may be
set to ' ' (a blank). CONT DATABASEDATE 'format'CLEAR clears the
default date map. If the column comes from a database, the format described in
the schema is used as a default. Mmm DD, YYYY'.DEFINE_SECURITY
SELECT have security definitions. When connecting
to a tabfile with
security definitions, specify group(.user) names to connect to the tabfile. Anyone with DBA permission
at the tabfile level, has full permissions for all tables. With DEFINE_SECURITY set, you
have full permissions for the new table created with SELECT but any other groups(.users)
(except DBAs) have no permissions on that table. You (or a DBA) can grant permissions to other users.
(see Permissions)CLEAR specifies that created tables are Public access. SETDETAIL
BREAK or GROUP commands.
CLEAR suppresses the printing of the detail lines. Subtotal
and total lines are printed. DET, DTL
SETDOUBLE
CLEAR specifies
that rows are displayed single-spaced, that is with no blank lines between them.
DBL CLEARDPLACES n CLEAR resets to the default number of decimal places.
DPL ECHO CLEAREXEC SELECT commands are translated and
executed after the last line of the statement is entered.
CLEAR prompts to translate and then execute the query.
SETEXPONENT n
CLEAR specifies that decimal notation is used. CLEARFAMILY family_name[/password]CLEAR clears the default family name and password.
FAM GROUPING CLEAR specifies that if
break levels are displayed, the break column values are printed on every line.
GRP SETGRPSIZE n
GROUP
BY option on SELECT. If the number of different
values grouped by, is less than or equal to this value, all processing is done
in memory. If the number of entries exceeds this value, a disk sort is
performed. CLEAR specifies that the GROUP BY
in-core sort size is 1. INPUT filename [NOABORT]END command
is encountered or end-of-file is detected. This is normally used for batch runs
and is set as a parameter on the execution statement. Use this command
interactively to run stored command sequences.NOABORT specifies that the command in
error is written to the LOG file, and processing continues.LABEL CLEAR specifies that variable names are used for column
headings and break titles. LAB CLEARLOWER
PRINT
command has mixed uppercase and lowercase characters. This is identical to
CLEAR UPPER . CLEAR LOWER specifies that the
report produced by the PRINT command is in uppercase only and
lowercase characters are translated to uppercase. This is identical to
SET UPPER. SETMASTER 'master_ip[:port]' MEMBER member_name [/password]
CLEAR specifies that there is no default
member.MEM MISSCHAR 'c' SET NULL. CLEAR sets the character to blank.
This is equivalent to specifying SET MISSCHAR ' '.
MISS NULL 'string' NULL takes precedence over MISSCHAR.
CLEAR clears the parameter; fields with missing values are
filled with the MISSCHAR character. CLEAROUTPUT filename CLEAR specifies
that there is no default output file and must be named on the
OUTPUT clause on PRINT or WRITE commands.
OUT
CLEAR.PATH SELECT.
CLEAR specifies that paths are not automatically used by
SELECT and you must name a path explicitly in a
SELECT to use it. SHOW PATH [ path_name ]
As well as showing the current path parameter setting, SHOW
PATH shows the definitions of all paths or of the pathname specified.
SETRECLIM n SELECT. When the limit is reached, the process stops and
prompts whether to continue. There are three options: continuing and receiving a
further warning after another RECLIM number of records is
processed, continuing with a different RECLIM, and stopping
the SELECT at that point. CLEAR disables the
record limit option. RLIM SELLIM n SELECT. When this number of new rows is reached, the process
stops and prompts whether to continue with three options; continue and receive a
further warning after another SELLIM number of rows are
created; continue with a different SELLIM; stop the
SELECT. CLEAR disables the select limit on
new rows. SLIM SELSIZE n
SELECT. If the number of different
values selected in the sub-query, is less than or equal to this value, all
processing is done in memory. If the number of entries exceeds this value, disk
I/O is performed. This parameter controls the number of entries that are kept in
memory. CLEAR specifies that the in-core size is 1.
SEPARATE 'string'
CLEAR specifies that columns are not separated.
SEPSINGLE
SET
DOUBLE or SET TRIPLE. To see the value of all line
spacing parameters, use SHOW SPACING. SGL SET.SPACEC n m
CLEAR specifies that there are no blank lines. SPACED n m
CLEAR specifies that there are no blank lines. CLEARSPACES n m
CLEAR specifies that there are no blank lines. SPACET n m CLEAR
specifies that there are no blank lines. SRTSIZE n
ORDER BY clause on
SELECT for detail rows.
CLEAR sets the sort size to the default of 1000.STATS SELECT. These same statistics are displayed
whenever a SELECT reaches a CASELIM, RECLIM
or SELLIM and prompts for a decision to continue.
CLEAR suppresses the display of statistics after a
SELECT. CLEARSUBTOTAL
BREAK
or GROUP command is given for a report.
CLEAR specifies that subtotals are not automatically produced
for breaks or groups for a report. STOT
SETTABFILE name CONNECTing to a tabfile
sets that tabfile to the default.TF $SYSTEMTABSIZE n SELSIZE. The use of a sub-query on
SELECT requires the holding of the results of the sub-query.
This parameter controls the size of the internal buffer. If the number of
different values selected in the sub-query, is less than or equal to this value,
all processing is done in memory. If the number of entries exceeds this value, a
disk I/O is performed. This parameter controls the number of entries that are
kept in memory. CLEAR specifies that the in-core size is 1.
TIME 'format'
CLEAR specifies that
system default time format is used. HH:MM:SS'TOTALS 'string' 'string' is a label displayed on the total line
in the left margin. If not specified, the default label is
TOTAL. CLEAR disables the total line
display. TOT, TOTAL CLEARTRANSFER_VALLAB
CLEAR specifies that
value labels are not transferred to the new table. SETTRIPLE SET
SINGLE and SET DOUBLE. To see the value of this
parameter, use SHOW SPACING. TPL UNDERCOL CLEAR specifies no underlining. UCOL,
UNDCOLSETUNDHEAD CLEAR specifies no underlining. UHEAD
SETUPPER
PRINT is in
uppercase. (Identical to CLEAR LOWER.)CLEAR
UPPER specifies that reports are in mixed lower and upper case.
(Identical to SET LOWER. )UC
CLEARVALLAB CLEAR specifies that values are
used regardless of whether value labels exist. CLEARVARCHAR n SELECT. Field size
is determined by the definition of the column or expression.
CLEAR sets the display width of character fields to zero; they
are not displayed. VCHR WIDTH {n | LABEL | MIN} LABEL); or, for numeric fields, to the minimum number
of characters necessary to accommodate the widest number in the column
(MIN). The MIN option can only be used at
the table level in the display processor. CLEAR sets the
column widths to 8 for numeric data and to the string length specified in the schema for strings.CLEARWORK filename [PASSWORD password]
SAVE and
GET. CLEAR specifies that there is no
default workspace. SirSQL.wspZEROS ON | OFF | 'string' ON means leading zeros are printed; OFF
means they are suppressed. Also specifies a string to be printed if the value is
zero. CLEAR is the same as SET ZEROS
OFF.ZERO CLEAR| |