Default Settings Section
This table describes the SQR default settings:
Entry |
Value |
Description |
---|---|---|
|
TRUE | FALSE |
The default setting is FALSE. DB2 only: Forces a space after every comma not in a literal value to support the DECIMAL=COMMA setting on the OS390. |
|
TRUE | FALSE |
The default setting is FALSE. DB2 only: If set to TRUE, SQR displays database warnings in the SQR output file. |
|
TRUE | FALSE |
The default setting is FALSE. By default, SQR produces an error when a dynamic column specification does not match the database definition of the column. That is, character equals character, date equals date, and numeric equals numeric. When this value is set to TRUE, SQR allows character to be equal to either character or date columns. When a date column is type cast to be a character, SQR creates the string according to the following rules:
In the following example, AllowDateAsChar=True. This setting allows $Col1 to be either date or text.
|
|
LONG | SHORT |
Specifies the file name convention used for HTML output. SHORT specifies DOS style (8.3) and LONG specifies UNIX\Linux style (non 8.3). The default is LONG. This setting is ignored on 16-bit platforms. The DECLARE-TOC and -BURST commands force Output-File-Mode = LONG. The following list items represents the file formats for UNIX\Linux, DOS, and Windows. SQR and SQRT: {Program} is the name of the SQR/SQRT file without the extension. |
(continued) |
LONG | SHORT |
(continued) For Output-File-Mode = SHORT, SQR-generated file names are limited to a DOS 8.3 format.
bb ranges from 00 to 99 and represents the report number. nn ranges from 01 to 99 and represents the report number. xx ranges from 00 to ZZ and represents the graphic number. |
(continued) |
LONG | SHORT |
(continued) For Output-File-Mode = LONG, SQR-generated file names are not constrained to a DOS 8.3 format. {output}={program} of first report and {program}_nn for multi-reports.
bb ranges from 01 to ZHJOZI and represents the bursted page group number. nn ranges from 01 to 99 and represents the report number. zz ranges from 00 to ZHJOZI and represent the graphic number. |
(continued) |
LONG | SHORT |
(continued) SQRP: {file name} is the name of the SPF file without the extension For Output-File-Mode = SHORT, SQR-generated file names are limited to a DOS 8.3 format.
xx ranges from 00 to ZZ and represents the graphic number. |
(continued) |
LONG | SHORT |
(continued) For Output-File-Mode = LONG, SQR-generated file names are not limited to a DOS 8.3 format.
bb ranges from 01 to ZHJOZI and represents the bursted page group number. zz ranges from 00 to ZHJOZI and represents the graphic number. |
|
Name of a locale defined in the pssqr.ini file or the name SYSTEM. |
Specifies the initial locale that SQR loads when the program starts. The value of SYSTEM is used to reference the default locale. See ALTER-LOCALE. |
|
INTEGER | FLOAT | DECIMAL[(p)] | V30 |
Specifies the default numeric type for variables. The command line flag -DNT overrides this setting. Similarly, the DECLARE-VARIABLE command overrides this setting. See DECLARE-VARIABLE. |
|
TRUE | FALSE |
The default value is FALSE. When set to TRUE, the -Dnn command line flag outputs the Form-Feed character that denotes a page break. |
|
TRUE | FALSE |
The default value is TRUE. When set to TRUE, SQR generates a warning message (sent to the warning file) when a YY or RR date edit mask is encountered during a program run. This setting affects only SQR code that is processed. |
|
TRUE | FALSE |
The default value is FALSE. When set to TRUE, SQR treats the YY date edit mask as though it is an RR edit mask. See the RR edit mask. |
Note: Use the setting V30 to process numbers in the same manner as in previous (before V4.0) releases. Specifically, all numeric variables and literals, including integer literals, are declared as FLOAT.