Default Settings Section

ForceSpaceAfterComma={TRUE|FALSE}

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.

ShowDBWarnings={TRUE|FALSE}

TRUE | FALSE

The default setting is FALSE.

DB2 only: If set to TRUE, SQR displays database warnings in the SQR output file.

AllowDateAsChar={TRUE|FALSE}

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:

• For DATETIME columns, SQR uses the format specified by the SQR_DB_DATE_FORMAT setting. If this is not set, SQR uses the first database-dependent format listed in the table showing default database formats in the Edit section under the PRINT command.

• For DATE columns, SQR uses the format specified by the SQR_DB_DATE_ONLY_FORMAT setting. If this is not set, SQR uses the format listed in the table showing default database formats in the Edit section under the PRINT command.

• For TIME columns, SQR uses the format specified by the SQR_DB_TIME_ONLY_FORMAT setting. If this is not set, SQR uses the format listed in the table showing the TIME column formats in the Edit section under the PRINT command.

In the following example, AllowDateAsChar=True. This setting allows $Col1 to be either date or text.

Begin-Select  
  [$Col1] &col1=Text  
  [$Col2] &col2=Date  
  [$Col3] &col3=Number  
  from MyTable
End-Select

OUTPUT-FILE-MODE

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.

OUTPUT-FILE-MODE

(continued)

LONG | SHORT

(continued)

For Output-File-Mode = SHORT, SQR-generated file names are limited to a DOS 8.3 format.

• Output file = {program}.lis for first, and {program}.lnn for multi-reports

• SPF file = {program}.spf for first, and {program}.snn for multi-reports

• PDF file = {program}.pdf for first; and {program}.pnn for multi-reports

• HTM file = {program}.htm for “frame, and {program}.hbb for report bodies

• GIF file={program}.gxx for all reports

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.

OUTPUT-FILE-MODE

(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.

• Output file = {output}..lis

• SPF file = {output}..spf

• PDF file = {output}..pdf

• GIF file = {output}_zz..spf

• HTM files = {output}..htm, {output}_bb..htm, {output}_frm..htm, {output}_toc./htm, {output}_nav.htm

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.

OUTPUT-FILE-MODE

(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.

• Output file = {file name}.lis

• GIF file = {file name}.gxx

• PDF file = {file name}.pdf

• HTM file = .htm and {file name}.h00

xx ranges from 00 to ZZ and represents the graphic number.

OUTPUT-FILE-MODE

(continued)

LONG | SHORT

(continued)

For Output-File-Mode = LONG, SQR-generated file names are not limited to a DOS 8.3 format.

• Output file = {file name}.lis

• PDF file = {file name}.pdf

• GIF file = {file name}_zz.spf

• HTM files = {file name}.htm, {file name}_bb.htm, {file name}_frm.HTM, {file name}_toc.htm {file name}_nav.htm

bb ranges from 01 to ZHJOZI and represents the bursted page group number.

zz ranges from 00 to ZHJOZI and represents the graphic number.

LOCALE

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.

DEFAULT-NUMERIC

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.

OutputFormFeedWithDashD={TRUE|FALSE}

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.

OutputTwoDigitYearWarningMsg={TRUE|FALSE}

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.

UseY2kCenturyAlgorithm={TRUE|FALSE}

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.