[Default-Settings] defines Production Reporting default actions.
Table 77. Entries in [Default-Settings]
| Default = FALSE | By default, Production Reporting produces an error when a dynamic column specification does not match the column’s database definition. That is, character equals character, date equals date, and numeric equals numeric. When set to TRUE, Production Reporting allows characters to equal either character or date columns. When a date column is “type cast” as a character, Production Reporting creates the string according to the following rules:
In the following example, AllowDateAsChar=True. This allows $Col1 to be either date or text. Begin-Select [$Col1] &col1=Text [$Col2] &col2=Date [$Col3] &col3=Number from MyTable End-Select | |
Default = FALSE | When set to TRUE, Production Reporting auto-detects UCS-2 encoded files. See AutoDetectUnicodeFiles Key for more information. | |
Default = Comma | Defines the character used as a delimiter when creating CSV files. If the CSVSeparator setting is missing from SQR.INI, the default value of Comma is used. Note: Specifying the CSVSeparator as a semicolon or a space is only supported with the Production Reporting Server. Using this setting in Oracle Enterprise Performance Management Workspace, Fusion Edition is not recommended and may create corrupt files. | |
Specifies the default numeric type for variables. -DNT and DECLARE‑VARIABLE override this setting. (See DECLARE-VARIABLE.) | ||
Default = TRUE | Controls whether to print the license expiration warning message. | |
| FormatforRowsetXML | BIP | SQR Default = SQR | Format in which to create the XML file defined with OPEN-RS, WRITE-RS, and CLOSE-RS. |
Default = 6 | Defines the compression level when PRINT-IMAGE references a BINARY variable. | |
Defines the initial locale that Production Reporting loads when the program starts to execute. The value of SYSTEM is used to reference the default locale. (See ALTER-LOCALE.) | ||
Default = FALSE | When set to FALSE, Production Reporting uses Grafsman chart package. When set to TRUE, Production Reporting uses Jchart chart package. Set NewGraphics=TRUE to use the following features:
| |
Default = FALSE | Describes whether to retry an EXECUTE command. FALSE, retries EXECUTE and returns an error from the database. | |
Default = WARN | Describes what to do when a 'Weak' reference cursor is processed. STOP displays an error or warning message and terminates the Production Reporting procedure. WARN displays an error or warning message, and the Production Reporting procedure continues. SKIP does not display an error or warning message, and the Production Reporting procedure continues. | |
Default = LONG | Specifies the filename convention used for HTML output. SHORT specifies DOS style (8.3) and LONG specifies UNIX style (non 8.3). (Ignored on 16-bit platforms) DECLARE-TOC and -Burst force Output-File-Mode = LONG. The following represent the file formats for UNIX, DOS, and Windows. SQR and SQRT: {Program} is the name of the SQR/SQT file without the extension For Output-File-Mode = SHORT, SQR-generated filenames 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. For Output-File-Mode = LONG, SQR-generated filenames 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 in radix 36. nn ranges from 01 to 99 and represents the report number. zz ranges from 01 to ZHJOZI and represents the graphic number in radix 36. | |
SQRP: {Filename} is the name of the SPF file without the extension For Output-File-Mode = SHORT, SQR-generated filenames are limited to a DOS 8.3 format. xx ranges from 00 to ZZ and represents the graphic number. For Output-File-Mode = LONG, SQR-generated filenames are not limited to a DOS 8.3 format. bb ranges from 01 to ZHJOZI and represents the bursted page group number in radix 36. zz ranges from 01 to ZHJOZI and represents the graphic number in radix 36. | ||
Default = FALSE | When set to TRUE, -Dnn outputs the Form-Feed character that denotes a page break. | |
Default = TRUE | When set to TRUE, Production Reporting generates a warning message (sent to the warning file) when a YY or RR date edit mask is encountered during a program run. This affects only Production Reporting code that is processed. | |
Default = Enhanced | Controls the HTML output produced by ‑PRINTER:HT. Standard produces version 2.0 HTML files with report content inside<PRE></PRE> tags. Enhanced maps -PRINTER:HT to ‑PRINTER:EH and produces content formatted with version 1.1 XHTML tags. | |
SUBSTITUTION-CHARACTER=XX EncodingName1 [,xx EncodingName2...] | XX is the hexidecimal representation of the substitution variable | Allows substitution characters to be defined on a character set by character set basis. See Substitution-Character Key for more information. |
Default = TRUE | ||
Default = FALSE | By default, Production Reporting reads character streams into the system by “widening” them into 16-bit character strings. When set to TRUE, Production Reporting uses Unicode internally to normalize the data. | |
Default = FALSE | When set to TRUE, Production Reporting treats the YY date edit mask as though it is an RR edit mask. |