SQR Programmer Reference Card

SQR Programmer Reference Card

SQR language version 2.x-8.2

(In Progress: Use at your own risk)

© 1998-2006, Ray Ontko & Co.
Don Mellen, Editor. Please direct comments, suggestions, and corrections to donm@ontko.com.
This document may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice.

TABLE OF CONTENTS

Conventions Used In This Document
SQR / SQRT / SQRP Command Line
Special Characters
Data Types
Pre-Defined Variables
Environment Variables & SQR.INI
Position Syntax
RGB Syntax
Array Dot Syntax
COMMAND REFERENCE
Expressions
Print Format Commands
Compiler Directives
Character Set Encodings
Chart Attributes
Tables

Common HP Symbol Sets
Font Numbers
Non-Roman PDF Fonts
Default DATE-TIME Formats
Default Database Date Formats
Default Database Date Only Formats
Default Database Time Only Formats
Units of Measure
Paper Size Names
Input Status
Bar Code Types
-M File Entries
Hardcoded Limits
SQR Return Values
Printer and Output File Types and Their Supported Image Types

HTML Procedures

HTML General Purpose
HTML Headings
HTML Highlighting
HTML Hypertext Links
HTML Lists
HTML Tables

CONVENTIONS USED IN THIS DOCUMENT

[]   Optional parameters.

{}   Required parameters.

|   Separates a list of "either/or" options.

()   Notes or additional comments.

(Item) _+x.x   Denotes items that were added in version "x.x".

(Item) _*   Denotes items that are becoming obsolete (but still backward compatible).

(Item) _-x.x   Denotes items that were removed in version "x.x".

Items can be commands (in which case the version information applies to the entire command), or command options (in which case the version information applies only to that option within that command).
All information comes from a base of version 2.0, i.e. Any command or command option without version designation has existed since 2.0.
When listing the acceptable values for parameters with pre-defined values, if not otherwise specified, the default value is listed first.

SQR COMMAND LINE

{SQR} [Program] [Connectivity] [Flags...] [Args...] [@File]
Where SQR is one of SQR | SQRW | SQRJ _+4.2, -5.1 | SQRWJ _+4.2, -5.1 | SQRD _+4.3.3 | SQRWD _+4.3.3 | SQRDJ _{+4.3.3, -5.1} | SQRWDJ _{+4.3.3, -5.1}

SQRT COMMAND LINE _+3.0

{SQRT} [Program] [Connectivity] [Flags...] [Args...] [@File]
Where SQRT is one of SQRT | SQRWT | SQRTJ _+4.2, -5.1 | SQRWTJ _+4.2, -5.1 | SQRDT _+4.3.3 | SQRWDT _+4.3.3 | SQRDTJ _{+4.3.3, -5.1} | SQRWDTJ _{+4.3.3, -5.1}

SQRP COMMAND LINE _+3.0

{SQRP} [spf-File] [Flags...]
Where SQRP is one of SQRP | SQRWP | SQRPJ _+4.2, -5.1 | SQRWPJ _+4.2, -5.1

Args...

Arguments are used by the SQR ASK and INPUT commands while report runs.

@File

Files contain report arguments, one argument per line.

FLAGS FLAG DESCRIPTIONS PROG

-A Causes the report output to be appended to an existing file of the same name. SQR
SQRT
SQRP

-Bn Indicates how many rows to buffer during each retrieve of data from the database. (Oracle) (SYBASE CT-Lib) _+3.0 (ODBC) _+4.3.2 SQR
SQRT

-BURST:{T|S|P} _+4.1 T generates the TOC file.
S[Level] uses the symbolic TOC to generate, bursting on the level Level.
The flag -BURST:S is the same as -BURST:S1
P[Pages, Range[,Range]... ] uses page numbers to generate, Pages is the number of logical report pages for each HTML file, and Range is the page selection in one of the forms: x, x-y, x-, -y.
-BURST:P is the same as -BURST:P0,1- using -PRINTER:HT.
-BURST:P is the same as -BURST:P1- using -PRINTER:EH.
(Requires -PRINTER:HT or -PRINTER:EH) SQR
SQRT
SQRP

-C _+3.0 Makes the Cancel dialog box appear during program execution. (Windows) SQR
SQRT

-CB _+3.0 Forces the communication box to be used. (Windows, Callable SQR) SQR

-Dn Causes output to be displayed to the terminal as well as written to a file. Pauses after n lines. (Requires -PRINTER:LP) (non-Windows) SQR
SQRT
SQRP

-DB{database} Causes the program to use database. Overrides embedded SQR "USE" command. (SYBASE) SQR
SQRT

-DEBUG[x] Causes 'DEBUG' to be defined. "#DEBUG" or "#ifdef DEBUG" lines will be compiled. The x allows multiple debugs. DEBUGAB defines DEBUG, DEBUGA, and DEBUGB. SQR

-DNT:{x} _+4.0 Specifies Default Numeric Type for numeric variables. x can be V30, Integer, Float, or Decimal. To specify a Decimal precision, append a colon delimiter. (i.e. -DNT:Decimal:20). SQR

-E[file] Causes error messages to be recorded in the named or default file. SQR
SQRT
SQRP

-EH_APPLETS _+5.1 Specifies the directory for Enhanced HTML applets. SQR
SQRT
SQRP

-EH_BQD _+4.3.3 Create a (Report).bqd file (BrioQuery Data) from the data in the report and add a BQD icon to the HTML navigation bar. SQR
SQRT
SQRP

-EH_BQD:file _+6.0 Associate the BQD icon with the specified file. SQR
SQRT
SQRP

-EH_BROWSER _+5.1 ALL(default) _+4.3.4 generates HTML that will auto-sense the browser being used.
IE or NETSCAPE generates an HTML file designed for the specific browsers.
BASIC _+6.0 generates "every-browser" HTML.
(see also SQR.INI - Enhanced HTML) SQR
SQRT
SQRP

-EH_CSV _+4.3.1 Create a (Report).csv file from the data in the report. SQR
SQRT
SQRP

-EH_CSV:file _+4.3.1 Associate the CSV icon with the specified file. SQR
SQRT
SQRP

-EH_CSVONLY _+5.1 Create a (Report).csv file from the data in the report, but no accompanying HTML file. SQR
SQRT
SQRP

-EH_DEBUG[:opts] _+6.2 Create a Report.dbg file. File will contain messages about both internal and compiler errors. Possible enhanced HTML debugging opts...
Timing (Show elapsed time of EHTML execution.)
Memory (Show memory usage statistics.)
Help (Show these options.)
Direct _+8.0 (Show Print-Direct packets.)
PSqribe _+8.0 (Show PowerSQRIBE packets.)
ZipAll _+8.2 (ZIP debug, spf, and security xml files.) SQR
SQRT
SQRP

-EH_FULLHTML:level _+5.1 Default: _-8.0 report generates HTML 3.2.
Default: _+8.0 report generates XHTML 1.1.
Possible values are:
40 _+6.0  _-8.0 - generates HTML 3.2
40 _+8.0 - generates XHTML 1.1
32 _+6.0 - generates HTML 3.2
30 _+6.0  _*6.2 - generates HTML 3.0  _{in 6.1.3 and 6.1.4}
30 _+6.0  _*6.2 - generates HTML 3.2  _{all others}
True _*6.0 - generates HTML 3.2
False _*6.0 - generates HTML 3.0  _{in 6.1.3 and 6.1.4}
False _*6.0 - generates HTML 3.2  _{all others}

(see also SQR.INI - Enhanced HTML) SQR
SQRT
SQRP

-EH_ICONS:dir _+4.3.1 Set directory where referenced HTML icons are stored. SQR
SQRT
SQRP

-EH_IMAGES:dir _+6.0 Set directory where navigation bar .GIF images are stored. SQR
SQRT
SQRP

-EH_KEEP _+6.0 Causes -EH_ZIP to copy instead of move. SQR
SQRT
SQRP

-EH_LANGUAGE _+5.1 English (default), French, German, Portuguese, Spanish, Japanese _+8.0, or Simplified Chinese _+8.0. Language for the navigation bar.
(see also SQR.INI - Enhanced HTML) SQR
SQRT
SQRP

-EH_PDF _+4.3.3 Add a PDF icon to the HTML navigation bar (automatic with -PRINTER:EP). SQR
SQRT
SQRP

-EH_SCALE:n _+4.3.1 Set Enhanced HTML scale from 50 to 200. SQR
SQRT
SQRP

-EH_XIMG _+6.1.3 Prevents path changes and format conversions for images. If checking into Portal, added this to the �Burst Options�. SQR
SQRT
SQRP

-EH_XML:file _+6.0 Associate the XML icon with the specified file. SQR
SQRT
SQRP

-EH_ZIP:file _+6.0 Moves generated files to file, or Report.zip if file not specified. SQR
SQRT
SQRP

-F{lib | lib/f(m) | f(m)} _+4.3.2 -8.0 Will override the default output file name LIS(Report) and use the named file. (Library can also be specified. If only a library is specified, the default-named report will be placed there. The "new-report" command ignores all -F settings.) (Multiple -F flags will apply to each of multiple reports in the order that they are "declare-report"ed.) (AS400) SQR
SQRT
SQRP

-F{path | pathfile | file} Will override the default output file name Report.LIS and use the named file. (Path can also be specified. If only a path is specified, the default-named report will be placed there. The "new-report" command ignores all -F settings.) _+2.26 (Multiple -F flags will apply to each of multiple reports in the order that they are "declare-report"ed.) _+3.0 SQR
SQRT
SQRP

-G{file_mode} _+3.0 -8.0 Enables specification of report output file mode. (VM) SQR
SQRT
SQRP

-G{file_attr} _+2.26 -8.0 Enables specification of report output file attributes. (VMS) (OpenVMS) _+3.0 SQR
SQRT
SQRP

-GPRINT={YES | NO} _+4.0 -8.0   If YES, ANSI control characters are written to the first column of each record of the file. NO omits the control characters. (MVS) SQR
SQRT
SQRP

-I{dir_list} _+3.0 Specifies the #INCLUDE files search paths. Comma or semi-colon separated. SQR

-ID _+3.0 Displays the copyright banner on the console. (non-Windows) SQR
SQRT
SQRP

-KEEP _+3.0 Creates an .SPF file for each report in addition to .LIS files. SQR
SQRT

-LL{S | D}{C | I} _+3.0 Load-Lookup: S=SQR,D=DB , C=case sensitive,I=case insensitive. SQR

-LOCK{xx} _+3.0, -6.0 Defines the types of locking (isolation level) for the session. (SQLBase) SQR
SQRT

-M{file} _-8.0 Points to a startup file containing program limits that override the defaults. SQR

-N{database} _-4.0 Uses the named database, rather than the default database. (Rdb) SQR
SQRT

-NOLIS _+3.0 Creates an .SPF file for each report instead of .LIS files. SQR
SQRT

-NR _+3.0, -6.0 Uses the No Recovery mode when connecting to the database. (SQLBase) SQR
SQRT

-O[file] _+3.0 Directs log messages to file. Defaults to report.log or to sqr.log in the current directory. (Windows) SQR
SQRT

-P _+3.0 -6.0 Directs output to the printer device. (VM) SQR
SQRT
SQRP

-P _+4.3 -8.0 Suppress printer control characters from column 1. (MVS, AS400) SQR
SQRT
SQRP

-PB _+3.0 Causes column data to retain trailing blanks. (Rdb _-4.0 , Informix) SQR
SQRT

-P{id[/pass]} _+3.0, -6.0 The role identifier used to associate permissions with SQR. (Ingres) SQR
SQRT

-PRINTER:{xx} _+3.0 Causes Printer type xx to be used when creating .LIS files. Valid values are LP, HP, HT _+4.0 , EH _+4.3.1 , EP _+4.3.3 , PD _+4.3.2.2 , PS, and WP (Windows only). WP output is sent to the printer without saving an output file. EP produces both EH and PD output. (EH is only available for limited platforms). SQR
SQRT
SQRP

-PRINTER:WP:{unc} _+6.0 Causes the printer with the UNC name unc to be used for printing. (Windows) SQR
SQRT
SQRP

-RS Scans, syntax checks, and saves report and "ASK" responses in a 'run time' file called (Report).SQT. SQR

-RT Immediately processes the 'run time' file and "ASK" responses saved with the -RS flag. SQR

-S Causes the status of all cursors to be displayed at the end of the report run. SQR
SQRT

-SORT{n} _+3.0, -6.0 Specifies the size of the sort buffer in characters. (SQLBase) SQR
SQRT

-T{n} For testing - causes 'order by' clauses to be ignored to save time during testing. Tests for n pages. SQR
SQRT

-TB _+4.0 Trims trailing blanks from character columns. (SYBASE CT-Lib, ODBC _+4.3, DB2 _+8.0, Teradata _+4.3) SQR
SQRT

-T{B | Z | BZ | ZB} _+4.0 -8.0 B _MVS leaves trailing blanks on character columns. B _AS400 removes trailing blanks on character columns. Z leaves trailing zeros on numeric columns. BZ or ZB does both. (MVS/DB2, AS400/DB2) SQR
SQRT

-TZ _+8.0 Trims trailing zeros from decimal portion of numeric columns. (DB2, Teradata) SQR
SQRT

-U{username} _+3.0, -6.0 Specifies the user name, overriding the connectivity string. (Ingres) SQR
SQRT

-V{server} Uses the named server. (Sybase and SQL Server _-8.0) SQR
SQRT

-V6 _+3.0, -4.0 Specifies V6 compatibility mode. (Oracle) SQR
SQRT

-XB _+3.0 Suppresses the SQR banner and the "SQR...End of Run" message. (non-Windows) SQR
SQRT
SQRP

-XC _+2.20 Suppresses final commit. (callable SQR) SQR
SQRT

-XCB _+3.0 Do not use the communications box. (Windows) SQR
SQRT

-XI _+4.0.0.2 Do not use interaction. If an ASK or INPUT require user interaction, an error will occur. SQR
SQRT

-XL Prevents SQR from logging on to the database. SQR
SQRT

-XLFF _+6.0 Prevents SQR from generating a trailing form-feed. SQR
SQRT
SQRP

-XMB _+3.0.13 Prevents program interruption by any message boxes. Errors will only be sent to an .err file and show/display statements will only be sent to a .log file. (Windows & NT) See also: -E. SQR
SQRT

-XNAV _+4.1 Prevents creation of the navigation bar when a single HTML file is produced by a single report (multiple HTML files will still trigger the navigation bar creation) SQR
SQRT
SQRP

-XP _+3.0 prevents SQR from creating temporary stored procedures.   (SYBASE DB-Lib) _-4.0 (SYBASE CT-Lib) _+3.0.13 SQR
SQRT

-XTB _+3.0 Preserves the trailing blanks in a .LIS file. SQR
SQRT
SQRP

-XTOC _+4.1 Prevents the Table of Contents creation if the -PRINTER: flag is other than HT or EH. SQR
SQRT
SQRP

-ZEN{name} _+6.1.4 Set default encoding name SQR
SQRT
SQRP

-ZIF{file} _+4.0 Sets the full path & name of the SQR initialization file, SQR.INI. SQR
SQRT
SQRP

-ZIV _+4.0 Invokes the SPF viewer after generating the program.spf file. The -KEEP flag is implicitly invoked. Only the first report will be passed to the viewer. SQR
SQRT

-ZMF{file} _+3.0 Specifies the full path & name of the SQR Error Message file, sqrerr.dat. SQR
SQRT
SQRP

-ZRF{file} _+5.1 Specifies the full path & name of an alternate registry.properties file (DDO). SQR
SQRT

SPECIAL CHARACTERS

(denoting data type)

& Begins a "bind" variable for a database column or expression, regardless of type.

$ Begins a text or date _+4.0 variable.

# Begins a numeric variable. (Decimal _+4.0 , Floating point, or Integer _+4.0).

% Begins a list variable. _+5.1 (DDO only)

@ Begins a marker location variable, used for identifying position fields inside BEGIN-DOCUMENT paragraphs.

' (Single Quote). Surrounds a text literal. For example, 'Ray Ontko & Co.'.
Double to include a quote inside a literal. For example, '''Yes!!'', he said.'.
NOTE: The exclamation mark must also be doubled or the rest of the line will be considered a comment.

! Begins a comment, everything after the mark will not be compiled.

- A dash at the end of a line continues the command onto the next line.

{} Encloses a substitution variable.

[] Encloses a dynamic SQL variable, dynamic query variable, or dynamic table name. Or a dynamic column name _+3.0

0X Begins a literal Hex number _+6.1.4 It is case INsensitive. Examples:

let #num = 0x53e58d
let #num = '0x53e58d'
move '0X53E58D' to #num
move 0X53E58D to #num !-- (not valid)
while #i < 0x53E58d !-- (check against 5,498,253)

Variable names may be of any length and are case insensitive. Variable names are known globally throughout a report, except if used in a local procedure, in which case they are local. To reference a global variable from within a local procedure, put an underscore between the special character and the variable name.

DATA TYPES _+4.0

DECIMAL

Numeric with a precision (total number of digits used to represent the number) from 1 to 38 (default 16). Valid decimal numbers are in the range -9.9999999999999999999999999999999999999E+4096 to +9.9999999999999999999999999999999999999E+4096

FLOAT

Double precision floating point numeric. Range and precision of these are machine dependent. Default type for numeric variables (this was the only numeric type in version 3.x and before).

INTEGER

Numeric integers with a range of -2,147,483,648 to +2,147,483,648.

DATE

Date in the range of January 1, 4713 BC to December 31, 9999 AD.

TEXT or CHAR

String. Length is limited by the memory of your computer.

LIST _+5.1 (DDO)

A non-recursive ordered collection of SQR variables.

If not defined with "declare-variable", any variable beginning with a "$" is a string variable. Any variable beginning with a "#" is the "default-numeric" type from "declare-variable" (defaults to float).
The "let", "move", "get" and "put" commands will auto-convert between some data types. They will auto-convert string <-> numeric, and string <-> date. They will not convert date <-> numeric.

PRE-DEFINED VARIABLES

#current-column The current column on the page.

$current-date _+4.0 The current date-time on the local machine when SQR starts running the program.

#current-line Refers to the physical line number on the page.

#end-file Set to one (1) if end of file occurs on READ, otherwise zero (0).

#page-count The current page number.

#return-status Value to be returned to the operating system when SQR exits.

#sql-count The count of rows affected by a DML statement (insert, update and delete).

$sql-error The text message from the database explaining the most recent error.

#sql-status The status value from the database after each query is compiled or executed.

$sql-text _+8.0 The text of the last SQL processed. Set by BEGIN-SQL, BEGIN-SELECT, and LOAD_LOOKUP. Available within ON-ERROR. Populated for DB2, DDO, INFORMIX, ODBC, ORACLE, SYBASE, and TERADATA.

$sqr-connected-db _+8.0
{sqr-connected-db} _+8.0 Backend database class from initial connection or "CONNECT" command.
Valid ODBC values are: DB2    INFORMIX    ODBC    ORACLE    REDBRICK    SYBASE    TERADATA
Valid DDO values are: _+8.2 CSV    DB2    ESSBASE    INFORMIX    MSOLAP    ORACLE    SAP    SQLSERVER    SYBASE    XML

$sqr-connected-db-name _+8.0
{sqr-connected-db-name} _+8.0 Database driver name from initial connection or "CONNECT" command.
ODBC value is from the ODBC Driver Manager.
DDO value _+8.2 is from the driver being used.
All others = $sqr-database / {sqr-database}.

$sqr-database _+3.0
{sqr-database} _+3.0 The database type for which SQR was compiled. Valid values are: ALLBASE _-4.0    DB2    INFORMIX    INGRES _-6.0    ODBC _+4.0    ORACLE    RDB _-4.0    REDBRICK _+4.3, -6.0    SQLBASE _-6.0    SYBASE

$sqr-dbcs _+4.2
{sqr-dbcs} _+4.2 Will be "YES" when referenced from double-byte enabled executables.

$sqr-encoding _+4.2
{sqr-encoding} _+4.2 Will hold the value of the ENCODING environment variable (see Encodings).

$sqr-encoding-console _+6.0
{sqr-encoding-console} _+6.0 Will hold the value of the log file or console ENCODING environment variable (see Encodings).

$sqr-encoding-database _+5.1
{sqr-encoding-database} _+5.1 Will hold the value of the database ENCODING environment variable (see Encodings).

$sqr-encoding-file-input _+5.1
{sqr-encoding-file-input} _+5.1 Will hold the value of the input file ENCODING environment variable (see Encodings).

$sqr-encoding-file-output _+5.1
{sqr-encoding-file-output} _+5.1 Will hold the value of the output file ENCODING environment variable (see Encodings).

$sqr-encoding-report-output _+5.1
{sqr-encoding-report-output} _+5.1 Will hold the value of the database ENCODING environment variable (see Encodings).

$sqr-encoding-source _+6.0
{sqr-encoding-source} _+6.0 Will hold the value of the source and include files ENCODING environment variable (see Encodings).

$sqr-hostname _+4.3.1
{sqr-hostname} _+4.3.1 The name of the machine that this SQR is running on.

$sqr-locale _+4.0 The name of the current locale. A "+" at the end means a value has changed.

#sqr-max-columns _+4.3.2 Maximum number of columns with the current layout. Is updated when a new report is selected.

#sqr-max-lines _+4.3.2 Maximum number of lines with the current layout. Is updated when a new report is selected.

#sqr-pid _+3.0 The process ID of the current SQR process. Unique for each run of SQR.

$sqr-platform _+3.0
{sqr-platform} _+3.0 The hardware/operating system type for which SQR was compiled. Valid values are: DOS _-4.0   MVS _-8.0   WINDOWS   WINDOWS-NT _+4.0  _-8.0   UNIX   VM _-6.0   VMS _-8.0

$sqr-program _+3.0 The name of the SQR program file.

$sqr-report _+3.0 The name of the report output file. Reflects the actual name to be used (-F flag or NEW-REPORT command).

#sqr-toc-level _+4.3.3 Level of current TOC entry.

#sqr-toc-page _+4.3.3 Page number of current TOC entry.

$sqr-toc-text _+4.3.3 Text of current TOC entry.

$sqr-ver _+3.0 The text string shown with the -ID flag.

$username The database username specified on the command line.



ENVIRONMENT VARIABLES & SQR.INI  _{+3.0.? for Windows   +4.0 for Unix}

NOTES:

SQR.INI was introduced just after 3.0 for Windows platforms and in 4.0 for Unix flavors.

This is intended to be a reference of lesser known options and is not intended to be a comprehensive listing.

The "Environment-XXX" section contains values that may also be set as environment variables.

[Color Map]

color_name  _+6.0 Define the (rgb) colors for this color_name (repeatable)

[Default-Settings]

AllowDateAsChar  _+4.3 When TRUE (default is FALSE) date columns will be retrieved as characters (like pre-4.0).

AutoDetectUnicodeFiles  _+6.1.3 When TRUE (default is FALSE) SQR will read the first 2 bytes of a file to determine the encoding for the file (unless encoding was specified within the "open" command).

Default-Numeric  _+4.0 Specifies Default Numeric Type for numeric variables. Can be V30, INTEGER, FLOAT, or DECIMAL. To specify a DECIMAL precision, use parentheses. i.e. DECIMAL(20). (see also: Command Line Flag -DNT).

FixODBCAccuracy  _+4.3.2.2 When TRUE (default is FALSE) SQR will correct "float" column anomalies occuring with Microsost ODBC drivers greater than 2.65.240.

Locale  _+4.0 SYSTEM (default) or locale name to use as initial locale when an SQR starts.

NewGraphics  _+6.0 When TRUE (default is FALSE) SQR will allow many advanced chart features

OracleWeakCursor  _+8.2 Stop, Warn, or Skip. If a 'Weak' reference cursor is processed, then...
Stop: Issues an error messsage and halts program execution.
Warn: Issues an error messsage, program continues (default).
Skip: No error messsage, program continues .

Output-File-Mode  _+4.0 SHORT (default) _-4.1 or LONG (default) _+4.1 file names for HTML output. Ignored on 16-bit platforms.

OutputFormFeedWithDashD  _+4.3.1 When TRUE (default is FALSE) the -Dn flag will also output a Form-Feed character.

OutputTwoDigitYearWarningMsg  _+4.3.1 When TRUE (default) SQR will send a warning message to the error file when a YY or RR date edit mask is encountered when running program. This only effects SQR code that is processed.

PDFCompressionText  _{+6.1.3, *8.2} Sets the level of PDF text compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6. (alternative: CompressionText_+8.2)

PDFCompressionGraphics  _{+6.1.3, *8.2} Sets the level of PDF graphics compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6. (alternative: CompressionGraphics_+8.2)

PrinterHT  _+8.0 ENHANCED (default) -printer:ht will act like -printer:eh. STANDARD will produce HTML 2.0 files from -printer:ht

Substitution-Character  _+6.1.3 Allows defining the substitution character for undefined characters within a character set. Format is
    XX  ENCODING_1 [, XX  ENCODING_2... [, XX  Default] ]
Where XX is the hexidecimal value of the substitution character. (see Encodings)

UseUnicodeInternal  _+6.1.3 When TRUE (default is FALSE) forces SQR to use Unicode internally. Allows any encoding combinations in a single SQR run (including ASCII and EBCDIC).

UseY2kCenturyAlgorithm _+4.3.1 When TRUE (FALSE is default) SQR will treat the "YY" date edit mask as though it were an "RR" date edit mask.

[Enhanced-HTML]

Browser _+4.3.3 ALL(default) _+4.3.4 generates HTML that will auto-sense the browser being used. IE or NETSCAPE generates an HTML file designed for the specific browsers.

DefaultTemplate _+8.2 Path to a customized defaultTemplate.xml template file used by SQR for HTML output.

FullHTML _+4.3.1 When True, then report generates HTML 3.2.

IncludePDFInZip _+8.1 When TRUE (default is FALSE) SQR will include the PDF file in the ZIP file created when both -PRINTER:EP and -EH_ZIP are specified.

Language _+4.3.1 English (default), French, German _+4.3.3 , Portuguese _+4.3.3 , or Spanish _+4.3.3 . Language for the navigation bar.

PrinterHT _+8.0 Enhanced (default) maps -printer:ht to -printer:eh and produces fully formatted output with version 1.1 XHTML tags. Standard causes -printer:ht to produce version 2.0 HTML files.

[Environment:Common]

[Environment:{DB2 | ODBC | Sybase | Oracle | Ingres _-6.0 | SQLBase _-6.0 | Informix | DDO _+6.0}]

ENCODING  _+4.2 Encoding used by default. Default setting is ASCII. (see Encodings)

ENCODING-CONSOLE  _+5.1 Encoding used for console input and output. Default setting is ASCII. (see Encodings)

ENCODING-DATABASE  _+5.1 Encoding used for interfacing with the database. Default setting is ASCII. (see Encodings)

ENCODING-FILE-INPUT  _+5.1 Default encoding used for �OPEN� for-reading files and argument files. Default setting is ASCII. (see Encodings)

ENCODING-FILE-OUTPUT  _+5.1 Default encoding used for �OPEN� for-writing files. Default setting is ASCII. (see Encodings)

ENCODING-REPORT-OUTPUT  _+5.1 Default encoding used for report output, such as, SPF, LIS, HTM, etc. Default setting is ASCII. (see Encodings)

ENCODING-SQR-SOURCE  _+6.0 Encoding used for SQR source and include files. Default setting is ASCII. (see Encodings)

SQR_DB_DATE_FORMAT _+4.0 Format for string comparison to date columns.

SQR_DB_DATE_ONLY_FORMAT _+4.2 Format for string comparison to date columns that only have a date component.

SQR_DB_TIME_ONLY_FORMAT _+4.2 Format for string comparison to date columns that only have a time component.

SQR_JRE_EXE  _+6.0 Path and name of the JRE executable.

SQR_JRE_FLAGS  _+6.0 Passes arbitrary flags to the "jre" when processing SPF files.

SQR_JRE_VER  _+6.0 Version of the JRE executable.

SQR_USEJVM  _+8.0 TRUE (default) embeds the JVM (Java Virtual Machine) directly into the sqr. FALSE will mimic old behaviour. Used for Enhanced HTML and NewGraphics

[Environment:DDO] _+6.0

SQR_DDO_JRE_CLASS Classpath for DDO drivers, support files.

SQR_DDO_JRE_CLASS{n} Optional; additional entries to the classpath.

SQR_DDO_JRE_INIT_HEAP  _+6.2 (default: 4M) Size of the initial heap. Value may be set as N (bytes), NK (Kilobytes) or NM (Megabytes).

SQR_DDO_JRE_MAX_HEAP  _+6.2 (default: 32M) Maximum size of the heap. Value may be set as n (bytes), nK (Kilobytes) or nM (Megabytes).

SQR_DDO_JRE_NOCLASSGC  _+6.2 When TRUE (default is FALSE) will prevent Class Garbage Collection.

SQR_DDO_JRE_NOJIT  _+6.2 When TRUE (default is FALSE) will disable the JIT compiler.

SQR_DDO_JRE_PATH Classpath information for the local JRE.

SQR_DDO_JRE_VERBOSE  _+6.2 When TRUE (default is FALSE) will run the JVM in Verbose mode. (Note: This creates a file in the current working directory called 'vm.out'.)

[Fonts]

CharacterSet _+4.3.3 (Windows Only) DEFAULT will emulate previous versions of SQR. AUTO will use the Windows default character set with -PRINTER:WP or when viewing SPF files. Alternately, you may set a specific character set with the following keywords:
ANSI ARABIC BALTIC CHINESEBIG5 EASTEUROPE GB2312 GREEK HANGUL HEBREW JOHAB MAC OEM RUSSIAN SHIFTJIS SYMBOL THAI TURKISH VIETNAMESE

[HTML-Images]

FIRST-PAGE _+4.1 Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,firstpg.gif).

PREV-PAGE _+4.1 Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,prevpg.gif).

NEXT-PAGE _+4.1 Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,nextpg.gif).

LAST-PAGE _+4.1 Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,lastpg.gif).

WALLPAPER _+4.1 The "Wallpaper" graphic name (default is none).

[Local:locale-name] _+4.0

NUMBER-EDIT-MASK Default edit mask when the keyword NUMBER is used with DISPLAY, MOVE, PRINT or SHOW.

MONEY-EDIT-MASK Default edit mask when the keyword MONEY is used with DISPLAY, MOVE, PRINT or SHOW.

DATE-EDIT-MASK Default edit mask when the keyword DATE is used with DISPLAY, MOVE, PRINT, SHOW, datetostr() or strtodate().

INPUT-DATE-EDIT-MASK Default edit mask when the keyword DATE is used with INPUT or the input variable is a DATE variable.

MONEY-SIGN Character(s) that replace the '$' edit character.

MONEY-SIGN-LOCATION The MONEY-SIGN character(s) location. Values are LEFT or RIGHT.

THOUSAND-SEPARATOR Character that replaces the ',' edit character.

DECIMAL-SEPARATOR Character that replaces the '.' edit character.

DATE-SEPARATOR Character that replaces the '/' edit character.

TIME-SEPARATOR Character that replaces the ':' edit character.

EDIT-OPTION-NA Character(s) that replace the 'NA' edit character.

EDIT-OPTION-AM Character(s) that replace the 'AM' edit character.

EDIT-OPTION-PM Character(s) that replace the 'PM' edit character.

EDIT-OPTION-AD Character(s) that replace the 'AD' edit character.

EDIT-OPTION-BC Character(s) that replace the 'BC' edit character.

DAY-OF-WEEK-CASE Affects DAY-OF-WEEK-FULL entries (format code 'DAY') and DAY-OF-WEEK-SHORT entries (format code 'DY').
UPPER forces the output to all uppercase.
LOWER forces the output to all uppercase.
EDIT follows format code case.
NO-CHANGE uses exact case as listed in the appropriate entries.

DAY-OF-WEEK-FULL Seven single-quoted entries, comma seperated, all within single parenthesis. Represents the full names for the days of the week starting with Sunday.

DAY-OF-WEEK-SHORT Seven single-quoted entries, comma seperated, all within single parenthesis. Represents the abbreviated names for the days of the week starting with Sunday.

MONTHS-CASE Affects MONTHS-FULL entries (format code 'MONTH') and MONTHS-SHORT entries (format code 'MON').
UPPER forces the output to all uppercase.
LOWER forces the output to all uppercase.
EDIT follows format code case.
NO-CHANGE uses exact case as listed in the appropriate entries.

MONTHS-FULL Twelve single-quoted entries, comma seperated, all within single parenthesis. Represents the full names for the months of the year starting with January.

MONTHS-SHORT Twelve single-quoted entries, comma seperated, all within single parenthesis. Represents the abbreviated names for the months of the year starting with January.

[MAP-DDO-DB] _+8.2

unknown_DDO_driver_name Maps the unknown DDO driver name ($sqr-connected-db-name) to a valid $sqr-connected-db class.

[MAP-ODBC-DB] _+8.0

unknown_ODBC_driver_name Maps the unknown ODBC driver name ($sqr-connected-db-name) to a valid $sqr-connected-db setting.

[PDF Fonts] _+4.3.2.2

font_number Maps an SQR font number to an ADOBE font for PDF output. The assignment form is...
Typeface [ , CJK_Typeface , Charcter_Map] _+6.1.4 (see Non-Roman PDF Fonts for possible values)

Embed _+8.2 If this setting is not specified, no fonts are embedded into the PDF file (default).
If "All" is specified, then all fonts are embedded into the PDF file.
If a space seperated listing of font numbers is specified, then those fonts are embedded into the PDF file.

[PDF Settings] _+8.2

Bookmarks True creates a PDF bookmark for each TOC entry. Default is False.

Compatibility 4, 5, or 6. Minimum Acrobat version required to read the PDF. Default is 5.

CompressionText Sets the level of PDF text compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6.

CompressionGraphics Sets the level of PDF graphics compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6.

EmbedAction Stop, Warn, or Skip. If an error occurs when embedding a font then...
Stop: Issues an error messsage and halts program execution (default).
Warn: Issues an error messsage, font is used without embedding.
Skip: No error messsage, font is used without embedding.

EncodingNotInFontAction Stop, Warn, or Skip. If a font does not support an encoding then...
Stop: Issues an error messsage and halts program execution (default).
Warn: Issues an error messsage, CP1252 is used.
Skip: No error messsage, CP1252 is used.

Subsetting True (default) enables subsetting for all fonts where subsetting is possible.

SubsetLimit Percentage (1-100) of glyphs from a font used in a document at which subsetting is disabled for that font and the complete font is embedded. Default is 100.

SubsetMinSize Size (in KB) of a font file at which subsetting is enabled. Smaller files will have the complete font embedded. Default is 100.

UnsupportedEncodingAction Stop, Warn, or Skip. If a font does not support an encoding then...
Stop: Issues an error messsage and halts program execution (default).
Warn: Issues an error messsage, CP1252 is used.
Skip: No error messsage, CP1252 is used.

[Processing-Limits] _-8.0

(see -M file entries)

[SQR Remote] _+6.0

HostName _+8.0 Default host name.

Passive For Report Activator - a value of 1 causes the FTP passive method of username/password verification to be used.

TimeOut _+8.0 Timeout duration in seconds (default = 30).

UserName _+8.0 Default username used to log into the host (see HostName above).

POSITION SYNTAX

(a,b,c) where

a = line position
b = column position
c = length
Line position and column position values may be fixed, or relative.
Examples:
       print &name (10,15,30)
Will be printed on line 10, column 15.
       print &address (+1,15,30)
Will be printed directly below the name.
       print &city (,50)
Will be printed on the same line as address at column 50.

RGB SYNTAX

r,g,b where

r = amount of Red in color on a scale of 0-255
g = amount of Green in color on a scale of 0-255
b = amount of Blue in color on a scale of 0-255

Examples:
       declare-color-map
          red=(255,0,0)
          green=(0,255,0)
          blue=(0,0,255)
          white=(255,255,255)
          grey=(128,128,128)
          black=(0,0,0)
       end-declare

       SET-COLOR
             PRINT-TEXT-FOREGROUND = (128,#green_level,&blue_level)
             PRINT-TEXT-BACKGROUND = ('black')
ARRAY DOT SYNTAX

Array elements may be referenced and altered within an expression (LET, IF, or WHILE commands) by using the special "dot" syntax in the form:
array.field(element[,occurs])
Examples:
       if states.name(1) = 'Alabama'
          let states.abbrev(1) = 'AL'
          let $State_Bird    = states.things(2,1)
          let $State_Flower  = states.things(2,2)
          let chosen.bird(#curr) = states.things(2,1)
       end-if
COMMAND REFERENCE

KEY:
Date _+4.0 Text Numeric List _+5.1
$d Variable $t Variable #n Variable %l Variable
&d Column &t Column &n Column
£d Literal £t Literal £n Literal
~d Variable or Literal ~t Variable or Literal ~n Variable or Literal
d Var, Lit, or Col t Var, Lit, or Col n Var, Lit, or Col

v Any Variable value Any Variable, Literal, or Column

NOTES:
In some cases, the only significant portion of a numeric is its truncated integer value. An "i" is used to designate these cases, but this does not mean that an integer data type is required.
Similarly, some values are returned as floating point and designated with an f, but they are not restricted to being stored into that data type.
"Round" parameter ranges depend on the data type. Float types rounded can be from 1 to 15, Decimal types can be from 1 to its precision.

ADD n TO #n [ROUND= £i]

ALTER-COLOR-MAP _+6.0

{NAME= t_color_name}
{VALUE= (t_color_name | rgb)}

ALTER-CONNECTION _+5.1 (DDO)

{NAME= £t_connection_name}
[DSN= ~t_data_source_name]
[USER= ~t_username]
[PASSWORD= ~t_password]
[PARAMETERS= £t_keyword1=£t_value1;[£t_keyword2=£t_value2;[...]]]
[NO-DUPLICATE= {TRUE | FALSE}] _+5.2
[SET-GENERATIONS= (£t_dimension1,£n_hierarchy1[,£t_dimension2,£n_hierarchy2[, ...]])] _+6.0
[SET-LEVELS= (£t_dimension1,£n_level1[,£t_dimension2,£n_level2[, ...]])] _+6.0
[SET-MEMBERS= (£t_dimension1,£t_level1[,£t_dimension2,£t_level2[, ...]])] _+6.0

ALTER-LOCALE _+4.0

[LOCALE= {SYSTEM | DEFAULT | ~t_locale_name}]
[NUMBER-EDIT-MASK= {SYSTEM | DEFAULT | ~t_edit_mask}]
[MONEY-EDIT-MASK= {SYSTEM | DEFAULT | ~t_edit_mask}]
[DATE-EDIT-MASK= {SYSTEM | DEFAULT | ~t_edit_mask}]
[INPUT-DATE-EDIT-MASK= {SYSTEM | DEFAULT | ~t_edit_mask}]
[MONEY-SIGN= {SYSTEM | DEFAULT | ~t_money_sign}]
[MONEY-SIGN-LOCATION=
{SYSTEM | DEFAULT | LEFT | RIGHT | $t_location}]
[THOUSAND-SEPARATOR= {SYSTEM | DEFAULT | ~t_separator}]
[DECIMAL-SEPARATOR= {SYSTEM | DEFAULT | ~t_separator}]
[DATE-SEPARATOR= {SYSTEM | DEFAULT | ~t_separator}]
[TIME-SEPARATOR= {SYSTEM | DEFAULT | ~t_separator}]
[EDIT-OPTION-NA= {SYSTEM | DEFAULT | ~t_na_chars}]
[EDIT-OPTION-AM= {SYSTEM | DEFAULT | ~t_am_chars}]
[EDIT-OPTION-PM= {SYSTEM | DEFAULT | ~t_pm_chars}]
[EDIT-OPTION-BC= {SYSTEM | DEFAULT | ~t_bc_chars}]
[EDIT-OPTION-AD= {SYSTEM | DEFAULT | ~t_ad_chars}]
[DAY-OF-WEEK-CASE=
{SYSTEM | DEFAULT | EDIT | UPPER | LOWER | NO-CHANGE | $t}]
[DAY-OF-WEEK-FULL=(~t_day1, ... ~t_day7)]
[DAY-OF-WEEK-SHORT=(~t_day1, ... ~t_day7)]
[MONTHS-CASE=
{SYSTEM | DEFAULT | EDIT | UPPER | LOWER | NO-CHANGE | $t}]
[MONTHS-FULL=(~t_month1, ... ~t_month12)]
[MONTHS-SHORT=(~t_month1, ... ~t_month12)]

ALTER-PRINTER _+3.0

[POINT-SIZE= n_points]
[FONT-TYPE= {PROPORTIONAL | FIXED | t_font-type_txt}]
[SYMBOL-SET= t_HP_defined_symbol_set]
[FONT= i_font]
[PITCH= n_pitch]

ALTER-REPORT _+6.0

[HEADING= t_heading_name]
[HEADING-SIZE= n_new_size]
[FOOTING= t_footing_name]
[FOOTING-SIZE= n_new_size]
[PDF-APPEARANCE={None | Bookmarks | Thumbnails | Fullscreen | $t | &t}] _+8.2
[PDF-INFORMATION={(Subject | Title | Creator | Author | Keywords | $t | &t , ~t [, ...] )}] _+8.2
[PDF-OPEN-ACTION=
{(Fixed | $t | &t [ , Zoom | Left | Top | $t | &t , ~n [ , ... , ...]] ) }
| {(Window | Visible | $t | &t) }
| {(Width | VisibleWidth | $t | &t [ , Top , ~n ] ) }
| {(Height | VisibleHeight | $t | &t [ , Left , ~n ] ) }
| {(Rectangle | $t | &t [ , Left | Right | Bottom | Top | $t | &t , ~n [ , ... , ...]] ) } ] _+8.2
[PDF-PAGE-TRANSITION=
{(Blinds | Box | Dissolve | Glitter | Replace | Split | Wipe | $t | &t , ~n_duration_in_secs) } ] _+8.2
[PDF-SECURITY=
{(User-Password | Master-Password | $t | &t , ~t [ , ...]
[ ,{Permissions | $t | &t , [ [NoPrint] [NoModify] [NoCopy] [NoAnnots] [NoForms] [NoAccessible] [NoAssemble] [NoHiResPrint] | $t | &t ] }]
)} ] _+8.2
[PDF-VIEWER-PREFERENCE=
{(Toolbar | MenuBar | WindowUI | FitWindow | CenterWindow | DisplayDocTitle | $t | &t , True | False | $t | &t [ , ...]
[ ,{NonFullscreen-Page-Mode | $t | &t , UseOutlines | UseThumbs | UseNone | $t | &t }]
[ ,{Direction | $t | &t , L2R | R2L | $t | &t }]
)} ] _+8.2

ARRAY-ADD n... TO array_name(i_element) [field[(i_occurs)]...]

ARRAY-DIVIDE n... INTO array_name(i_element) [field[(i_occurs)]...]

ARRAY-MULTIPLY n... TIMES array_name(i_element) [field[(i_occurs)]...]

ARRAY-SUBTRACT n... FROM array_name(i_element) [field[(i_occurs)]...]

ASK substitution_variable [£t_prompt]

BEGIN-DOCUMENT position

BEGIN-EXECUTE _+5.1 (DDO)

[CONNECTION= £t_connection_name]
[PROPERTIES= (~t_keyword1=value_1, [~t_keyword2=value_2, [...] ] )]
[ON-ERROR=procedure [(arg1,arg2,...argN)]]
[RSV= #n_row_set_variable]
[STATUS= {%l_stat | #n_stat | $t_stat}]
[SCHEMA= ~t_schema]
[PROCEDURE= ~t_proc
[PARAMETERS= ( {%l_arg | n_arg | t_arg} [IN|INOUT|NULL] [, ...] )]
    | COMMAND= ~t_command
    | GETDATA= ~t_ddo_getdata]
[BEGIN-SELECT
[BEFORE=sqr_procedure [(arg1,arg2,...argN)]]
[AFTER=sqr_procedure [(arg1,arg2,...argN)]]
col-name type={char|text|number|date} [edit-mask] [on-break] ...
{FROM ROWSETS= (x, x-y, x-, -y | ALL) | FROM PARAMETER = ~t | [FROM table_name] _+8.0}
END-SELECT]
END-EXECUTE

BEGIN-FOOTING £i_footing_lines

[NAME=footing_name] _+6.0
[FOR-REPORTS=(report_name1,...report_nameN)] _+3.0
[FOR-TOCS=(toc_name1,...toc_nameN)] _+4.1

BEGIN-HEADING £i_heading_lines

[NAME=heading_name] _+6.0
[FOR-REPORTS=(report_name1,...report_nameN)] _+3.0
[FOR-TOCS=(toc_name1,...toc_nameN)] _+4.1

BEGIN-PROCEDURE procedure_name [LOCAL | (arg1,arg2,...argN)]

BEGIN-PROGRAM _+3.0

BEGIN-REPORT _* (alternative: Begin-Program)

BEGIN-SELECT

[DISTINCT]
[-C£n_buffer_size]   (Ingres _-6.0,Oracle,SQLBase _-6.0)
[-C£n_connection] _+3.0, -4.0   (SYBASE DB-Lib)
[-B£n]   (Oracle,SYBASE CT-Lib) (ODBC) _+4.3.2
[-XP] _+3.0   (SYBASE)
[-NR] _+3.0, -6.0   (SQLBase)
[-SORT£n] _+3.0, -6.0   (SQLBase)
[-LOCK{RR | CS | RO | RL | XX}] _+3.0, -6.0   (SQLBase)
[-DBdatabase_name] _+3.0, -6.0   (SQLBase)
[-DBconnection_string] _+4.0   (ODBC)
[LOOPS= £n]
[ON-ERROR=procedure [(arg1,arg2,...argN)] _+3.0 ]

BEGIN-SETUP
(The following are used exclusively in the SETUP section, ASK, DECLARE-CHART, DECLARE-COLOR-MAP, DECLARE-CONNECTION, DECLARE-IMAGE, DECLARE-LAYOUT, DECLARE-PRINTER, DECLARE-PROCEDURE, DECLARE-REPORT, DECLARE-TOC NO-FORMFEED, PAGE-SIZE, PRINTER-DEINIT, PRINTER-INIT, USE)

BEGIN-SQL

[-C£n_buffer_size]   (Ingres _-6.0,Oracle,SQLBase _-6.0)
[-C£n_connection] _+3.0, -4.0   (SYBASE DB-Lib)
[-XP] _+3.0   (SYBASE)
[-NR] _+3.0, -6.0   (SQLBase)
[-SORT£n] _+3.0, -6.0   (SQLBase)
[-LOCK{RR | CS | RO | RL | XX}] _+3.0, -6.0   (SQLBase)
[-DBdatabase_name] _+3.0, -6.0   (SQLBase)
[-DBconnection_string] _+4.0   (ODBC)
(in setup)  [ ON-ERROR=[STOP | WARN | SKIP] ]
(non-setup)  [ ON-ERROR=procedure [(arg1,arg2,...argN)] _+3.0 ]
[CONNECTION=connection_string] _+5.1   (DDO)

BREAK

CALL subroutine USING value {$t | #n} [param]

CALL SYSTEM USING t_command #n_status [NOWAIT | WAIT] _{+3.0.13 Windows NT +4.0 VMS}

CLEAR-ARRAY _+3.0 NAME=array_name

CLOSE {~i_file_num _-4.0 | i_file_num _+4.0}

COLUMNS _+3.0 i...

COMMIT
(used with ORACLE, SQLBase _-6.0 , ODBC _+4.0 , DB2 _+4.0 , Informix _+4.0 , RDB _-4.0 , Ingres _-6.0 , DDO _+8.0 , Teradata _+8.0 )

CONCAT value WITH $t [{:$t_edit_mask | £t_edit_mask}]

CONNECT t [ON-ERROR=procedure [(arg1,arg2,...argN)] _+3.0 ]

CREATE-ARRAY NAME=array_name SIZE= £i_elements EXTENT _+8.0= £i_extension

{FIELD=
name:{CHAR | NUMBER | TEXT _+4.0 | DATE _+4.0 | INTEGER _+4.0 | FLOAT _+4.0 | DECIMAL[£i_precision] _+4.0}[:i_occurs][={£t|£n}] _+3.0}
[FIELD...]

CREATE-COLOR-PALETTE _+6.0 NAME=palette_name

{COLOR_1=(rgb | t_color_name)}
{COLOR_2=(rgb | t_color_name)}
[COLOR_3=(rgb | t_color_name)]
...
[COLOR_n=(rgb | t_color_name)]

CREATE-LIST _+8.2

{NAME= t_list_name}
{LIST= (value | ({rgb | t_color_name) [ , ...])}

DATE-TIME _* position [date_format [&t]] (alternative: DateNow())

DECLARE-CHART _+3.0 chart_name

[DATA-LABELS= {NO | YES}] _+6.0 (requires NewGraphics)
[COLOR-PALETTE= £t_palette_name] _+6.0 (requires NewGraphics)
[ITEM-COLOR=
( {ChartBackground | ChartForeground | HeaderBackground | HeaderForeground | FooterBackground | FooterForeground | LegendBackground | LegendForeground | ChartAreaBackground | ChartAreaForeground | PlotAreaBackground}
, {(£rgb | £t_color_name)} ) ] _+6.0 (requires NewGraphics)
[ITEM-SIZE=
( {Title | SubTitle | XAxisLabel | XAxisMarkers | YAxisLabel | YAxisMarkers | Y2AxisLabel | Y2AxisMarkers | LegendText | LegendTitle}
, £n_point_size _-8.0 | £n_html_font_size_1_to_7 _+8.0 ) ] _+6.1.3 (requires NewGraphics)
[CHART-SIZE= (£i_width, £i_depth) ]
[TITLE= {NONE | £t}]
[SUB-TITLE= {NONE | £t}]
[FOOTER-TEXT= {NONE | £t}] _+8.2 (requires NewGraphics)
[SUB-FOOTER-TEXT= {NONE | £t}] _+8.2 (requires NewGraphics)
[FILL= {GRAYSCALE | COLOR | CROSSHATCH | NONE}]
[3D-EFFECTS= {NO | YES}]
[BORDER= {YES | NO}]
[POINT-MARKERS= {YES | NO}]
[TYPE=
{BAR | LINE | PIE | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE _+6.1.4}]
[Y2-TYPE=
{BAR | LINE | PIE | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE _+6.1.4} ] _+6.1.3
[LEGEND= {YES | NO}]
[LEGEND-TITLE= {NONE | £t}]
[LEGEND-PLACEMENT=
{CENTER-RIGHT | CENTER-LEFT | UPPER-RIGHT | UPPER-LEFT | UPPER-CENTER | LOWER-RIGHT | LOWER-LEFT | LOWER-CENTER}]
[LEGEND-PRESENTATION= {OUTSIDE | INSIDE}]
[PIE-SEGMENT-QUANTITY-DISPLAY= {YES | NO}]
[PIE-SEGMENT-PERCENT-DISPLAY= {YES | NO}]
[PIE-SEGMENT-EXPLODE=
{NONE | MAX | MIN | USE-3RD-DATA-COLUMN}]
[X-AXIS-ROTATE= {£n_0_no_1_yes_N_only_if_more_than_N}] _+6.1.3 (requires NewGraphics)
[{X | Y | Y2 _+6.1.3}-AXIS-LABEL= {NONE | £t}]
[{X | Y | Y2 _+6.1.3}-AXIS-MIN-VALUE= {AUTOSCALE | £n}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAX-VALUE= {AUTOSCALE | £n}]
[{X | Y | Y2 _+6.1.3}-AXIS-SCALE= {LINEAR | LOG}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAJOR-TICK-MARKS= {YES | NO}]
[{X | Y | Y2 _+6.1.3}-AXIS-MINOR-TICK-MARKS= {NO | YES}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAJOR-INCREMENT= {AUTOSCALE | £n}]
[{X | Y | Y2 _+6.1.3}-AXIS-MINOR-INCREMENT= £n]
[{X | Y}-AXIS-TICK-MARK-PLACEMENT=
{OUTSIDE | INSIDE | BOTH}]
[{X | Y}-AXIS-GRID= {YES | NO}]
[{Y | Y2}-AXIS-MASK= {t_number_edit_mask}] _+6.1.4 (requires NewGraphics)
[ATTRIBUTES=

{ {£t_selector[.£t_sub_selector] | LIST:(£t_selector[.£t_sub_selector] [, ...]) | LIST:t_list_name} ,
{£t_declaration_key ,
{£t_value | £n_value | (rgb | £t_color_name) | LIST:({£t_value | (rgb | £t_color_name)} [, ...]) | LIST:£t_list_name | PALETTE:£t_color_palette}
[, ... , ...]}
} ] _+8.2 (requires NewGraphics) (see also: Chart Attributes)

END-DECLARE

DECLARE-COLOR_MAP _+6.0

[color_name=(rgb)]
...
END-DECLARE

DECLARE-CONNECTION _+5.1 connection_name (DDO)

{DSN= £t_data_source_name}
[USER= £t_username]
[PASSWORD= £t_password]
[PARAMETERS= £t_keyword1=£t_value1;[£t_keyword2=£t_value2;[...]]]
[NO-DUPLICATE= {TRUE | FALSE}] _+5.2
[SET-GENERATIONS= (£t_dimension1,£n_hierarchy1[,£t_dimension2,£n_hierarchy2[, ...]])] _+6.0
[SET-LEVELS= (£t_dimension1,£n_level1[,£t_dimension2,£n_level2[, ...]])] _+6.0
[SET-MEMBERS= (£t_dimension1,£t_level1[,£t_dimension2,£t_level2[, ...]])] _+6.0
END-DECLARE

DECLARE-IMAGE _+3.0 image_name

[TYPE= {EPS-FILE | HPGL-FILE | BMP-FILE | GIF-FILE _+4.0 | JPEG-FILE _+4.0 | PNG-FILE _+8.2}]
[IMAGE-SIZE= (£i_width, £i_height)]
[SOURCE= £t_file_name]
[FOR-PRINTER=
({POSTSCRIPT | HPLASERJET | HTML | PDF | WINDOWS | PS | HP | HT | PD | WP}
, {EPS-FILE | HPGL-FILE | BMP-FILE | GIF-FILE | JPEG-FILE | PNG-FILE _+8.2}
, £t_file_name)] _+8.0
END-DECLARE

DECLARE-LAYOUT _+3.0 layout_name

[PAPER-SIZE= { (£n_width_in [uom] _+4.0 , £n_height_in [uom] _+4.0) | [paper_size_name]}]
[FORMFEED= {YES | NO}]
[ORIENTATION= {PORTRAIT | LANDSCAPE}]
[LEFT-MARGIN= £n_in [uom] _+4.0]
[TOP-MARGIN= £n_in [uom] _+4.0]
[{RIGHT-MARGIN= £n_in [uom] _+4.0 |
LINE-WIDTH= £n_in [uom] _+4.0 |
MAX-COLUMNS= £n_columns_integer}]
[{BOTTOM-MARGIN= £n_in [uom] _+4.0 |
PAGE-DEPTH= £n_in [uom] _+4.0 |
MAX-LINES= £n_lines_integer}]
[CHAR-WIDTH= £n_pt [uom] _+4.0]
[LINE-HEIGHT= £n_pt [uom] _+4.0]
END-DECLARE

DECLARE PRINTER _+2.20, * (alternative: Declare-Printer & Declare-Layout)

[TYPE= {LINEPRINTER | POSTSCRIPT | HPLASERJET}]
[ORIENTATION= {PORTRAIT | LANDSCAPE}]
[LEFT-MARGIN= £n_inches]
[TOP-MARGIN= £n_inches]
[LINE-SIZE= £n_points]
[CHAR-SIZE= £n_points]
[LINES-INCH= £i_lines]
[CHARS-INCH= £n_characters]
[POINT-SIZE= £n_points]
[FONT= £i_font_number]
[FONT-STYLE= {PROPORTIONAL | FIXED} _-3.0]
[FONT-TYPE= {PROPORTIONAL | FIXED} _+3.0]
[SYMBOL-SET= £t_from_HP_defined_sets]
[STARTUP-FILE= £t_file_name]
[BEFORE-BOLD= £t_any_string]
[AFTER-BOLD= £t_any_string]

DECLARE-PRINTER _+3.0 printer_name

[FOR-REPORTS= (report_name1,...report_nameN)]
[TYPE=
{LINEPRINTER | POSTSCRIPT | HPLASERJET | HTML _+4.0 | PDF _+6.1.3 | LP | PS | HP | HT _+4.0| PD _+6.1.3}]
[INIT-STRING= £t_any_string]
[RESET-STRING= £t_any_string]
[COLOR= {NO | YES}]
[POINT-SIZE= £n_points]
[FONT-TYPE= {PROPORTIONAL | FIXED}]
[SYMBOL-SET= £t_from_HP_defined_sets]
[STARTUP-FILE= £t_file_name]
[PITCH= £n_chars_per_inch]
[FONT= £i_font_number]
[BEFORE-BOLD= £t_any_string]
[AFTER-BOLD= £t_any_string]
END-DECLARE

DECLARE PROCEDURE _+2.20, * (alternative: Declare-Procedure)

[BEFORE-REPORT= procedure_name]
[AFTER-REPORT= procedure_name]
[BEFORE-PAGE= procedure_name]
[AFTER-PAGE= procedure_name]

DECLARE-PROCEDURE _+3.0

[FOR-REPORTS= (report_name1,...report_nameN)]
[BEFORE-REPORT= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[AFTER-REPORT= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[BEFORE-PAGE= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[AFTER-PAGE= procedure_name[(value_arg1,value_arg2,...value_argN)]]
END-DECLARE

DECLARE-REPORT _+3.0 report_name

[TOC= toc_name] _+4.1
[LAYOUT= layout_name]
[PRINTER-TYPE=
{LINEPRINTER | POSTSCRIPT | HPLASERJET | HTML _+4.0 | LP | PS | HP | HT _+4.0}]
END-DECLARE

DECLARE-TOC _+4.1

[FOR-REPORTS= (report_name1,...report_nameN)]
[DOT-LEADER= {NO | YES}]
[INDENTATION= £n_indent_spaces]
[ENTRY= procedure_name[(value_arg1,value_arg2,...value_argN)]] _+4.3.3
[BEFORE-TOC= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[AFTER-TOC= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[BEFORE-PAGE= procedure_name[(value_arg1,value_arg2,...value_argN)]]
[AFTER-PAGE= procedure_name[(value_arg1,value_arg2,...value_argN)]]
END-DECLARE

DECLARE-VARIABLE _+4.0

[DEFAULT-NUMERIC= {DECIMAL[(£i_prec)] | FLOAT | INTEGER}]
[DECIMAL[(£i_prec)] decimal_var[(£i_prec)] [decimal_var[(£i_prec)]]...]
[FLOAT float_var [float_var]...]
[DATE date_var [date_var]...]
[INTEGER integer_var [integer_var]...]
[TEXT text_var [text_var]...]
END-DECLARE

DISPLAY
value [{:$t_edit_mask | £t_edit_mask | NUMBER _+4.0 | MONEY _+4.0 | DATE _+4.0}] [NOLINE]

DIVIDE n INTO #n [ON-ERROR={HIGH | ZERO}] [ROUND= £i]

DO procedure_name [(value_arg1, value_arg2,...value_argN)]

DOLLAR-SYMBOL _+3.0, * new_single_char_dollar_symbol (alternative: Alter-Locale)

ELSE

ENCODE £t_code_string INTO $t

END-DECLARE _+3.0

END-DOCUMENT

END-EVALUATE

END-EXECUTE _+5.1

END-FOOTING

END-HEADING

END-IF

END-PROCEDURE

END-PROGRAM _+3.0

END-REPORT _*

END-SELECT

END-SETUP

END-SQL

END-WHILE

EVALUATE value

WHEN {= | != | <> | < | > | <= | >=} value
[sqr code...]
[BREAK]
[WHEN {= | != | <> | < | > | <= | >=} value] ...
[WHEN-OTHER]
END-EVALUATE

EXECUTE _+3.0
INGRES SYNTAX: _-6.0

[ON-ERROR=procedure_name]
[#n_status=]stored_procedure_name
[(parameter_name=value [;...]) ]

SYBASE , MICROSOFT SQL SERVER _-8.0 , DB2 _+8.0 , ODBC _+8.0 and ORACLE _+8.0 SYNTAX:

[-XC] _+4.3   (SYBASE)
[-C£n_connection] _-4.0
[ON-ERROR=procedure_name] [(arg1,arg2,...argN)]
[DO=procedure_name[(value_arg1,value_arg2,...value_argN)]]
[@#n_status=]stored_procedure_name
[@$t_return=]stored_procedure_name _+8.0   (ORACLE)
[[@parameter_name=]value [OUT[PUT]] [,...]
[INTO any_column data_type [(£n_length)] [,...]
[WITH RECOMPILE]   (SYBASE and ODBC)

EXIT-SELECT

EXTRACT {$t | $d} FROM {t | d} ~i_start_location ~i_length

FIND {t | d} IN {t | d} ~i_start_loc #n_found_at_offset

GET v... FROM array_name(i_element) [field[(i_occurs)]...]

GET-COLOR _+6.0
[PRINT-TEXT-FOREGROUND = ($t)]
[PRINT-TEXT-BACKGROUND = ($t)]
[PRINT-PAGE-BACKGROUND = ($t)] _+8.0

GOTO label

GRAPHIC () FONT _+2.20, * ~i_font [~i_point_size [1 | 0 [~i_pitch]]] (alternative: Declare-Printer & Alter-Printer)

GRAPHIC position BOX _+2.20 ~i_depth [~i_rulewidth [~i_shading_percent]]

GRAPHIC position HORZ-LINE _+2.20 [~i_rulewidth]

GRAPHIC position VERT-LINE _+2.20 [~i_rulewidth]

IF logical_expression

INPUT
{$t _-4.0 | v _+4.0} [MAXLEN= £n] [£t_prompt] [TYPE={CHAR | TEXT _+4.0 | NUMBER | INTEGER | DATE}] [STATUS= #n_status] [NOPROMPT] [BATCH-MODE] _+4.0 [FORMAT={t_date_edit_mask | DATE}] _+4.0

LAST-PAGE _+3.0 position [£t_pre_text [£t_post_text] ]

LET v = expression

LOAD-LOOKUP
In the SETUP section

{NAME= lookup_table_name}
{TABLE= database_table}
{KEY= key_column_database_expression}
{RETURN_VALUE= return_column_database_expression}
{ROWS= £i_maximum_rows} _-3.0
[ROWS= £i_initial_rows] _+3.0
[EXTENT= £i_size_to_grow_by] _+3.0
[WHERE= £t_where_clause]
[SORT= {DC | DI | SC | SI}] _+3.0
[SCHEMA= £t_schema] _+5.1
[PROCEDURE= £t_proc

[PARAMETERS= ( {%l_arg | £n_arg | £t_arg} [IN|INOUT|NULL] [, ...] )]

    | COMMAND= £t_command
    | GETDATA= £t_ddo_getdata] _+5.1
{FROM ROWSETS= (x, x-y, x-, -y | ALL) | FROM PARAMETER = £t } _+5.1
[QUIET]

In the body of the report _+3.0

{NAME= lookup_table_name}
{TABLE= database_table}
{KEY= key_column_database_expression}
{RETURN_VALUE= return_column_database_expression}
[ROWS= i_initial_rows]
[EXTENT= i_size_to_grow_by]
[WHERE= t_where_clause]
[SORT= {DC | DI | SC | SI}]
[SCHEMA= ~t_schema] _+5.1
[PROCEDURE= ~t_proc

[PARAMETERS= ( {%l_arg | n_arg | t_arg} [IN|INOUT|NULL] [, ...] )]

    | COMMAND= ~t_command
    | GETDATA= ~t_ddo_getdata] _+5.1
{FROM ROWSETS= (x, x-y, x-, -y | ALL) | FROM PARAMETER = ~t } _+5.1
[QUIET]

LOOKUP lookup_table_name value {$t_return_val | $d_return_val}

LOWERCASE $t

MBTOSBS _+4.2 $t_multi_byte_string_to_convert_to_single_byte (Double-Byte version only)

MONEY-SYMBOL _+3.0, * new_single_char_money_symbol (alternative: Alter-Locale)

MOVE value TO v [{:$t_edit_mask | £t_edit_mask | NUMBER _+4.0 | MONEY _+4.0 | DATE _+4.0}]

MULTIPLY n TIMES #n [ROUND= £i]

NEW-PAGE [i_erase_from_line]

NEW-REPORT t_report_file_name

NEXT-COLUMN [AT-END={NEWLINE | NEWPAGE}]
[GOTO-TOP= i] [ERASE-PAGE= i]

NEXT-LISTING [NO-ADVANCE] _+2.13 [SKIPLINES= i] [NEED= i]

NO-FORMFEED _* (alternative: Declare-Layout)

OPEN
{~t_file_name _-4.0 | t_file_name _+4.0} AS {~i_file_num _-4.0 | i_file_num _+4.0} {FOR-READING | FOR-WRITING | FOR-APPEND _+3.0} RECORD= £i_length[:{FIXED | FIXED_NOLF _+3.0 | VARY}] [STATUS= #n] [ENCODING= {$t_encoding | &t_encoding | Unquoted_Encoding}] _+6.1.3 (requires UseUnicodeInternal=True)

PAGE-NUMBER position [£t_pre_text [£t_post_text] ]

PAGE-SIZE _* £i_page_depth £i_page_width (alternative: Declare-Layout)

POSITION position [@document_marker [COLUMNS i ...]]

PRINT value position [format_commands]

PRINT-BAR-CODE _+3.0 position

{TYPE= {i_bar_code_type_num}}
{HEIGHT= n_height}
{TEXT= t_bar_code_text}
[CAPTION= t_caption]
[CHECKSUM= {NO | YES}]

PRINT-CHART _+3.0 [chart-name] position

{DATA-ARRAY= {array_name}}
{DATA-ARRAY-ROW-COUNT= i_row_count}
{DATA-ARRAY-COLUMN-COUNT= i_col_count}
[TYPE=
{BAR | LINE | PIE | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE _+6.1.4 | $t | &t}]
[DATA-ARRAY-COLUMN-LABELS= {NONE | array_name | (~t_label1,~t_label2,...)}]
[COLOR-PALETTE= t_palette_name] _+6.0 (requires NewGraphics)
[Y2-TYPE=
{BAR | LINE | PIE | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE _+6.1.4 | $t | &t} ] _+6.1.3
  {Y2-DATA-ARRAY= {array_name}} _+6.1.3
  {Y2-DATA-ARRAY-ROW-COUNT= i_row_count} _+6.1.3
  {Y2-DATA-ARRAY-COLUMN-COUNT= i_col_count} _+6.1.3 ]
[Y2-DATA-ARRAY-COLUMN-LABELS= {NONE | array_name | (~t_label1,~t_label2,...)}] _+6.1.3
[Y2-COLOR-PALETTE= t_palette_name] _+6.1.3 (requires NewGraphics)
[DATA-LABELS= {NO | YES | $t | &t}] _+6.0 (requires NewGraphics)
[ITEM-COLOR=
( {ChartBackground | ChartForeground | HeaderBackground | HeaderForeground | FooterBackground | FooterForeground | LegendBackground | LegendForeground | ChartAreaBackground | ChartAreaForeground | PlotAreaBackground}
, {(rgb | t_color_name)} ) ] _+6.0 (requires NewGraphics)
[ITEM-SIZE=
( {Title | SubTitle | XAxisLabel | XAxisMarkers | YAxisLabel | YAxisMarkers | Y2AxisLabel | Y2AxisMarkers | LegendText | LegendTitle}
, ~n_point_size ) ] _+6.1.3 (requires NewGraphics)
[CHART-SIZE= (~i_width, ~i_depth)]
[TITLE= {NONE | t}]
[SUB-TITLE= {NONE | t}]
[FOOTER-TEXT= {NONE | t}] _+8.2 (requires NewGraphics)
[SUB-FOOTER-TEXT= {NONE | t}] _+8.2 (requires NewGraphics)
[FILL= {GRAYSCALE | COLOR | CROSSHATCH | NONE | $t | &t}]
[3D-EFFECTS= {NO | YES | $t | &t}]
[BORDER= {YES | NO | $t | &t}]
[POINT-MARKERS= {YES | NO | $t | &t}]
[LEGEND= {YES | NO | $t | &t}]
[LEGEND-TITLE= {NONE | t}]
[LEGEND-PLACEMENT=
{CENTER-RIGHT | CENTER-LEFT | UPPER-RIGHT | UPPER-LEFT | UPPER-CENTER | LOWER-RIGHT | LOWER-LEFT | LOWER-CENTER | $t | &t}]
[LEGEND-PRESENTATION= {OUTSIDE | INSIDE | $t | &t}]
[PIE-SEGMENT-QUANTITY-DISPLAY= {YES | NO | $t | &t}]
[PIE-SEGMENT-PERCENT-DISPLAY= {YES | NO | $t | &t}]
[PIE-SEGMENT-EXPLODE=
{NONE | MAX | MIN | USE-3RD-DATA-COLUMN | $t | &t}]
[X-AXIS-ROTATE= {n_0_no_1_yes_N_only_if_more_than_N}] _+6.1.3 (requires NewGraphics)
[{X | Y | Y2 _+6.1.3}-AXIS-LABEL= {NONE | t}]
[{X | Y | Y2 _+6.1.3}-AXIS-MIN-VALUE= {AUTOSCALE | n}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAX-VALUE= {AUTOSCALE | n}]
[{X | Y | Y2 _+6.1.3}-AXIS-SCALE= {LINEAR | LOG | $t | &t}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAJOR-TICK-MARKS= {YES | NO | $t | &t}]
[{X | Y | Y2 _+6.1.3}-AXIS-MINOR-TICK-MARKS= {NO | YES | $t | &t}]
[{X | Y | Y2 _+6.1.3}-AXIS-MAJOR-INCREMENT= {AUTOSCALE | n}]
[{X | Y | Y2 _+6.1.3}-AXIS-MINOR-INCREMENT= n]
[{X | Y}-AXIS-TICK-MARK-PLACEMENT=
{OUTSIDE | INSIDE | BOTH | $t | &t}]
[{X | Y}-AXIS-GRID= {YES | NO | $t | &t}]
[{Y | Y2}-AXIS-MASK= {t_number_edit_mask}] _+6.1.4 (requires NewGraphics)
[ATTRIBUTES=

{ {t_selector[.t_sub_selector] | LIST:(t_selector[.t_sub_selector] [, ...]) | LIST:t_list_name} ,
{t_declaration_key ,
{t_value | n_value | (rgb) | (t_color_name) | LIST:({t_value | (rgb) | (t_color_name)} [, ...]) | LIST:t_list_name | PALETTE:t_color_palette}
[, ... , ...]}
} ] _+8.2 (requires NewGraphics) (see also: Chart Attributes)

PRINT-DIRECT _+2.20
[NOLF] _+3.0
[PRINTER={LINEPRINTER | POSTSCRIPT | HPLASERJET | HTML _+4.0 | LP | PS | HP | HT _+4.0}] _+3.0
{t} ...

PRINT-IMAGE _+3.0 [image_name] position

[TYPE= {EPS-FILE | HPGL-FILE | BMP-FILE | GIF-FILE _+4.0 | JPEG-FILE _+4.0 | PNG-FILE _+8.2 | $t | &t}]
[IMAGE-SIZE= (~i_width, ~i_height)]
[SOURCE= t_file_name]
[FOR-PRINTER=
({POSTSCRIPT | HPLASERJET | HTML | PDF | WINDOWS | PS | HP | HT | PD | WP | t_printer_type}
, {EPS-FILE | HPGL-FILE | BMP-FILE | GIF-FILE | JPEG-FILE | PNG-FILE _+8.2 | t_image_type}
, t_file_name)] _+8.0

PRINTER-DEINIT _+2.20, * reset_string (alternative: Declare-Printer)

PRINTER-INIT _* initialization_string (alternative: Declare-Printer)

PUT value... INTO array_name(i_element) [field[(i_occurs)]...]

READ {~i_file_num _-4.0 | i_file_num _+4.0} INTO v:£i_length... [STATUS= #n] _+3.0

ROLLBACK
(used with ORACLE, SQLBase _-6.0 , ODBC _+4.0 , DB2 _+4.0 , Informix _+4.0 , RDB _-4.0 , Ingres _-6.0 , DDO _+8.0 , Teradata _+8.0 )

SBTOMBS _+4.2 $t_single_byte_string_to_convert_to_multi_byte (Double-Byte version only)

SECURITY _+6.0
{MODE={ON | OFF | $t | &t}}
[SET=t_sid[,t_sid]...]
[APPEND=t_sid[,t_sid]...]
[REMOVE=t_sid[,t_sid]...]

SET-COLOR _+6.0
[PRINT-TEXT-FOREGROUND = (rgb | t_color_name)]
[PRINT-TEXT-BACKGROUND = (rgb | t_color_name)]
[PRINT-PAGE-BACKGROUND = (rgb | t_color_name)] _+8.0

SET-DELAY-PRINT _+6.0 v_var_previously_printed_with_delay WITH value

SHOW
[cursor_position] [CLEAR-SCREEN | CS | CLEAR-LINE | CL]
[value] [EDIT {edit_mask | NUMBER _+4.0 | MONEY _+4.0 | DATE _+4.0}]
[BOLD] [BLINK] [UNDERLINE] [REVERSE] [NORMAL] [BEEP] [NOLINE] ...

STOP [QUIET] _+2.20

STRING {t | d | n&n


	[]	Optional parameters.
	{}	Required parameters.
	\|	Separates a list of "either/or" options.
	()	Notes or additional comments.
	(Item) _+x.x	Denotes items that were added in version "x.x".
	(Item) _*	Denotes items that are becoming obsolete (but still backward compatible).
	(Item) _-x.x	Denotes items that were removed in version "x.x".

FLAGS	FLAG DESCRIPTIONS	PROG

-A	Causes the report output to be appended to an existing file of the same name.	SQR SQRT SQRP

-Bn	Indicates how many rows to buffer during each retrieve of data from the database. (Oracle) (SYBASE CT-Lib) _+3.0 (ODBC) _+4.3.2	SQR SQRT

-BURST:{T\|S\|P} _+4.1	T generates the TOC file. S[Level] uses the symbolic TOC to generate, bursting on the level Level. The flag -BURST:S is the same as -BURST:S1 P[Pages, Range[,Range]... ] uses page numbers to generate, Pages is the number of logical report pages for each HTML file, and Range is the page selection in one of the forms: x, x-y, x-, -y. -BURST:P is the same as -BURST:P0,1- using -PRINTER:HT. -BURST:P is the same as -BURST:P1- using -PRINTER:EH. (Requires -PRINTER:HT or -PRINTER:EH)	SQR SQRT SQRP

-C _+3.0	Makes the Cancel dialog box appear during program execution. (Windows)	SQR SQRT

-CB _+3.0	Forces the communication box to be used. (Windows, Callable SQR)	SQR

-Dn	Causes output to be displayed to the terminal as well as written to a file. Pauses after n lines. (Requires -PRINTER:LP) (non-Windows)	SQR SQRT SQRP

*-DB{database}*	Causes the program to use database. Overrides embedded SQR "USE" command. (SYBASE)	SQR SQRT

-DEBUG[x]	Causes 'DEBUG' to be defined. "#DEBUG" or "#ifdef DEBUG" lines will be compiled. The x allows multiple debugs. DEBUGAB defines DEBUG, DEBUGA, and DEBUGB.	SQR

-DNT:{x} _+4.0	Specifies Default Numeric Type for numeric variables. x can be V30, Integer, Float, or Decimal. To specify a Decimal precision, append a colon delimiter. (i.e. -DNT:Decimal:20).	SQR

*-E[file]*	Causes error messages to be recorded in the named or default file.	SQR SQRT SQRP

-EH_APPLETS _+5.1	Specifies the directory for Enhanced HTML applets.	SQR SQRT SQRP

-EH_BQD _+4.3.3	Create a (Report).bqd file (BrioQuery Data) from the data in the report and add a BQD icon to the HTML navigation bar.	SQR SQRT SQRP

-EH_BQD:file _+6.0	Associate the BQD icon with the specified file.	SQR SQRT SQRP

-EH_BROWSER _+5.1	ALL(default) _+4.3.4 generates HTML that will auto-sense the browser being used. IE or NETSCAPE generates an HTML file designed for the specific browsers. BASIC _+6.0 generates "every-browser" HTML. (see also SQR.INI - Enhanced HTML)	SQR SQRT SQRP

-EH_CSV _+4.3.1	Create a (Report).csv file from the data in the report.	SQR SQRT SQRP

-EH_CSV:file _+4.3.1	Associate the CSV icon with the specified file.	SQR SQRT SQRP

-EH_CSVONLY _+5.1	Create a (Report).csv file from the data in the report, but no accompanying HTML file.	SQR SQRT SQRP

-EH_DEBUG[:opts] _+6.2	Create a Report.dbg file. File will contain messages about both internal and compiler errors. Possible enhanced HTML debugging opts... Timing (Show elapsed time of EHTML execution.) Memory (Show memory usage statistics.) Help (Show these options.) Direct _+8.0 (Show Print-Direct packets.) PSqribe _+8.0 (Show PowerSQRIBE packets.) ZipAll _+8.2 (ZIP debug, spf, and security xml files.)	SQR SQRT SQRP

-EH_FULLHTML:level _+5.1	Default: _-8.0 report generates HTML 3.2. Default: _+8.0 report generates XHTML 1.1. Possible values are: 40 _+6.0 _-8.0 - generates HTML 3.2 40 _+8.0 - generates XHTML 1.1 32 _+6.0 - generates HTML 3.2 *30 _+6.0 _6.2 - generates HTML 3.0 _{in 6.1.3 and 6.1.4} 30 _+6.0 _6.2* - generates HTML 3.2 _{all others} *True _6.0 - generates HTML 3.2 False _6.0* - generates HTML 3.0 _{in 6.1.3 and 6.1.4} *False _6.0** - generates HTML 3.2 _{all others} (see also SQR.INI - Enhanced HTML)	SQR SQRT SQRP

-EH_ICONS:dir _+4.3.1	Set directory where referenced HTML icons are stored.	SQR SQRT SQRP

-EH_IMAGES:dir _+6.0	Set directory where navigation bar .GIF images are stored.	SQR SQRT SQRP

-EH_KEEP _+6.0	Causes -EH_ZIP to copy instead of move.	SQR SQRT SQRP

-EH_LANGUAGE _+5.1	English (default), French, German, Portuguese, Spanish, Japanese _+8.0, or Simplified Chinese _+8.0. Language for the navigation bar. (see also SQR.INI - Enhanced HTML)	SQR SQRT SQRP

-EH_PDF _+4.3.3	Add a PDF icon to the HTML navigation bar (automatic with -PRINTER:EP).	SQR SQRT SQRP

-EH_SCALE:n _+4.3.1	Set Enhanced HTML scale from 50 to 200.	SQR SQRT SQRP

-EH_XIMG _+6.1.3	Prevents path changes and format conversions for images. If checking into Portal, added this to the �Burst Options�.	SQR SQRT SQRP

-EH_XML:file _+6.0	Associate the XML icon with the specified file.	SQR SQRT SQRP

-EH_ZIP:file _+6.0	Moves generated files to file, or Report.zip if file not specified.	SQR SQRT SQRP

*-F{lib* \| lib/f(m) \| f(m)}** _+4.3.2 -8.0	Will override the default output file name LIS(Report) and use the named file. (Library can also be specified. If only a library is specified, the default-named report will be placed there. The "new-report" command ignores all -F settings.) (Multiple -F flags will apply to each of multiple reports in the order that they are "declare-report"ed.) (AS400)	SQR SQRT SQRP

*-F{path* \| pathfile \| file}**	Will override the default output file name Report.LIS and use the named file. (Path can also be specified. If only a path is specified, the default-named report will be placed there. The "new-report" command ignores all -F settings.) _+2.26 (Multiple -F flags will apply to each of multiple reports in the order that they are "declare-report"ed.) _+3.0	SQR SQRT SQRP

*-G{file_mode}* _+3.0 -8.0	Enables specification of report output file mode. (VM)	SQR SQRT SQRP

*-G{file_attr}* _+2.26 -8.0	Enables specification of report output file attributes. (VMS) (OpenVMS) _+3.0	SQR SQRT SQRP

-GPRINT={YES \| NO} _+4.0 -8.0	If YES, ANSI control characters are written to the first column of each record of the file. NO omits the control characters. (MVS)	SQR SQRT SQRP

*-I{dir_list}* _+3.0	Specifies the #INCLUDE files search paths. Comma or semi-colon separated.	SQR

-ID _+3.0	Displays the copyright banner on the console. (non-Windows)	SQR SQRT SQRP

-KEEP _+3.0	Creates an .SPF file for each report in addition to .LIS files.	SQR SQRT

-LL{S \| D}{C \| I} _+3.0	Load-Lookup: S=SQR,D=DB , C=case sensitive,I=case insensitive.	SQR

-LOCK{xx} _+3.0, -6.0	Defines the types of locking (isolation level) for the session. (SQLBase)	SQR SQRT

*-M{file}* _-8.0	Points to a startup file containing program limits that override the defaults.	SQR

*-N{database}* _-4.0	Uses the named database, rather than the default database. (Rdb)	SQR SQRT

-NOLIS _+3.0	Creates an .SPF file for each report instead of .LIS files.	SQR SQRT

-NR _+3.0, -6.0	Uses the No Recovery mode when connecting to the database. (SQLBase)	SQR SQRT

*-O[file]* _+3.0	Directs log messages to file. Defaults to report.log or to sqr.log in the current directory. (Windows)	SQR SQRT

-P _+3.0 -6.0	Directs output to the printer device. (VM)	SQR SQRT SQRP

-P _+4.3 -8.0	Suppress printer control characters from column 1. (MVS, AS400)	SQR SQRT SQRP

-PB _+3.0	Causes column data to retain trailing blanks. (Rdb _-4.0 , Informix)	SQR SQRT

*-P{id[/pass]}* _+3.0, -6.0	The role identifier used to associate permissions with SQR. (Ingres)	SQR SQRT

-PRINTER:{xx} _+3.0	Causes Printer type xx to be used when creating .LIS files. Valid values are LP, HP, HT _+4.0 , EH _+4.3.1 , EP _+4.3.3 , PD _+4.3.2.2 , PS, and WP (Windows only). WP output is sent to the printer without saving an output file. EP produces both EH and PD output. (EH is only available for limited platforms).	SQR SQRT SQRP

*-PRINTER:WP:{unc}* _+6.0	Causes the printer with the UNC name unc to be used for printing. (Windows)	SQR SQRT SQRP

-RS	Scans, syntax checks, and saves report and "ASK" responses in a 'run time' file called (Report).SQT.	SQR

-RT	Immediately processes the 'run time' file and "ASK" responses saved with the -RS flag.	SQR

-S	Causes the status of all cursors to be displayed at the end of the report run.	SQR SQRT

-SORT{n} _+3.0, -6.0	Specifies the size of the sort buffer in characters. (SQLBase)	SQR SQRT

-T{n}	For testing - causes 'order by' clauses to be ignored to save time during testing. Tests for n pages.	SQR SQRT

-TB _+4.0	Trims trailing blanks from character columns. (SYBASE CT-Lib, ODBC _+4.3, DB2 _+8.0, Teradata _+4.3)	SQR SQRT

-T{B \| Z \| BZ \| ZB} _+4.0 -8.0	B _MVS leaves trailing blanks on character columns. B _AS400 removes trailing blanks on character columns. Z leaves trailing zeros on numeric columns. BZ or ZB does both. (MVS/DB2, AS400/DB2)	SQR SQRT

-TZ _+8.0	Trims trailing zeros from decimal portion of numeric columns. (DB2, Teradata)	SQR SQRT

*-U{username}* _+3.0, -6.0	Specifies the user name, overriding the connectivity string. (Ingres)	SQR SQRT

*-V{server}*	Uses the named server. (Sybase and SQL Server _-8.0)	SQR SQRT

-V6 _+3.0, -4.0	Specifies V6 compatibility mode. (Oracle)	SQR SQRT

-XB _+3.0	Suppresses the SQR banner and the "SQR...End of Run" message. (non-Windows)	SQR SQRT SQRP

-XC _+2.20	Suppresses final commit. (callable SQR)	SQR SQRT

-XCB _+3.0	Do not use the communications box. (Windows)	SQR SQRT

-XI _+4.0.0.2	Do not use interaction. If an ASK or INPUT require user interaction, an error will occur.	SQR SQRT

-XL	Prevents SQR from logging on to the database.	SQR SQRT

-XLFF _+6.0	Prevents SQR from generating a trailing form-feed.	SQR SQRT SQRP

-XMB _+3.0.13	Prevents program interruption by any message boxes. Errors will only be sent to an .err file and show/display statements will only be sent to a .log file. (Windows & NT) See also: -E.	SQR SQRT

-XNAV _+4.1	Prevents creation of the navigation bar when a single HTML file is produced by a single report (multiple HTML files will still trigger the navigation bar creation)	SQR SQRT SQRP

-XP _+3.0	prevents SQR from creating temporary stored procedures. (SYBASE DB-Lib) _-4.0 (SYBASE CT-Lib) _+3.0.13	SQR SQRT

-XTB _+3.0	Preserves the trailing blanks in a .LIS file.	SQR SQRT SQRP

-XTOC _+4.1	Prevents the Table of Contents creation if the -PRINTER: flag is other than HT or EH.	SQR SQRT SQRP

-ZEN{name} _+6.1.4	Set default encoding name	SQR SQRT SQRP

*-ZIF{file}* _+4.0	Sets the full path & name of the SQR initialization file, SQR.INI.	SQR SQRT SQRP

-ZIV _+4.0	Invokes the SPF viewer after generating the program.spf file. The -KEEP flag is implicitly invoked. Only the first report will be passed to the viewer.	SQR SQRT

*-ZMF{file}* _+3.0	Specifies the full path & name of the SQR Error Message file, sqrerr.dat.	SQR SQRT SQRP

*-ZRF{file}* _+5.1	Specifies the full path & name of an alternate registry.properties file (DDO).	SQR SQRT

&	Begins a "bind" variable for a database column or expression, regardless of type.
$	Begins a text or date _+4.0 variable.
#	Begins a numeric variable. (Decimal _+4.0 , Floating point, or Integer _+4.0).
%	Begins a list variable. _+5.1 (DDO only)
@	Begins a marker location variable, used for identifying position fields inside BEGIN-DOCUMENT paragraphs.
'	(Single Quote). Surrounds a text literal. For example, `'Ray Ontko & Co.'`. Double to include a quote inside a literal. For example, `'''Yes!!'', he said.'`. NOTE: The exclamation mark must also be doubled or the rest of the line will be considered a comment.
!	Begins a comment, everything after the mark will not be compiled.
-	A dash at the end of a line continues the command onto the next line.
{}	Encloses a substitution variable.
[]	Encloses a dynamic SQL variable, dynamic query variable, or dynamic table name. Or a dynamic column name _+3.0
0X	Begins a literal Hex number _+6.1.4 It is case INsensitive. Examples:
		`let #num = 0x53e58d` `let #num = '0x53e58d'` `move '0X53E58D' to #num` `move 0X53E58D to #num !-- (not valid)` `while #i < 0x53E58d !-- (check against 5,498,253)`

#current-column	The current column on the page.
$current-date _+4.0	The current date-time on the local machine when SQR starts running the program.
#current-line	Refers to the physical line number on the page.
#end-file	Set to one (1) if end of file occurs on READ, otherwise zero (0).
#page-count	The current page number.
#return-status	Value to be returned to the operating system when SQR exits.
#sql-count	The count of rows affected by a DML statement (insert, update and delete).
$sql-error	The text message from the database explaining the most recent error.
#sql-status	The status value from the database after each query is compiled or executed.
$sql-text _+8.0	The text of the last SQL processed. Set by BEGIN-SQL, BEGIN-SELECT, and LOAD_LOOKUP. Available within ON-ERROR. Populated for DB2, DDO, INFORMIX, ODBC, ORACLE, SYBASE, and TERADATA.
$sqr-connected-db _+8.0 {sqr-connected-db} _+8.0	Backend database class from initial connection or "CONNECT" command. Valid ODBC values are: DB2 INFORMIX ODBC ORACLE REDBRICK SYBASE TERADATA Valid DDO values are: _+8.2 CSV DB2 ESSBASE INFORMIX MSOLAP ORACLE SAP SQLSERVER SYBASE XML
$sqr-connected-db-name _+8.0 {sqr-connected-db-name} _+8.0	Database driver name from initial connection or "CONNECT" command. ODBC value is from the ODBC Driver Manager. DDO value _+8.2 is from the driver being used. All others = $sqr-database / {sqr-database}.
$sqr-database _+3.0 {sqr-database} _+3.0	The database type for which SQR was compiled. Valid values are: ALLBASE _-4.0 DB2 INFORMIX INGRES _-6.0 ODBC _+4.0 ORACLE RDB _-4.0 REDBRICK _+4.3, -6.0 SQLBASE _-6.0 SYBASE
$sqr-dbcs _+4.2 {sqr-dbcs} _+4.2	Will be "YES" when referenced from double-byte enabled executables.
$sqr-encoding _+4.2 {sqr-encoding} _+4.2	Will hold the value of the ENCODING environment variable (see Encodings).
$sqr-encoding-console _+6.0 {sqr-encoding-console} _+6.0	Will hold the value of the log file or console ENCODING environment variable (see Encodings).
$sqr-encoding-database _+5.1 {sqr-encoding-database} _+5.1	Will hold the value of the database ENCODING environment variable (see Encodings).
$sqr-encoding-file-input _+5.1 {sqr-encoding-file-input} _+5.1	Will hold the value of the input file ENCODING environment variable (see Encodings).
$sqr-encoding-file-output _+5.1 {sqr-encoding-file-output} _+5.1	Will hold the value of the output file ENCODING environment variable (see Encodings).
$sqr-encoding-report-output _+5.1 {sqr-encoding-report-output} _+5.1	Will hold the value of the database ENCODING environment variable (see Encodings).
$sqr-encoding-source _+6.0 {sqr-encoding-source} _+6.0	Will hold the value of the source and include files ENCODING environment variable (see Encodings).
$sqr-hostname _+4.3.1 {sqr-hostname} _+4.3.1	The name of the machine that this SQR is running on.
$sqr-locale _+4.0	The name of the current locale. A "+" at the end means a value has changed.
#sqr-max-columns _+4.3.2	Maximum number of columns with the current layout. Is updated when a new report is selected.
#sqr-max-lines _+4.3.2	Maximum number of lines with the current layout. Is updated when a new report is selected.
#sqr-pid _+3.0	The process ID of the current SQR process. Unique for each run of SQR.
$sqr-platform _+3.0 {sqr-platform} _+3.0	The hardware/operating system type for which SQR was compiled. Valid values are: DOS _-4.0 MVS _-8.0 WINDOWS WINDOWS-NT _+4.0 _-8.0 UNIX VM _-6.0 VMS _-8.0
$sqr-program _+3.0	The name of the SQR program file.
$sqr-report _+3.0	The name of the report output file. Reflects the actual name to be used (-F flag or NEW-REPORT command).
#sqr-toc-level _+4.3.3	Level of current TOC entry.
#sqr-toc-page _+4.3.3	Page number of current TOC entry.
$sqr-toc-text _+4.3.3	Text of current TOC entry.
$sqr-ver _+3.0	The text string shown with the -ID flag.
$username	The database username specified on the command line.

[Color Map]
	*color_name* _+6.0	Define the (rgb) colors for this color_name (repeatable)

[Default-Settings]
	AllowDateAsChar _+4.3	When TRUE (default is FALSE) date columns will be retrieved as characters (like pre-4.0).
	AutoDetectUnicodeFiles _+6.1.3	When TRUE (default is FALSE) SQR will read the first 2 bytes of a file to determine the encoding for the file (unless encoding was specified within the "open" command).
	Default-Numeric _+4.0	Specifies Default Numeric Type for numeric variables. Can be V30, INTEGER, FLOAT, or DECIMAL. To specify a DECIMAL precision, use parentheses. i.e. DECIMAL(20). (see also: Command Line Flag -DNT).
	FixODBCAccuracy _+4.3.2.2	When TRUE (default is FALSE) SQR will correct "float" column anomalies occuring with Microsost ODBC drivers greater than 2.65.240.
	Locale _+4.0	SYSTEM (default) or locale name to use as initial locale when an SQR starts.
	NewGraphics _+6.0	When TRUE (default is FALSE) SQR will allow many advanced chart features
	OracleWeakCursor _+8.2	Stop, Warn, or Skip. If a 'Weak' reference cursor is processed, then... Stop: Issues an error messsage and halts program execution. Warn: Issues an error messsage, program continues (default). Skip: No error messsage, program continues .
	Output-File-Mode _+4.0	SHORT (default) _-4.1 or LONG (default) _+4.1 file names for HTML output. Ignored on 16-bit platforms.
	OutputFormFeedWithDashD _+4.3.1	When TRUE (default is FALSE) the -Dn flag will also output a Form-Feed character.
	OutputTwoDigitYearWarningMsg _+4.3.1	When TRUE (default) SQR will send a warning message to the error file when a YY or RR date edit mask is encountered when running program. This only effects SQR code that is processed.
	PDFCompressionText _{+6.1.3, *8.2}	Sets the level of PDF text compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6. (alternative: CompressionText_+8.2)
	PDFCompressionGraphics _{+6.1.3, *8.2}	Sets the level of PDF graphics compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6. (alternative: CompressionGraphics_+8.2)
	PrinterHT _+8.0	ENHANCED (default) -printer:ht will act like -printer:eh. STANDARD will produce HTML 2.0 files from -printer:ht
	Substitution-Character _+6.1.3	Allows defining the substitution character for undefined characters within a character set. Format is XX ENCODING_1 [, XX ENCODING_2... [, XX Default] ] Where XX is the hexidecimal value of the substitution character. (see Encodings)
	UseUnicodeInternal _+6.1.3	When TRUE (default is FALSE) forces SQR to use Unicode internally. Allows any encoding combinations in a single SQR run (including ASCII and EBCDIC).
	UseY2kCenturyAlgorithm _+4.3.1	When TRUE (FALSE is default) SQR will treat the "YY" date edit mask as though it were an "RR" date edit mask.

[Enhanced-HTML]
	Browser _+4.3.3	ALL(default) _+4.3.4 generates HTML that will auto-sense the browser being used. IE or NETSCAPE generates an HTML file designed for the specific browsers.
	DefaultTemplate _+8.2	Path to a customized defaultTemplate.xml template file used by SQR for HTML output.
	FullHTML _+4.3.1	When True, then report generates HTML 3.2.
	IncludePDFInZip _+8.1	When TRUE (default is FALSE) SQR will include the PDF file in the ZIP file created when both -PRINTER:EP and -EH_ZIP are specified.
	Language _+4.3.1	English (default), French, German _+4.3.3 , Portuguese _+4.3.3 , or Spanish _+4.3.3 . Language for the navigation bar.
	PrinterHT _+8.0	Enhanced (default) maps -printer:ht to -printer:eh and produces fully formatted output with version 1.1 XHTML tags. Standard causes -printer:ht to produce version 2.0 HTML files.

[Environment:Common]
[Environment:{DB2 \| ODBC \| Sybase \| Oracle \| Ingres _-6.0 \| SQLBase _-6.0 \| Informix \| DDO _+6.0}]
	ENCODING _+4.2	Encoding used by default. Default setting is ASCII. (see Encodings)
	ENCODING-CONSOLE _+5.1	Encoding used for console input and output. Default setting is ASCII. (see Encodings)
	ENCODING-DATABASE _+5.1	Encoding used for interfacing with the database. Default setting is ASCII. (see Encodings)
	ENCODING-FILE-INPUT _+5.1	Default encoding used for �OPEN� for-reading files and argument files. Default setting is ASCII. (see Encodings)
	ENCODING-FILE-OUTPUT _+5.1	Default encoding used for �OPEN� for-writing files. Default setting is ASCII. (see Encodings)
	ENCODING-REPORT-OUTPUT _+5.1	Default encoding used for report output, such as, SPF, LIS, HTM, etc. Default setting is ASCII. (see Encodings)
	ENCODING-SQR-SOURCE _+6.0	Encoding used for SQR source and include files. Default setting is ASCII. (see Encodings)
	SQR_DB_DATE_FORMAT _+4.0	Format for string comparison to date columns.
	SQR_DB_DATE_ONLY_FORMAT _+4.2	Format for string comparison to date columns that only have a date component.
	SQR_DB_TIME_ONLY_FORMAT _+4.2	Format for string comparison to date columns that only have a time component.
	SQR_JRE_EXE _+6.0	Path and name of the JRE executable.
	SQR_JRE_FLAGS _+6.0	Passes arbitrary flags to the "jre" when processing SPF files.
	SQR_JRE_VER _+6.0	Version of the JRE executable.
	SQR_USEJVM _+8.0	TRUE (default) embeds the JVM (Java Virtual Machine) directly into the sqr. FALSE will mimic old behaviour. Used for Enhanced HTML and NewGraphics

[Environment:DDO] _+6.0
	SQR_DDO_JRE_CLASS	Classpath for DDO drivers, support files.
	SQR_DDO_JRE_CLASS{n}	Optional; additional entries to the classpath.
	SQR_DDO_JRE_INIT_HEAP _+6.2	(default: 4M) Size of the initial heap. Value may be set as N (bytes), NK (Kilobytes) or NM (Megabytes).
	SQR_DDO_JRE_MAX_HEAP _+6.2	(default: 32M) Maximum size of the heap. Value may be set as n (bytes), nK (Kilobytes) or nM (Megabytes).
	SQR_DDO_JRE_NOCLASSGC _+6.2	When TRUE (default is FALSE) will prevent Class Garbage Collection.
	SQR_DDO_JRE_NOJIT _+6.2	When TRUE (default is FALSE) will disable the JIT compiler.
	SQR_DDO_JRE_PATH	Classpath information for the local JRE.
	SQR_DDO_JRE_VERBOSE _+6.2	When TRUE (default is FALSE) will run the JVM in Verbose mode. (Note: This creates a file in the current working directory called 'vm.out'.)

[Fonts]
	CharacterSet _+4.3.3	(Windows Only) DEFAULT will emulate previous versions of SQR. AUTO will use the Windows default character set with -PRINTER:WP or when viewing SPF files. Alternately, you may set a specific character set with the following keywords: ANSI ARABIC BALTIC CHINESEBIG5 EASTEUROPE GB2312 GREEK HANGUL HEBREW JOHAB MAC OEM RUSSIAN SHIFTJIS SYMBOL THAI TURKISH VIETNAMESE

[HTML-Images]
	FIRST-PAGE _+4.1	Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,firstpg.gif).
	PREV-PAGE _+4.1	Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,prevpg.gif).
	NEXT-PAGE _+4.1	Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,nextpg.gif).
	LAST-PAGE _+4.1	Graphic info for the navigation bar in the form Height,Width,Name (default is 60,60,lastpg.gif).
	WALLPAPER _+4.1	The "Wallpaper" graphic name (default is none).

[Local:locale-name] _+4.0
	NUMBER-EDIT-MASK	Default edit mask when the keyword NUMBER is used with DISPLAY, MOVE, PRINT or SHOW.
	MONEY-EDIT-MASK	Default edit mask when the keyword MONEY is used with DISPLAY, MOVE, PRINT or SHOW.
	DATE-EDIT-MASK	Default edit mask when the keyword DATE is used with DISPLAY, MOVE, PRINT, SHOW, datetostr() or strtodate().
	INPUT-DATE-EDIT-MASK	Default edit mask when the keyword DATE is used with INPUT or the input variable is a DATE variable.
	MONEY-SIGN	Character(s) that replace the `'$'` edit character.
	MONEY-SIGN-LOCATION	The MONEY-SIGN character(s) location. Values are LEFT or RIGHT.
	THOUSAND-SEPARATOR	Character that replaces the `','` edit character.
	DECIMAL-SEPARATOR	Character that replaces the `'.'` edit character.
	DATE-SEPARATOR	Character that replaces the `'/'` edit character.
	TIME-SEPARATOR	Character that replaces the `':'` edit character.
	EDIT-OPTION-NA	Character(s) that replace the `'NA'` edit character.
	EDIT-OPTION-AM	Character(s) that replace the `'AM'` edit character.
	EDIT-OPTION-PM	Character(s) that replace the `'PM'` edit character.
	EDIT-OPTION-AD	Character(s) that replace the `'AD'` edit character.
	EDIT-OPTION-BC	Character(s) that replace the `'BC'` edit character.
	DAY-OF-WEEK-CASE	Affects DAY-OF-WEEK-FULL entries (format code 'DAY') and DAY-OF-WEEK-SHORT entries (format code 'DY'). UPPER forces the output to all uppercase. LOWER forces the output to all uppercase. EDIT follows format code case. NO-CHANGE uses exact case as listed in the appropriate entries.
	DAY-OF-WEEK-FULL	Seven single-quoted entries, comma seperated, all within single parenthesis. Represents the full names for the days of the week starting with Sunday.
	DAY-OF-WEEK-SHORT	Seven single-quoted entries, comma seperated, all within single parenthesis. Represents the abbreviated names for the days of the week starting with Sunday.
	MONTHS-CASE	Affects MONTHS-FULL entries (format code 'MONTH') and MONTHS-SHORT entries (format code 'MON'). UPPER forces the output to all uppercase. LOWER forces the output to all uppercase. EDIT follows format code case. NO-CHANGE uses exact case as listed in the appropriate entries.
	MONTHS-FULL	Twelve single-quoted entries, comma seperated, all within single parenthesis. Represents the full names for the months of the year starting with January.
	MONTHS-SHORT	Twelve single-quoted entries, comma seperated, all within single parenthesis. Represents the abbreviated names for the months of the year starting with January.
[MAP-DDO-DB] _+8.2
	*unknown_DDO_driver_name*	Maps the unknown DDO driver name ($sqr-connected-db-name) to a valid $sqr-connected-db class.

[MAP-ODBC-DB] _+8.0
	*unknown_ODBC_driver_name*	Maps the unknown ODBC driver name ($sqr-connected-db-name) to a valid $sqr-connected-db setting.

[PDF Fonts] _+4.3.2.2
	*font_number*	Maps an SQR font number to an ADOBE font for PDF output. The assignment form is... Typeface [ , CJK_Typeface , Charcter_Map] _+6.1.4 (see Non-Roman PDF Fonts for possible values)
	Embed _+8.2	If this setting is not specified, no fonts are embedded into the PDF file (default). If "All" is specified, then all fonts are embedded into the PDF file. If a space seperated listing of font numbers is specified, then those fonts are embedded into the PDF file.

[PDF Settings] _+8.2
	Bookmarks	True creates a PDF bookmark for each TOC entry. Default is False.
	Compatibility	4, 5, or 6. Minimum Acrobat version required to read the PDF. Default is 5.
	CompressionText	Sets the level of PDF text compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6.
	CompressionGraphics	Sets the level of PDF graphics compression from 0 (no compression - fast) to 9 (max compression - slower). Default is 6.
	EmbedAction	Stop, Warn, or Skip. If an error occurs when embedding a font then... Stop: Issues an error messsage and halts program execution (default). Warn: Issues an error messsage, font is used without embedding. Skip: No error messsage, font is used without embedding.
	EncodingNotInFontAction	Stop, Warn, or Skip. If a font does not support an encoding then... Stop: Issues an error messsage and halts program execution (default). Warn: Issues an error messsage, CP1252 is used. Skip: No error messsage, CP1252 is used.
	Subsetting	True (default) enables subsetting for all fonts where subsetting is possible.
	SubsetLimit	Percentage (1-100) of glyphs from a font used in a document at which subsetting is disabled for that font and the complete font is embedded. Default is 100.
	SubsetMinSize	Size (in KB) of a font file at which subsetting is enabled. Smaller files will have the complete font embedded. Default is 100.
	UnsupportedEncodingAction	Stop, Warn, or Skip. If a font does not support an encoding then... Stop: Issues an error messsage and halts program execution (default). Warn: Issues an error messsage, CP1252 is used. Skip: No error messsage, CP1252 is used.

[Processing-Limits] _-8.0
	*(see -M file entries)*

[SQR Remote] _+6.0
	HostName _+8.0	Default host name.
	Passive	For Report Activator - a value of 1 causes the FTP passive method of username/password verification to be used.
	TimeOut _+8.0	Timeout duration in seconds (default = 30).
	UserName _+8.0	Default username used to log into the host (see HostName above).

KEY:
Date _+4.0		Text		Numeric		List _+5.1
$d	Variable	$t	Variable	#n	Variable	%l	Variable
&d	Column	&t	Column	&n	Column
£d	Literal	£t	Literal	£n	Literal
~d	Variable or Literal	~t	Variable or Literal	~n	Variable or Literal
d	Var, Lit, or Col	t	Var, Lit, or Col	n	Var, Lit, or Col

v	Any Variable	value	Any Variable, Literal, or Column

SQR Programmer Reference Card

SQR language version 2.x-8.2

(In Progress: Use at your own risk)

SQRT COMMAND LINE +3.0

SQRP COMMAND LINE +3.0

SQRT COMMAND LINE _+3.0

SQRP COMMAND LINE _+3.0