Ray Ontko & Co.
Library
Services | Products | Library | Careers News | About Us | Contact Us | Search | Site Map

SQR Programmer Reference Card

SQR language version 2.x-11.1.1    

© 1998-2009, 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

     
  []   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 *8.3.
-BURST:P is the same as -BURST:P1- using -PRINTER:EH.
(Requires -PRINTER:HT *8.3 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 *8.3 (Default action: report generates HTML 3.2) ‑8.0
(Default action: report generates XHTML 1.1) +8.0
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, SChinese +8.0, or TChinese +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

-GD_DRIVER:{name} +9.0.1 Only valid with ‑PRINTER:GD.
Specifies the name of the Generic Driver. Valid values are...
  EXCEL     Office HTML for Excel (2003 / XP)
  WORD +9.3.1   Office HTML for Word (2003 / XP)
  PP +9.3.1   Office HTML for Power Point (2003 / XP)
SQR
SQRT
SQRP

-GD_OPTION:{options} +9.0.1 Only valid with ‑PRINTER:GD.
Specifies the parameter options for the Generic Driver. Valid values are...
  (not usable in 9.0)      
(The optional parameters are used to pass command line data to your personal application. The parameters entered depend on your application.)+11.1.1
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...  
  EH +4.3.1   Enhanced HTML
EP +4.3.3 Enhanced HTML & PDF
GD +9.0.1 Generic Driver (see ‑GD_DRIVER and ‑GD_OPTION)
HP   HP Laserjet
HT +4.0 *8.3 HTML
LP   Line Printer
PD +4.3.2.2 PDF
PS +4.3.1 PostScript
WP +4.3.1 Windows
WP output is sent to the printer without saving an output file.
(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

-PS{n} Sets the Tabular Data Stream (TDS) packet size to n.  (Sybase) SQR
SQRT

-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

-U{prvldg_connectivity} +11.1.1 Directs SQR to connect to the DB using prvldg_connectivity and then proxy as the "user" from Connectivity on the command line. (Oracle) 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

-XFRM +9.3 Suppresses the frame in HTML files created with ‑printer:eh SQR
SQRT
SQRP

-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 or binary+8.3.1 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.
 
BINARY +8.3.1
Binary.
 
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).  
 
CSVSeparator  +9.0.1 Comma | Semicolon | Space | Tab
Specifies the delimiter when creating CSV files.
 
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).  
 
ExpirationWarningMessage  +9.0.1 Default is TRUE. Whether or not to print the license expiration warning.
 
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.  
 
FormatForRowsetXML  +11.1.1 Format (SQR | BIP) in which to create the xml file defined with OPEN-RS, WRITE-RS, and CLOSE-RS. BIP stands for BI Publisher.
 
ImageCompression  +8.3.1 Compression level (0 - 9 ; 6 is Default) to use when the SOURCE option of the PRINT-IMAGE command is a binary variable.
 
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  
 
ODBCExecuteRetry  +9.0.1 When True (default) an EXECUTE that returns an error will be retried.
 
OracleWeakCursor  +8.1 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) maps -printer:ht *8.3 to -printer:eh and produces fully formatted output with version 1.1 XHTML tags.
Standard causes -printer:ht *8.3 to produce version 2.0 HTML files.  
 
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 
 
TreatBinaryColumnAsText  +9.0.1 When True (default) treat BINARY columns as TEXT columns.
 
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 *8.3 (Default action: report generates HTML 3.2) ‑8.0
(Default action: report generates XHTML 1.1) +8.0
Possible values are:
40 +6.0  ‑8.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
 
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.  
 
[Environment:Common]
[Environment:{DB2 | DDO +6.0| Ingres ‑6.0 | Informix | ODBC | Oracle | SQLBase ‑6.0 | Sybase }]
DSQUERY  (Sybase only) – Identifies the default Sybase server to use.
 
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 
 
SQRDIR  The default directory for all invocations of SQR. Mandatory for Windows.
 
SQRFLAGS  Default command-line flags for all invocations of SQR.
 
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] -8.2
[HTML:Images] +8.2
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

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.


COORDINATE SYNTAX

(a,b) where

Line position and column position values may be fixed, or relative.

Examples:

       begin-document (1,1)
Will begin on line 1, column 1.

       print-image my_pic (+3,15)
Will be printed with the upper-left corner of the image 3 lines below the previous printed object and indented to column 15.

       print-image other_pic (,140)
Will be printed on the same line as my_pic at column 140.


RGB SYNTAX

r,g,b where

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 Binary +8.3.1 List +5.1
$d Variable $t Variable #n Variable $b Variable %l Variable 
&d Column &t Column &n Column &b Column  
£d Literal £t Literal £n Literal £b Literal
~d Variable or Literal  ~t Variable or Literal  ~n Variable or Literal  ~b Variable or Literal 
d Var, Lit, or Col  t Var, Lit, or Col  n Var, Lit, or Col  b 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= {FALSE | TRUE}] +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 | Page | $t | &t , ~n  [ , ... , ...]] ) }
| {(Window | Visible | $t | &t [ , Page | $t | &t , ~n ] ) }
| {(Width | VisibleWidth | $t | &t [ , Top | Page | $t | &t , ~n ] ) }
| {(Height | VisibleHeight | $t | &t [ , Left | Page | $t | &t , ~n ] ) }
| {(Rectangle | $t | &t [ , Left | Right | Bottom | Top | Page | $t | &t , ~n  [ , ... , ...]] ) } ] +8.2
[PDF-PAGE-TRANSITION=
{(Replace | Blinds | Box | Dissolve | Glitter | 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] [NoForm] [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
 
ALTER-TABLE +11.1.1
{NAME= t_table_name}
{ACTION= { ERASE | INFO | ATRRIBUTES }}
(For ACTION = ERASE)
{no other options allowed}
(For ACTION = INFO) - must specify at least one
[ROW = i_last_table_row_acted_on]
[COUNT = i_rows_in_the_table]
(For ACTION = ATRRIBUTES)
[ROW = i_row_to_be_affected]
[COUNT = i_rows__default_is_1]
[ATTRIBUTES = ( [DEFAULT,] { £t_attribute , {t | n} }... )]
 
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  coordinates
 
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|binary +8.3.1} [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 ]
column_name_or_expression  [&column_alias[={char|text|number|date+4.0|binary+8.3.1}]]  [ print_position  [print_format_commands] ] ...
 
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-TABLE, 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}
 
CLOSE-RS +11.1.1  {NAME=t_row_set_name}
 
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_non_binary WITH $t [{:$t_edit_mask | £t_edit_mask}]
Or (+8.3.1)
CONCAT  b WITH $b
 
CONNECT  t_username_and_password  [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 | BINARY +8.3.1}[:i_occurs][={£t|£n|£b+8.3.1}] +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())
 
CREATE-TABLE +11.1.1
{NAME= t_table_name}
{USING= { t_table_template_name | NONE }}
[TABLE-ATTRIBUTES = ( [DEFAULT,]  {£t_table_attribute , {t | n} }...  ) ]
[ROW-ATTRIBUTES = ( [DEFAULT,]  {£t_row_attribute , {t | n} }...  ) ]
[COLUMN-ATTRIBUTES = ( {£i_column_number} , [DEFAULT,]  {£t_column_attribute , {t | n} }...  )  ] ...
 
DECLARE-CHART +3.0  chart_name
[DATA-ARRAY= {array_name}] +8.2
[DATA-ARRAY-ROW-COUNT= £i_row_count] +8.2
[DATA-ARRAY-COLUMN-COUNT= £i_col_count] +8.2
[DATA-ARRAY-COLUMN-LABELS= {NONE | array_name | (£t_label1,£t_label2,...)}] +8.2
[DATA-LABELS= {NO | YES}] +6.0 (requires NewGraphics)
[COLOR-PALETTE= £t_palette_name] +6.0 (requires NewGraphics)
[ITEM-COLOR=
( {ChartBackground | ChartForeground | HeaderBackground | HeaderForeground | FooterBackground ‑8.2 | FooterForeground ‑8.2 | 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 | RADAR +9.3 | POLAR +9.3 | CANDLE-STICK +9.3 | AREA-RADAR +9.3}]
[Y2-TYPE=
{BAR | LINE | NONE +8.2 | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE +6.1.4 | RADAR +9.3 | POLAR +9.3 | CANDLE-STICK +9.3 | AREA-RADAR +9.3}] +6.1.3
[Y2-DATA-ARRAY= {array_name}] +8.2
[Y2-DATA-ARRAY-ROW-COUNT= £i_row_count] +8.2
[Y2-DATA-ARRAY-COLUMN-COUNT= £i_col_count] +8.2
[Y2-DATA-ARRAY-COLUMN-LABELS= {NONE | array_name | (£t_label1,£t_label2,...)}] +8.2
[Y2-COLOR-PALETTE= £t_palette_name] +8.2 (requires NewGraphics)
[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)
[Y-AXIS-GRID= {YES | NO}]
[{X | Y2 +8.2}-AXIS-GRID= {NO | YES}]
[{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}]
[{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}| AUTO-DETECT +9.3]
[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 | AUTO-DETECT +9.3}
 , £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 | PDF +6.1.3 | LP | PS | HP | HT +4.0| PD +6.1.3}]
END-DECLARE
 
DECLARE-TABLE +11.1.1  table_template_name
{COLUMN-COUNT= £i_number_of_columns}
[TABLE-ATTRIBUTES = ( {£t_table_attribute , {£t | £n} }...  ) ]
[ROW-ATTRIBUTES = ( {£t_row_attribute , {£t | £n} }...  ) ]
[COLUMN-ATTRIBUTES = ( {£i_column_number} , {£t_column_attribute , {£t | £n} }...  )  ] ...
 
DECLARE-TOC +4.1  toc_name
[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]...]
[BINARY binary_var [binary_var] +8.3.1...]
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)
 
DRAW +9.0.1 coordinates
{TYPE = {BOX | HORZ‑LINE | VERT‑LINE | LINE +9.3 | OVAL +9.3 | $t | &t}}
(For TYPE = BOX) 
{HEIGHT = i_height}
{WIDTH = i_width}
[RULE = i_rulewidth_in_decipoints]
[FILL-COLOR = (rgb | t_color_name)]
[LINE-COLOR = (rgb | t_color_name)]
[CAP = {ROUND | BEVEL | MITER | $t | &t}]
[LINE-STYLE = {SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT | $t | &t}] +9.3
(For TYPE = HORZ‑LINE) 
{WIDTH = i_width}
[RULE = i_rulewidth_in_decipoints]
[LINE-COLOR = (rgb | t_color_name)]
[CAP = {ROUND | SQUARE | FLAT | $t | &t}]
[LINE-STYLE = {SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT | $t | &t}] +9.3
(For TYPE = VERT‑LINE) 
{HEIGHT = i_height}
[RULE = i_rulewidth_in_decipoints]
[LINE-COLOR = (rgb | t_color_name)]
[CAP = {ROUND | SQUARE | FLAT | $t | &t}]
[LINE-STYLE = {SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT | $t | &t}] +9.3
(For TYPE = LINE) +9.3
[RULE = i_rulewidth_in_decipoints]
[LINE-COLOR = (rgb | t_color_name)]
[CAP = {ROUND | SQUARE | FLAT | $t | &t}]
[LINE-STYLE = {SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT | $t | &t}] 
[END-POINT = {coordinates}] 
(For TYPE = OVAL) +9.3
{HEIGHT = i_height}
{WIDTH = i_width}
[RULE = i_rulewidth_in_decipoints]
[FILL-COLOR = (rgb | t_color_name)]
[LINE-COLOR = (rgb | t_color_name)]
[LINE-STYLE = {SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT | $t | &t}]  
 
DUMP-TABLE +11.1.1
{NAME= t_table_name}
[CONTINUATION= { NO | YES | t ]
 
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
Or (+8.3.1)
EXTRACT  $b  FROM b ~i_start_location ~i_length
 
FILL-TABLE +11.1.1
{NAME= t_table_name}
{VALUE= value}
{LOCATION=( n_row , n_col [ , n_width]) }
[ATTRIBUTES = ( {£t_attribute , {t | n} }...  ) ]
 
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
[FILL-COLOR = ($t)] +9.0.1
[LINE-COLOR = ($t)] +9.0.1
 
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 *9.0.1  ~i_depth [~i_rulewidth [~i_shading_percent]]  (alternative: Draw)
 
GRAPHIC position HORZ-LINE +2.20  [~i_rulewidth]  (alternative: Draw)
 
GRAPHIC position VERT-LINE +2.20  [~i_rulewidth]  (alternative: Draw)
 
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 ‑8.2 | i_length +8.2}[:{VARY | FIXED | FIXED_NOLF +3.0 | BINARY +8.3.1}]}
[STATUS= #n]
[ENCODING= {$t_encoding | &t_encoding | Unquoted_Encoding}] +6.1.3 (requires UseUnicodeInternal=True)
 
OPEN-RS 11.1.1
{NAME= t_row_set_name}
{FILENAME= t_file_name}
{COLUMN= ( t_column_name , {STRING | BINARY | DECIMAL | DOUBLE | INTEGER | DATE | TIME | DATETIME | t_type} )}...
 
PAGE-NUMBER  position [£t_pre_text [£t_post_text] ]
 
PAGE-SIZE *  £i_page_depth £i_page_width  (alternative: Declare-Layout)
 
POSITION  coordinates [@document_marker [COLUMNS i ...]]
 
PRINT  value position [format_commands]
 
PRINT-BAR-CODE +3.0 coordinates
{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] coordinates
{DATA-ARRAY= {array_name}} ‑8.2
[DATA-ARRAY= {array_name}] +8.2   (optional if in declare‑chart) 
{DATA-ARRAY-ROW-COUNT= i_row_count} ‑8.2
[DATA-ARRAY-ROW-COUNT= i_row_count] +8.2   (optional if in declare‑chart) 
{DATA-ARRAY-COLUMN-COUNT= i_col_count} ‑8.2
[DATA-ARRAY-COLUMN-COUNT= i_col_count] +8.2   (optional if in declare‑chart) 
[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 | RADAR +9.3 | POLAR +9.3 | CANDLE-STICK +9.3 | AREA-RADAR +9.3 | $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 | NONE +8.2 | 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 | RADAR +9.3 | POLAR +9.3 | CANDLE-STICK +9.3 | AREA-RADAR +9.3 | &t}
   {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  ]
 ] +6.1.3 ‑8.2
[Y2-TYPE=
{BAR | LINE | NONE +8.2 | STACKED-BAR | 100%-BAR | OVERLAPPED-BAR | FLOATING-BAR | HISTOGRAM | AREA | STACKED-AREA | 100%-AREA | XY-SCATTER-PLOT | HIGH-LOW-CLOSE | BUBBLE  | $t | &t} ] +8.2
[Y2-DATA-ARRAY= {array_name}] +8.2   (optional for Y2 if in declare‑chart) 
[Y2-DATA-ARRAY-ROW-COUNT= i_row_count] +8.2   (optional for Y2 if in declare‑chart) 
[Y2-DATA-ARRAY-COLUMN-COUNT= i_col_count] +8.2   (optional for Y2 if in declare‑chart) 
[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 ‑8.2 | FooterForeground ‑8.2 | 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)
[Y-AXIS-GRID= {YES | NO | $t | &t}]
[{X | Y2 +8.2}-AXIS-GRID= {NO | YES | $t | &t}]
[{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}]
[{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 | b+8.3.1 } ...
 
PRINT-IMAGE +3.0 [image_name] coordinates
[TYPE= {EPS-FILE | HPGL-FILE | BMP-FILE | GIF-FILE +4.0 | JPEG-FILE +4.0 | PNG-FILE +8.2 | AUTO-DETECT +9.3 | $t | &t}]
[IMAGE-SIZE= (i_width , i_height)]  
[SOURCE= { t_file_name | b_image +8.3.1}]  
[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 | AUTO-DETECT +9.3 | t_image_type}
 , t_file_name)] +8.0
 
PRINT-TABLE +11.1.1
{NAME= t_table_name}
[CONTINUATION= { NO | YES | t ]
 
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_non_binary:{£i_length ‑8.2 | i_length +8.2}... [STATUS= #n] +3.0
Or (+8.3.1)
READ   i_file_num  INTO $b: i_length ... [STATUS= #n]  (requires OPEN with file type BINARY)
 
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
[FILL-COLOR = (rgb | t_color_name)] +9.0.1
[LINE-COLOR = (rgb | t_color_name)] +9.0.1
 
SET-DELAY-PRINT +6.0 v_var_previously_printed_with_delay WITH value
 
SHOW
[cursor_coordinates]  [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 +4.3.2}... BY t_delim_txt INTO $t
Or (+8.3.1)
STRING  {b}... BY b_delim_binary INTO $b
 
SUBTRACT  n FROM #n [ROUND= £i]
 
TOC-ENTRY +4.1
TEXT= {t_toc_text}
[LEVEL= {n_toc_level}]
 
UNSTRING  {t | d} BY t_delim_txt INTO $t...
 
UPPERCASE  $t
 
USE  database  (SYBASE, ODBC +8.0 and SQL Server ‑8.0 only)
 
USE-COLUMN  i_column_number
 
USE-PRINTER-TYPE +3.0
{LINEPRINTER | POSTSCRIPT | HPLASERJET | HTML +4.0 | PDF +6.1.3 | LP | PS | HP | HT +4.0| PD +6.1.3}]
 
USE-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)]]
 
USE-REPORT +3.0  t_report_name
 
WHILE  logical_expression
[CONTINUE] +8.0
 
WRITE  {~i_file_num ‑4.0 | i_file_num +4.0} FROM value_non_binary[:{£i_length ‑8.0 | i_length +8.0}]... [STATUS= #n] +3.0
Or (+8.3.1)
WRITE   i_file_num  FROM b: i_length ... [STATUS= #n]  (requires OPEN with file type BINARY)
 
WRITE-RS 11.1.1
{NAME= t_row_set_name}
{VALUE= ( t_column_name , value )}...


EXPRESSIONS

NOTE: Logical expressions can be numeric. 0 is considered false, and non-zero is considered true.

OPERATORS (In descending order of precedence)...
||
+    ‑    {sign prefixes}
^
*    /    %
+    ‑
<    >    >=   <=   <>   !=   =
not
and
or   xor
BIT-WISE OPERATORS +6.1.4 (In descending order of precedence)...
bitand
bitor   bitxor
FILE FUNCTIONS +3.0
DELETE  (t_filename)  ‑‑> #n_error_code_or_zero
EXISTS  (t_filename)  ‑‑> #n_error_code_or_zero
FILESIZE +8.3.1(t_filename)  ‑‑> #n_file_size_or_negative_one
GETFILEMAPNAME +9.3.1(t_filename)  ‑‑> $t_mapped_file_name_if_in_workspace
RENAME  (t_oldname,t_newname)  ‑‑> #n_error_code_or_zero
UFUNC FUNCTIONS
MAX  (n_val1[, n_val2[, ...]])  ‑‑> #n_error_code_or_zero
PRINTARRAY  (array()_array_pointer, n_elements_to_print, n_occurs_of_field, t_field_type_C_or_N)  ‑‑> 
      #n_error_code_or_zero
RAND +6.2(n_seed)  ‑‑> #n_random_number
SLEEP +6.2(n_seconds)  ‑‑> #n_zero_on_win_or_unslept_seconds_on_unix
SPLIT  ($t_source,$t_split1[, $t_split2[, ...]])  ‑‑> #n_char_splits_made
SYSTEM +3.5.3(t_command)  ‑‑> #n_status
NUMERIC FUNCTIONS  
ABS  (n)  ‑‑> #n_positive
ACOS  (n)  ‑‑> #f_radians
ASIN  (n)  ‑‑> #f_radians
ATAN  (n)  ‑‑> #f_radians
CEIL  (n)  ‑‑> #i_smallest_greater_than_n
COS  (n_radians)  ‑‑> #f
COSH  (n_radians)  ‑‑> #f
DEG  (n_radians)  ‑‑> #f_degrees
E10  (n_power)  ‑‑> #f_10_raised_to_power
EXP  (n_power)  ‑‑> #f_log_base_e_raised_to_power
FLOOR  (n)  ‑‑> #i_largest_less_than_n
LOG  (n)  ‑‑> #f_natural_log_of_n
LOG10  (n)  ‑‑> #f_base10_log_of_n
MOD  (nx, ny)  ‑‑> #n_remainder_of_x_div_y
POWER  (nx, ny)  ‑‑> #f_x_raised_to_power_of_y
RAD  (n_degrees)  ‑‑> #f_radians
ROUND  (nx, ny)  ‑‑> #n_x_rounded_to_y_decimal_places
SIGN  (n)  ‑‑> #i_0_pos1_neg1
SIN  (n_radians)  ‑‑> #f
SINH  (n_radians)  ‑‑> #f
SQRT  (n)  ‑‑> #f_squre_root_of_n
TAN  (n_radians)  ‑‑> #f
TANH  (n_radians)  ‑‑> #f
TRUNC  (nx, ny)  ‑‑> #n_x_truncated_to_y_decimal_places
STRING FUNCTIONS
ARRAY +3.0(t_array_name,t_field_name)  ‑‑> $t_pointer  
ASCII  ({t_str | d_str})  ‑‑> #i_ascii_val_of_first_char_in_str  
CHR  (i_ascii_val)  ‑‑> $t_char_of ascii_val  
COMMAND_LINE +8.0()  ‑‑> $t_command_line_from_this_run  
COND  (n_logical, value_a, value_b)  ‑‑> v_if_nlogical_then_valuea_else_valueb  
EDIT  (v_source, t_edit_mask)  ‑‑> $t_source_edited_under_mask  
FROMHEX +8.3.1(t_hex_string)  ‑‑> $b_source_as_binary_2_hexidecimal_per_byte  
GETENV +3.0(t_var_name)  ‑‑> $t_value_of_environent_var_name_or_null  
HEX +6.1.4(n_num)  ‑‑> $t_lower_case_hex_notation  
INSTR  ({t_source | d_source}, t_str, i_start_atoffset)  ‑‑> #i_position_of_str_in_source_or_0  
ISBLANK +3.0({t_source | d_source})  ‑‑> #i_1_if_source_is_null_or_whitespace_else_0  
ISNULL  ({t_source | d_source})  ‑‑> #i_1_if_source_is_null_else_0  
ISNUMBER +9.3(t_source)  ‑‑> #i_1_if_source_is_a_number_else_0  
LENGTH  ({t_source | d_source})  ‑‑> #i_num_of_chars_in_source  
LOWER  ({t_source | d_source})  ‑‑> $t_lower_cased_source  
LPAD  ({t_source | d_source}, i_len, t_str)  ‑‑> $t_source_padded_on_left_with_str_to_len  
LTRIM  ({t_source | d_source}, t_char_set)  ‑‑>
      $t_source_with_all_leftmost_char_set_chars_removed  
NVL  (value_source, value_alt)  ‑‑> v_source_unless_null_then_alt  
RANGE  (value_source, value_low, value_high)  ‑‑>
      #i_1_if_source_is_within_low_to_high_(inclusive)_else_0  
REPLACE +6.0({t_source | d_source}, t_orig, t_repl)  ‑‑>
      $t_source_with_each_orig_str_replaced_with_repl_str  
ROMAN +4.1(n_num)  ‑‑> $t_lower_case_roman_numerals  
RPAD  ({t_source | d_source}, i_len, t_str)  ‑‑> $t_source_padded_on_right_with_str_to_len  
RTRIM  ({t_source | d_source}, t_char_set)  ‑‑>
      $t_source_with_all_rightmost_char_set_chars_removed  
SUBSTR  ({t_source | d_source}, i_start_pos, i_len)  ‑‑>
      $t_len_chars_from_source_starting_at_pos  
TO_CHAR  (n_num)  ‑‑> $t_digits  
TOHEX +8.3.1(b_source)  ‑‑> $t_uppercase_hex_string  
TO_NUMBER  (t_digits)  ‑‑> #f_num  
TRANSLATE  ({t_source | d_source}, t_orig, t_repl)  ‑‑>
      $t_source_with_each_orig_char_replaced_with_corresponding_repl_char  
UPPER  ({t_source | d_source})  ‑‑> $t_upper_cased_source  
WRAPDEPTH +4.1(t_src_txt, n_wide, n_height, t_on_chars, t_strip_chars)  ‑‑>
      $n_lines_needed_to_print  
ADDITIONAL DOUBLE-BYTE VERSION STRING FUNCTIONS +4.2
ASCIIC  ({t_str | d_str})  ‑‑> #i_ascii_val_of_first_char_(not_byte)_in_str
INSTRB  ({t_source | d_source}, t_str, i_start_atbyteoffset)  ‑‑>
      #i_byte_position_of_str_in_source_or_0  
LENGTHB  ({t_source | d_source})  ‑‑> #i_num_of_bytes_in_source
SUBSTRB  ({t_source | d_source}, i_start_byte, i_byte_len)  ‑‑>
      $t_len_bytes_from_source_starting_at_byte_pos  
TO_MULTI_BYTE  ({t_source | d_source})  ‑‑> $t_source_multi_byte_converted
TO_SINGLE_BYTE  ({t_source | d_source})  ‑‑> $t_source_single_byte_converted
UNICODE STRING FUNCTIONS +6.1.3  (requires UseUnicodeInternal=True)
LENGTHP({t_source | d_source})  ‑‑> #i_print_positions__half-width_chars_=_1_&_full-width_=_2
LENGTHT({t_source | d_source}, t_encoding)  ‑‑> #i_bytes_in_source_when_converted_to_encoding
SUBSTRP({t_source | d_source}, i_start_pos, i_len)  ‑‑>
      $t_len_print_positions_from_source_starting_at_pos__if_middle_of_full-width_start_rounded_up_&_len_rounded_down
SUBSTRT({t_source | d_source}, i_start_pos, i_len, t_encoding)  ‑‑>
      $t_len_bytes_from_source_converted_to_encoding_starting_at_pos_partial_chars_removed
TRANSFORM({t_source | d_source}, t_transform_code)  ‑‑>      $t_source_in_unicode_based_on_transform_code
Supported Transform Codes:
ToLowercase, ToUppercase, ToFullwidth, ToHalfwidth, ToHiragana, ToParagraphSeparator, ToKatakana, Decompose, Compose, ToCombiningMark, ToSpacingMark, ToLineSeparator, ToCanonical  *8.0 , ToTraditionalChinese  *8.0 , ToSimplifiedChinese  *8.0 , RomajiToHiragana, RomajiToKatakana, KanaToRomaji, KanaToKunrieRomaji, KanaToHebonRomaji, ToLatinNumber, HankakuKatakanaToZenkaku, ZenkakuKatakanaToHankaku
UNICODE({t_source_big-endian_hexidecimal_values})  ‑‑> $t_unicoded
DATE FUNCTIONS +4.0
("unit" is YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, or SECOND.)
 
DATEADD({$d_source | &d_source}, t_unit, n_amount)  ‑‑>
      $d_source_with_amount_units_added
DATEDIFF({$d_source2 | &d_source2}, {$d_source1 | &d_source1}, t_unit)  ‑‑>
      #n_source2_minus_source1_in_units
DATENOW()  ‑‑> $d_current_from_client_machine
DATETOSTR({$d_source | &d_source} [, t_edit_mask])  ‑‑> $t_source_formatted_with_mask
STRTODATE(t_source [, t_edit_mask])  ‑‑> $d_source_as_date


PRINT Format Commands

BACKGROUND +6.0 = (rgb | t_color_name)
BOLD +2.20
BOX +2.20
BOX-FILL-COLOR +9.0.1 = (rgb | t_color_name)
BOX-LINE-COLOR +9.0.1 = (rgb | t_color_name)
CENTER  
CENTER-WITHIN +9.3 = n_nmbr_of_characters
CODE +2.20, *  (alternative: Code-Printer)
CODE-PRINTER +3.0 = {LINEPRINTER | POSTSCRIPT | HPLASERJET | HTML +4.0 | LP | PS | HP | HT +4.0}
DATE +4.0
DELAY +6.0
EDIT edit_mask
Text Mask Characters =
X | B | ~ | R[n]
Numeric Mask Characters =
+3.0 | 9 | 0 | $ | B | E | V +3.0 | . | ,
Numeric Mask Suffix Characters =
+3.0 | MI | PR | PS | PF | NA | NU
Date Mask Characters +3.0, ‑4.0 (any except Oracle and SQLBase) =
YY | YYYY | MM | MON | MONTH | DD | HH | MI | SS | PM  (SYBASE and SQLBase) | GG  (RDB) | NNNNN  (DB2) |
NOTE: the vertical bar character "|" can be used to separate date mask components without being displayed. Dates must be in the proper DATE-TIME format
Date Mask Characters +4.0 =
Y | YY | YYY | YYYY | SYYYY | RR | CC | SCC | BC | AD | Q | RM | WW | W | DDD | DD | D | DAY | DY | J | AM | PM | HH | HH12 | HH24 | SSSSS | N | NN | NNN | NNNN | NNNNN | NNNNNN | MONTH | MON | MM | MI | SS
NOTE: the vertical bar character "|" can be used to separate date mask components without being displayed. The backslash character "\" forces the character after it into the output
Additional Double-Byte Date Mask Characters +4.2 =
ER | EY
(see also Text Mask Table, Numeric Mask Table, Date Mask Table)
FILL  
FONT +6.0 = n_font_number
FOREGROUND +6.0 = (rgb | t_color_name)
ITALIC +9.3
MATCH {match_text  i_line  i_column  print_text} ...  
MONEY +4.0
NOP  
NUMBER +4.0
ON-BREAK
[PRINT= {ALWAYS | CHANGE | CHANGE/TOP-PAGE | NEVER}]
[SKIPLINES= i]
[AFTER= procedure_name]
[BEFORE= procedure_name]
[SAVE= $t]
[LEVEL= £i]
[SET= £i]
[PROCEDURE= procedure_name (for compatibility)]  
POINT-SIZE +6.0 = n_points
SHADE +2.20
UNDERLINE +2.20
URL +6.0 = t_url_string
URL-TARGET +8.0.2 = t_url_target_name
WRAP
i_line_length  i_max_lines [KEEP-TOP] +2.13 [STRIP= strip_chars] [ON= break_chars] [R] [LINE-HEIGHT= i] +4.0


COMPILER DIRECTIVES

#DEBUG[x...+3.0  SQR_command
#DEFINE  substitution_variable value
#ELSE
#END-IF
#IF  substitution_variable {=!=<><><=>=} {£t | £n}
#IFDEF  substitution_variable
#IFNDEF  substitution_variable
#INCLUDE  file_name


CHARACTER SET ENCODINGS +4.2

CHARACTER SET ENCODINGS WITHOUT UNICODE INTERNAL +4.2

SQR Names Encoding
ASCII ASCII
EBCDIC +5.1 EBCDIC
EBCDIK290 +5.1 EBCDIK290
EBCDIK1027 +5.1 EBCDIK1027
JEUC EUC-J
SJIS Shift-JIS
UCS-2 +5.1 UCS-2
UTF-8 +5.1 UTF-8

 

VALID CHARACTER SET COMBINATIONS WITHOUT UNICODE INTERNAL +4.2

 Encoding-File-Input   Encoding-Database   Encoding-File-Output   Encoding-Report-Output 
 ASCII  ASCII  ASCII  ASCII
 ASCII  ASCII  ASCII  Shift-JIS
 ASCII  ASCII  ASCII  JEUC
 ASCII  ASCII  ASCII  UTF-8/UCS-2
 ASCII  Shift-JIS  ASCII  ASCII
 ASCII  Shift-JIS  ASCII  Shift-JIS
 ASCII  Shift-JIS  Shift-JIS  Shift-JIS
 ASCII  JEUC  ASCII  ASCII
 ASCII  JEUC  ASCII  JEUC
 ASCII  JEUC  JEUC  JEUC
 ASCII  UTF-8/UCS-2  ASCII  ASCII
 ASCII  UTF-8/UCS-2  ASCII  UTF-8/UCS-2
 ASCII  UTF-8/UCS-2  UTF-8/UCS-2  UTF-8/UCS-2
 EBCDIC  EBCDIC  EBCDIC  EBCDIC
 EBCDIC  EBCDIC  EBCDIC  EBCDIK290 or 1027
 EBCDIC  EBCDIK290 or 1027   EBCDIC  EBCDIC
 EBCDIC  EBCDIK290 or 1027  EBCDIC  EBCDIK290 or 1027
 EBCDIC  EBCDIK290 or 1027  EBCDIK290 or 1027  EBCDIK290 or 1027
 EBCDIK290 or 1027  EBCDIK290 or 1027  EBCDIC  EBCDIK290 or 1027
 EBCDIK290 or 1027  EBCDIK290 or 1027  EBCDIK290 or 1027  EBCDIK290 or 1027
 Shift-JIS  Shift-JIS  ASCII  Shift-JIS
 Shift-JIS  Shift-JIS  Shift-JIS  Shift-JIS
 JEUC  JEUC  ASCII  JEUC
 JEUC  JEUC  JEUC  JEUC
 UTF-8/UCS-2  UTF-8/UCS-2  ASCII  UTF-8/UCS-2
 UTF-8/UCS-2  UTF-8/UCS-2  UTF-8/UCS-2  UTF-8/UCS-2

 

CHARACTER SET ENCODINGS WITH UNICODE INTERNAL +6.1.3

SQR Names Encoding Character
Set
Known Also As Vendor /
 Standards Body 
CP10004 CP10004 Arabic Macintosh Arabic Microsoft & IBM
CP1256 CP1256 Arabic   Microsoft & IBM
CP20420 CP20420 Arabic (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP28596 CP28596 Arabic ArabicAlphabet (ISO) Microsoft & IBM
CP720 CP720 Arabic Transparent ASMO Microsoft & IBM
CP864 CP864 Arabic   Microsoft & IBM
Arabic ISO 8859-6 Arabic ISOLatinArabic International or
National Standard
CP708 CP708 Arabic ASMO708 Microsoft & IBM
CP1257 CP1257 Baltic   Microsoft & IBM
CP28594 CP28594 Baltic Baltic Alphabet (ISO) Microsoft & IBM
CP775 CP775 Baltic   Microsoft & IBM
Latin4
ISO-8859-4
ISO 8859-4 Baltic Latin4 International or
National Standard
Latin7  +8.0
ISO-8859-13  +8.0
ISO 8859-13 Baltic Latin7 International or
National Standard
ISO-8859-14 ISO 8859-14 Celtic Latin8 International or
National Standard
ISO-2022-CN  +8.0 ISO 2022-CN Chinese   International or
National Standard
GB18030  +8.0 GB18030 Chinese   International or
National Standard
Big5-HKSCS  +8.2 HKSCS Chinese Big5-HKSCS International or
National Standard
GB2312  ‑8.0 EUC-CN Chinese,
Simplified
GB2312, EUC-SC Unix
GB2312
EUC-CN  +8.0
GB2312 Chinese,
Simplified
EUC-CN, EUC-SC International or
National Standard
HZ HZ-GB-2312 Chinese,
Simplified
HZ-GB-2312 International or
National Standard
CP936 CP936 Chinese,
Simplified
GBK Microsoft & IBM
CNS-11643-1986 CNS-11643-1986 Chinese,
Traditional
EUC-TW International or
National Standard
CNS-11643-1992 CNS-11643-1992 Chinese,
Traditional
EUC-TW International or
National Standard
CNS-11643-1992 EUC-TW Chinese,
Traditional
CNS-11643-1986,
CNS-11643-1992
Unix
GB12345 GB12345 Chinese,
Traditional
  International or
National Standard
Big5 Big5 Chinese,
Traditional
  International or
National Standard
BIG5+  +8.0 BIG5+ Chinese,
Traditional
  International or
National Standard
CP10002 CP10002 Chinese,
Traditional
Macintosh
Traditional Chinese
Microsoft & IBM
CP950 CP950 Chinese,
Traditional
  Microsoft & IBM
CP10007 CP10007 Cyrillic Macintosh Cyrillic Microsoft & IBM
CP1251 CP1251 Cyrillic MS Windows
Cyrillic (Slavic)
Microsoft & IBM
CP20866 CP20866 Cyrillic Cyrillic Alphabet,
KOI8-R
Microsoft & IBM
CP20880 CP20880 Cyrillic (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP21025 CP21025 Cyrillic (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP21866 CP21866 Cyrillic Ukranian KOI8-RU Microsoft & IBM
CP28595 CP28595 Cyrillic Cyrillic Alphabet (ISO) Microsoft & IBM
CP855 CP855 Cyrillic IBM Cyrillic Microsoft & IBM
CP866 CP866 Cyrillic MS DOS Russian Microsoft & IBM
ISOLatinCyrillic ISO 8859-5 Cyrillic ISOLatinCyrillic International or
National Standard
CP10006 CP10006 Greek Macintosh Greek 1 Microsoft & IBM
CP1253 CP1253 Greek   Microsoft & IBM
CP20423 CP20423 Greek (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP28597 CP28597 Greek Greek Alphabet (ISO) Microsoft & IBM
CP737 CP737 Greek   Microsoft & IBM
CP869 CP869 Greek IBM Modern Greek Microsoft & IBM
Greek ISO 8859-7 Greek ISOLatinGreek International or
National Standard
CP10010 CP10010 Gurmukhi Macintosh Gurmukhi Microsoft & IBM
CP10005 CP10005 Hebrew Macintosh Hebrew Microsoft & IBM
CP1255 CP1255 Hebrew   Microsoft & IBM
CP28598 CP28598 Hebrew Hebrew Alphabet (ISO) Microsoft & IBM
CP38598 CP38598 Hebrew ASCII + Hebrew and
private use characters
Microsoft & IBM
CP862 CP862 Hebrew   Microsoft & IBM
Hebrew ISO 8859-8 Hebrew ISOLatinHebrew International or
National Standard
CP10079 CP10079 Icelandic Macintosh Icelandic Microsoft & IBM
CP861 CP861 Icelandic MS DOS Icelandic Microsoft & IBM
CCSID-1027
EBCDIK1027
CCSID 1027 Japanese EBCDIK Microsoft & IBM
CCSID-290
EBCDIK290
CCSID 290 Japanese EBCDIK Microsoft & IBM
CCSID-942 CCSID 942 Japanese   Microsoft & IBM
CP10001 CP10001 Japanese Macintosh Japanese Microsoft & IBM
CP20290 CP20290 Japanese (full/half width Latin &
half-width kata-kana)
Microsoft & IBM
CP21027 CP21027 Japanese (halfwidth Latin,
halfwidth katakana
& private use)
Microsoft & IBM
CP932 CP932 Japanese   Microsoft & IBM
EUC-J
JEUC
EUC-JP Japanese   Unix
EUC-JP-JISROMAN  +8.0 EUC-JP-JISROMAN Japanese   Unix
ISO-2022-JP ISO-2022-JP Japanese   International or
National Standard
JIS_X_0201
IBM897  +8.0
JIS_X_0201 Japanese HalfWidthKatakana International or
National Standard
JIS_X_0208 JIS_X_0208 Japanese   International or
National Standard
Shift-JIS
SJIS
Shift-JIS Japanese MS_Kanji Microsoft & IBM
CP10003 CP10003 Korean Macintosh Korean Microsoft & IBM
CP1361 CP1361 Korean Korean Johab
(based on KSC 5861-1992)
Microsoft & IBM
CP949 CP949 Korean   Microsoft & IBM
EUC-KR
EUC-K
EUC-KR Korean KS_C_5861-1992 Unix
ISO-2022-KR ISO-2022-KR Korean KS_C_5601-1987 International or
National Standard
Johab Johab Korean   International or
National Standard
CP10000 CP10000 Latin Macintosh Roman Microsoft & IBM
CP10029 CP10029 Latin Macintosh Latin2 Microsoft & IBM
CP10082 CP10082 Latin (with mathematical
symbols)
Microsoft & IBM
CCSID1047 CCSID1047 Latin EBCDIC (for IBM Open
Systems platform)
Microsoft & IBM
CP20261 CP20261 Latin (with private
use characters)
Microsoft & IBM
CP20269 CP20269 Latin   Microsoft & IBM
CP20273 CP20273 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20277 CP20277 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20278 CP20278 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20280 CP20280 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20284 CP20284 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20285 CP20285 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20297 CP20297 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20833 CP20833 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP20871 CP20871 Latin (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP28591 CP28591 Latin ASCII + Latin
accented vowels
Microsoft & IBM
CP28593 CP28593 Latin Latin 3 Alphabet (ISO) Microsoft & IBM
CP850 CP850 Latin MS DOS Multilingual,
MS-DOS Latin1
Microsoft & IBM
CP870 CP870 Latin (with fullwidth
punctuation)
Microsoft & IBM
HP-ROMAN8  +8.2 HP-ROMAN8 Latin csHPRoman8,
r8,
roman8
Microsoft & IBM
Latin1
ISO-8859-1
ISO 8859-1 Latin Latin1 International or
National Standard
ISO-8859-15 ISO 8859-15 Latin Latin1 + Euro symbol
& accented characters
International or
National Standard
Latin2
ISO-8859-2
ISO 8859-2 Latin Latin2 International or
National Standard
UTF8-EBCDIC UTF8-EBCDIC Latin   Unicode
CP863 CP863 Latin,
Canadian French
MS DOS
Canadian French
Microsoft & IBM
CP28592 CP28592 Latin,
Central European
Central European
Alphabet (ISO)
Microsoft & IBM
CP1250 CP1250 Latin,
Eastern European
  Microsoft & IBM
CP20905 CP20905 Latin,
Esperanto
(with fullwidth
Latin & punctuation)
Microsoft & IBM
CP860 CP860 Latin,
Portugese
MS DOS Portugese Microsoft & IBM
Latin3
ISO-8859-3
ISO 8859-3 Latin, South-
East European
Latin3 International or
National Standard
ASCII
ANSI
ASCII Latin,
US English
US-ASCII
CP367
International or
National Standard
CP037 CP037 Latin,
US English
EBCDIC Microsoft & IBM
CP1026 CP1026 Latin,
US English
EBCDIC Microsoft & IBM
CP1252 CP1252 Latin,
US English
MS Windows
Latin1 (ANSI)
Microsoft & IBM
CP20105 CP20105 Latin,
US English
US ASCII Microsoft & IBM
CP437 CP437 Latin,
US English
MS-DOS Latin US Microsoft & IBM
CP500 CP500 Latin,
US English
EBCDIC Microsoft & IBM
CP875 CP875 Latin,
US English
EBCDIC Microsoft & IBM
CP10017 CP10017 Malayalam Macintosh Malayalam Microsoft & IBM
CP865 CP865 Nordic MS DOS Nordic Microsoft & IBM
Latin6
ISO-8859-10
ISO 8859-10 Nordic Latin6 International or
National Standard
CP852 CP852 Slavic MS DOS Slavic Microsoft & IBM
Adobe-Symbol-Encoding Adobe-Symbol-
Encoding
Symbol (used in PS printers) Adobe
CP10008 CP10008 Symbol Macintosh RSymbol
(Right-left symbol)
Microsoft & IBM
CP20838 CP20838 Thai (with fullwidth
Latin & punctuation)
Microsoft & IBM
CP874 CP874 Thai IBMThai Microsoft & IBM
Thai ISO 8859-11(draft) Thai ISOLatinThai International or
National Standard
CP10081 CP10081 Turkish Macintosh Turkish Microsoft & IBM
CP1254 CP1254 Turkish   Microsoft & IBM
CP28599 CP28599 Turkish Turkish (ISO) Microsoft & IBM
CP857 CP857 Turkish IBM Turkish Microsoft & IBM
Latin5
ISO-8859-9
ISO 8859-9 Turkish Latin5 International or
National Standard
BMP BMP Unicode   Unicode
Java Java Unicode (way of representing
Unicode chars in ASCII)
Sun
UCS2 UCS2 Unicode ISO-10646-UCS2, UTF16 Unicode
big-endian Unicode
Big-endian
Unicode   Unicode
little-endian Unicode
Little-endian
Unicode   Unicode
UTF7 UTF7 Unicode   Unicode
UTF8 UTF8 Unicode   Unicode
UTF8-EBCDIC UTF8-EBCDIC Unicode   Unicode
CP1258 CP1258 Vietnamese   Microsoft & IBM

 


CHART ATTRIBUTES +8.2

VALID ATTRIBUTE COMBINATIONS +8.2

 SELECTORS  SUB-SELECTORS   DECLARATIONS
 ALL  
 CHART1  
 CHART2  
 none    3D‑DEPTH  
 3D‑ELEVATION  
 3D‑ROTATION  
 BACKGROUND  
 CLUSTER‑OVERLAP  
 CLUSTER‑WIDTH  
 FONT  
 FONT‑STYLE  
 FOREGROUND  
 HALF-RANGE +9.3
 HOLE‑VALUE +8.3
 LABEL‑LOCATION +9.0.1
 LEGEND‑COLUMNS +9.0.1
 LEGEND‑ROWS +9.0.1
 ORIGIN-BASE-ANGLE +9.3
 OTHER-LABEL +9.0.1
 PERCENTAGE‑PRECISION +9.0.1
 POINT‑SIZE  
 SORT‑ORDER  
 START‑ANGLE  
 THRESHOLD‑METHOD  
 THRESHOLD‑VALUE  
 UNITS +9.3
 MARKER  
 LABEL  
 FONT  
 FONT‑STYLE  
 FOREGROUND  
 LINE  
 SYMBOL  
 HILO‑LINE +9.3
 OUTLINE +9.3
 COLOR  
 SIZE  
 STYLE  
 GRID  
 FALLING‑FILL +9.3
 RISING‑FILL +9.3
 COLOR  
 PATTERN +9.3
 SIZE  
 Fill-Table    COLOR  
 STYLE  
 OTHER +9.0.1
 GRADIENT +9.3
 COLOR  
 ALL‑AXIS  
 X‑AXIS  
 Y‑AXIS  
 Y2‑AXIS  
 none  
 MARKER  
 LABEL  
 FONT  
 FONT‑STYLE  
 FOREGROUND  
 POINT‑SIZE  
 CHART‑AREA  
 PLOT‑AREA  
 none    BACKGROUND  
 FONT  
 FONT‑STYLE  
 FOREGROUND  
 POINT‑SIZE  
 HEADER  
 FOOTER  
 LEGEND  
 none    BACKGROUND  
 FONT  
 FONT‑STYLE  
 FOREGROUND  
 LOCATION  
 POINT‑SIZE  
 LEGEND  
 LEGEND‑SYMBOL +9.3
 OUTLINE +9.3  COLOR  
 SIZE  
 STYLE  
 TITLE  
 SUBTITLE  
 FOOTER‑TEXT  
 SUB‑FOOTER‑TEXT  
 LEGEND‑TITLE  
 none    FONT  
 FONT‑STYLE  
 FOREGROUND  
 POINT‑SIZE  

 

DECLARATION VALUES +8.2

DECLARATION CHART TYPE SELECTOR SUB-SELECTOR VALUE
3D-DEPTH       0 to 100 (default 10)
3D-ELEVATION       0 to 180 (default 45)
3D-ROTATION       0 to 90 (default 40)
BACKGROUND       (rgb) | (t_color_name) (default Transparent)
CLUSTER-OVERLAP BAR types     -100 to 100 (default 0)
CLUSTER-WIDTH BAR types     0 to 100 (default 80)
COLOR       (rgb) | (t_color_name) | LIST: ... | PALETTE: ...
PIE   OTHER+9.0.1 (rgb) | (t_color_name)
    GRADIENT+9.3 (rgb) | (t_color_name)
FONT       Font number (default 3 - Times New Roman)
FONT-STYLE       PLAIN | BOLD | ITALIC | UNDERLINE+9.0.1
(multiple values are space separated)
FOREGROUND       (rgb) | (t_color_name) (default Black)
 HALF‑RANGE +9.3 POLAR     NO | YES 
 HOLE-VALUE +8.3       -1.7976931348623157E+308 to 1.7976931348623157E+308
(no default, only 1 value per chart)
 LABEL‑LOCATION +9.0.1       AUTO | INNER | OUTER 
 LEGEND‑COLUMNS +9.0.1       Any number of columns (default 0 = "auto")
 LEGEND‑ROWS +9.0.1       Any number of rows (default 0 = "auto")
LOCATION   LEGEND   CENTER-RIGHT | CENTER-LEFT |
UPPER-RIGHT | UPPER-LEFT | UPPER-CENTER |
LOWER-RIGHT | LOWER-LEFT | LOWER-CENTER |
(x_pixel,y_pixel)
  HEADER
FOOTER
  (x_pixel,y_pixel)
 ORIGIN‑BASE‑ANGLE +9.3 POLAR
RADAR
AREA‑RADAR
    0 to 360 (default 0)
 OTHER‑LABEL +9.0.1 PIE     Any text (default "Other")
 PATTERN +9.3 RADAR
AREA‑RADAR
    CIRCULAR | WEBBED
 PERCENTAGE‑PRECISION +9.0.1        0 to 15 (default 2)
POINT-SIZE       Any point size (default 12)
SIZE     LINE
GRID
1 to 10 pixels (default 1)
    SYMBOL 1 to 100 pixels (default 6)
CANDLE‑STICK+9.3   FALLING‑FILL
RISING‑FILL
1 to ?? pixels (default ?)
CANDLE‑STICK+9.3
HIGH‑LOW‑CLOSE
  HILO‑LINE+9.3 1 to 10 pixels (default 1)
    OUTLINE 1 to 10 pixels (default 1)
 SORT-ORDER  PIE     DATAORDER | LARGEST | SMALLEST
 START-ANGLE  PIE      0 to 359 (default 135 degrees)‑9.0
0 to 359 (default 90 degrees)+9.0
POLAR+9.3
RADAR+9.3
AREA‑RADAR+9.3
    0 to 359 (default 0 degrees)
 STYLE      FILL LIST: ...
Solid | None | 25Per | 50Per | 75Per |
HorizontalStripe | VerticalStripe | 45Stripe | 135Stripe |
DiagonalHatch | CrossHatch
    LINE LIST: ...
Solid | LongDash | ShortDash | LongShort | DashDot
    SYMBOL LIST: ...
Dot | None | Box | Diamond | Star | Cross | Circle |
Square | Triangle | VerticalLine | HorizontalLine
 THRESHOLD-METHOD  PIE     VALUE | PERCENT
 THRESHOLD-VALUE  PIE     >= 0 if THRESHOLD-METHOD is VALUE
0 to 100 if THRESHOLD-METHOD is PERCENT
(default 0)
 UNITS +9.3 POLAR
RADAR
AREA‑RADAR
    DEGREES | RADIANS | GRADS

 


CREATE-TABLE AND DECLARE-TABLE ATTRIBUTES +11.1.1

TABLE ATTRIBUTES +11.1.1

 ATTRIBUTE  DESCRIPTION 
 BORDER‑COLOR   Color name or rgb (default=NONE) 
 BORDER‑LINE‑STYLE   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 BORDER‑THICKNESS   Border thickness in decipoints (default=2) 
 DEFAULT   Rests any DECLARE‑TABLE table attributes to defaults before applying CREATE‑TABLE table attributes (CREATE‑TABLE only
 FILL‑COLOR   Color name or rgb (default=NONE) 
 LEADING   Leading in decipoints (default=0) 

 

ROW ATTRIBUTES +11.1.1

 ATTRIBUTE  DESCRIPTION 
 BORDER‑COLOR   Color name or rgb (default=NONE) 
 BORDER‑LINE‑STYLE   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 BORDER‑THICKNESS   Border thickness in decipoints (default=2) 
 DEFAULT   Rests any DECLARE‑TABLE row attributes to defaults before applying CREATE‑TABLE row attributes (CREATE‑TABLE only
 FILL‑COLOR   Color name or rgb (default=NONE) 
 HEIGHT   Number of lines between each printed row (default=1) 
 LINE‑COLOR   Color name or rgb (default=NONE) 
 LINE‑STYLE   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 LINE‑THICKNESS   Line thickness in decipoints (default=2) 

 

COLUMN ATTRIBUTES +11.1.1

 ATTRIBUTE  DESCRIPTION 
 BACKGROUND   Color name or rgb (default=NONE) 
 BOLD   NO | YES 
 CENTER   NO | YES 
 DEFAULT   Rests any DECLARE‑TABLE column attributes to defaults before applying CREATE‑TABLE column attributes (CREATE‑TABLE only
 FILL‑COLOR   Color name or rgb (default=NONE) 
 FONT   Font number 
 FOREGROUND   Color name or rgb (default=NONE) 
 ITALIC   NO | YES 
 LEADING   Leading in decipoints (default=0) 
 LINE‑COLOR   Color name or rgb (default=NONE) 
 LINE‑STYLE   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 LINE‑THICKNESS   Line thickness in decipoints (default=2) 
 POINT‑SIZE   Point size 
 UNDERLINE   NO | YES 
 WIDTH   Width in coordinate units 
 WRAP   NO | YES | Max_Number_Of_Wrap_Lines 
 WRAP‑HEIGHT   Number of lines between each wrapped line (default=1) 
 WRAP‑ON   Characters which force a wrap (default=none) 
 WRAP‑STRIP   Characters to replace with a space pre‑wrap (default=none) 

 

ALTER-TABLE AND FILL-TABLE ATTRIBUTES +11.1.1

 ATTRIBUTE  COMMAND   DESCRIPTION 
 ANNOTATION   Fill-Table   Text string associated to this location 
 Passed (unvalidated) to the backend print driver
 BACKGROUND   Both   Color name or rgb (default=NONE) 
 BOLD   Both   NO | YES 
 CENTER   Both   NO | YES 
 COLUMN‑LEADING   Both   Leading in decipoints (default=0) 
 COLUMN‑LINE‑COLOR   Both   Color name or rgb (default=NONE) 
 COLUMN‑LINE‑STYLE   Both   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 COLUMN‑LINE‑THICKNESS   Both   Line thickness in decipoints (default=2) 
 DEFAULT   Alter-Table   Rests any DECLARE‑TABLE OR CREATE‑TABLE attributes to defaults before applying ALTER‑TABLE column attributes 
 EDIT‑MASK   Fill-Table   Edit mask or keyword 
 FILL‑COLOR   Both   Color name or rgb (default=NONE) 
 FONT   Both   Font number 
 FOREGROUND   Both   Color name or rgb (default=NONE) 
 FORMULAE   Fill-Table   Formulae associated with this location 
 Passed (unvalidated) to the backend print driver
 GROUP‑FOOTER   Alter-Table   YES | NO 
 GROUP‑HEADER   Alter-Table   YES | NO 
 HEADER   Alter-Table   YES | NO 
 ITALIC   Both   NO | YES 
 POINT‑SIZE   Both   Point size 
 ROW‑BORDER‑COLOR   Alter-Table   Color name or rgb (default=NONE) 
 ROW‑BORDER‑LINE‑STYLE   Alter-Table   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 ROW‑BORDER‑THICKNESS   Alter-Table   Border thickness in decipoints (default=2) 
 ROW‑LINE‑COLOR   Both   Color name or rgb (default=NONE) 
 ROW‑LINE‑STYLE   Both   SOLID | SQUARE‑DOT | DASH | DASH‑DOT | LONG‑DASH | LONG‑DASH‑DOT | LONG‑DASH‑DOT‑DOT 
 ROW‑LINE‑THICKNESS   Both   Line thickness in decipoints (default=2) 
 UNDERLINE   Both   NO | YES 
 URL   Fill-Table   Hypertext link (unvalidated) for this location 
 URL‑TARGET   Fill-Table   URL target (unvalidated) for this location 
 WRAP   Both   NO | YES | Max_Number_Of_Wrap_Lines 
 WRAP‑HEIGHT   Both   Number of lines between each wrapped line (default=1) 
 WRAP‑ON   Both   Characters which force a wrap (default=none) 
 WRAP‑STRIP   Both   Characters to replace with a space pre‑wrap (default=none) 

 


TABLES

Common HP Symbol Sets +2.20

 CODE  Symbol Set
0U ASCII
17U PC-852
10U PC-8
12U PC-850
8U HP Roman-8
7J DeskTop
19U Windows 3.1 Latin 1 
0N ISO 8859/1 Latin 1
9E Windows 3.1 Latin 2
2N ISO 8859/2 Latin 2
5T Windows 3.1 Latin 5
5N ISO 8859/9 Latin 5
10J PS Text
12J MC Text
13J Ventura International
14J Ventura US
1U Legal
6J  Microsoft ® Publishing 
15U Pi-Font
6M Ventura Math
5M PS Math
8M Math-8
579L Wingdings Font
19M Symbol

 

Font Numbers +2.20

HP LASERJET FONTS
 No.  Typeface Style
 Line Printer Fixed
 Pica Fixed
 Elite Fixed
 Courier Fixed
 Helvetica Proportional 
 Times Roman Proportional
 Letter Gothic Fixed
 Prestige Fixed
11   Presentations  Fixed
17   Optima Proportional 
18   Garamondi Proportional
19   Cooper Black Proportional
20   Coronet Bold Proportional
21   Broadway Proportional
22   Bauer Bodini Black Condensed  Proportional
23   Century Schoolbook Proportional
24   University Roman Proportional

 

POSTSCRIPT FONTS
 No.  Typeface  Bold 
 CourierY
 HelveticaY
 Times RomanY
 Avante Garde Book 
 Palatino RomanY
11   Symbol 
12   Zapf Dingbats 
17   Zapf Chancery Medium Italic 
18   Bookman Light 
23   New Century Schoolbook Roman Y
30   Courier ObliqueY
31   Helvetica ObliqueY
32   Times ItalicY
33   Avante Garde Demi 
34   Avante Garde Book Oblique 
35   Avante Garde Demi Oblique 
36   Palitino ObliqueY
37   New Century Schoolbook Italic Y
38   Helvetica NarrowY
39   Helvetica Narrow ObliqueY
40   Bookman Demi 
41   Bookman Light Italic 
42   Bookman Demi Italic 

 

WINDOWS FONTS
  No.  Typeface Style
 Courier New Fixed
 Arial Proportional 
 Times New Roman  Proportional
1  AvantGarde Proportional
1  Palatino Proportional
11   Symbol Proportional
300   Courier New Fixed Bold 
400   Arial Proportional Bold 
500   Times New Roman  Proportional Bold
1800   Palatino Proportional Bold
1Note: Fonts 6, 8, and 800 are in the ADOBE type Manager (ATM) and not included with Windows.

 

Non-Roman PDF Fonts +6.1.4

Language CJK Typeface Character Map Encoding
Supported
 Simplified Chinese  STSong-Light
 STSongStd-Light-Acro +8.2
 GB-EUC-H  GB2312
 GBpc-EUC-H  GB2312
 GBK-EUC-H  CP936
 GBKp-EUC-H +8.2  CP936
 CS_936 +8.2  CP936
 GBK2K-EUC-H +8.2  GB18030
 CS_18030 +8.2  GB18030
 UniGB-UCS2-H  UCS-2
 Traditional Chinese   MHei-Medium
 MSung-Light
 MSung-Std-Light-Acro +8.2
 B5pc-H  Big5
 ETen-B5-H  Big5
 ETenms-B5-H  Big5
 HKscs-B5-H +8.2  Big5
 CS_BIG5 +8.2  Big5
 CNS-EUC-H  EUC-TW
 UniCNS-UCS2-H  UCS-2
 Korean  HYGoThic-Medium
 HYSMyeongJo-Medium 
 HYSMyeongJoStd-Medium-Acro +8.2 
 KSC-EUC-H  EUC-KR
 KSCms-UHC-H  JOHAB
 KSCms-UHC-HW-H   JOHAB
 KSCpc-EUC-H  EUC-KR
 UniKS-UCS2-H  UCS-2
 Japanese  HeiseiKakuGo-W5
 HeiseiMin-W3
 KozMinPro-Regular-Acro +8.2
 83pv-RKSJ-H  Shift-JIS
 90ms-RKSJ-H  Shift-JIS
 90msp-RKSJ-H  Shift-JIS
 90pv-RKSJ-H  Shift-JIS
 Add-RKSJ-H  Shift-JIS
 EUC-H  JEUC
 Ext-RKSJ-H  Shift-JIS
 H  ISO-2022-JP
 UniJIS-UCS2-H  UCS-2
 UniJIS-UCS2-HW-H   UCS-2

 

Text Mask Characters

 Char   Description 
 X  Use character from string value. 
 B  Insert space character. 
 ~  (tilde) Skip character from string value. 
 R[n]   Reverse sequence of string.
Optional number is length of result string (space padded to right justify or left truncated if shorter than length of string). 
Any other character in a text edit mask is treated as a constant and is included in the edited field.
The characters 8, 9, 0, V, and $ are illegal in a text edit mask because they are used to indicate that the mask is for a numeric edit.

 

Numeric Mask Characters

 Char   Description 
 9  Digit. Space fill to the left (right justified).
 8 +3.0  Digit. Remove leading spaces (left justified).
 0  Digit. Zero fill to the left.
 $  Dollar sign/Digit. Optionally floats to the right.
 B  Treated as a "9". If a value is zero, the result string is space filled.
 .  Decimal point.
 V +3.0   Implied decimal point.
 ,  Comma.
 C +3.0  Mask suffix. Transposes the comma and period characters. 
 (Example: 12345.678 with mask "9,999,999.99c" becomes "   12.345,68").
 E  Mask suffix. Scientific format. 
 Decimal places in the mask determine the number of significant digits displayed. 
 The case of "E" matches the case used in the mask.
 MI  Mask suffix. If the number is negative, the minus sign displays at the right of the number.
 PR  Mask suffix. If the number is negative, angle brackets (< >) display around the number.
 PS  Mask suffix. If the number is negative, parentheses display around the number.
 PF  Mask suffix. If the number is negative, floating parentheses display around the number.
 NA  Mask suffix. If the numeric column variable is null, displays "N/A". 
 The case of N/A matches the case used in the mask.
 NU  Mask suffix. If the numeric column variable is null, displays blanks.
Decimal places in any numeric mask are considered significant digits, and are therefore 0 filled.
Characters other than those listed are illegal for numeric edit masks and cause errors during processing.

 

.

Date Mask Characters +3.0

 Char   Description 
 Y +4.0   Last digit of year. 
 On input, the current century and decade are used to calculate the 4-digit year. 
 Example: a "7" input in the 2110s would result in 2117 as the year. 
 YY    Last 2 digits of year. 
 On input, the current century is used to calculate the 4-digit year.. 
 Example: a "23" input in the 2100s would result in 2123 as the year. 
 YYY +4.0   Last 3 digits of year. 
 On input, the current millennium is used to calculate the 4-digit year.. 
 Example: a "341" input in the 2000s would result in 2341 as the year. 
 YYYY    4 digit year. 
 SYYYY +4.0   4 digit year, BC dates prefixed with "-". 
 RR +4.0   Last 2 digits of year; for years in other centuries. 
 CC +4.0   Century. 
 SCC +4.0   Century. BC dates prefixed with "-". 
 AD +4.0   BC/AD indicator. 
 BC +4.0   BC/AD indicator. 
 ER +4.0   Japanese Imperial Era. 
 Returns the name of the of the Japanese Imperial Era in the appropriate kanji 
 ("Heisei" is the current era). 
 EY +4.0   Year of the Japanese Imperial Era. 
 Returns the current year within the Japanese Imperial Era. 
 The common Japanese date format is: "YYYY<nen>MM<gatsu>DD<nichi>" 
 (<nen>, <gatsu>, and <nichi> represent the kanji strings for year, month, and day) 
 Q +4.0   Quarter of year (1,2,3,4; JAN-MAR=1). 
 MONTH    Name of month. 
 MON    Abbreviated name of month. 
 MM    Month (01-12). 
 RM +4.0   Roman numeral month (I-XII). 
 WW +4.0   Week of year (1-53). Week 1 starts on the 1st day of the year. 
 W +4.0   Week of the month (1-5). Week 1 starts on the 1st day of the month. 
 DDD +4.0   Day of year (1-366). 
 DD    Day of month (1 - 31). 
 D +4.0   Day of week (1-7). Sunday is first day of week. 
 DAY +4.0   Name of day. 
 DY +4.0   Abbreviated name of day. 
 J +4.0   Julian day; the number of days since Jan 1, 4713 BC. 
 Numbers specified with "J" must be integers. 
 AM +4.0   Meridian indicator. 
 PM    Meridian indicator. (SYBASE and SQLBase only‑4.0 (All+4.0 
 HH    Assumes 24 hour clock unless meridian indicator specified. 
 HH12 +4.0   Hour of day (1-12). 
 HH24 +4.0   Hour of day (0-23). 
 MI    Minute (0-59). 
 SS    Second (0-59). 
 SSSSS +4.0   Seconds past midnight (0-86399). 
 GG ‑4.0  Fractions of a second; centiseconds. (RDB only
 N +4.0   Fractions of a second; deciseconds. 
 NN +4.0   Fractions of a second; centiseconds. 
 NNN +4.0   Fractions of a second; milliseconds. 
 NNNN +4.0   Fractions of a second; 1/10 milliseconds 
 NNNNN +4.0   Fractions of a second; 1/100 milliseconds. 
 NNNNNN   Fractions of a second; microseconds. (DB2 only‑4.0 (All+4.0 
 |  Used to concatenate different masks. 
 \ +4.0   Escapes the character after it. 
  Indicates masks that were not usable for Oracle and Sybase before version 4.0

 

Default DATE-TIME Formats

 Database  Version Format  Column 
Format
Print
 Format 
 ALL  +2.0, -3.0   DD-Mon-YYYY HH:MI PM Y Y
 
 Allbase  +3.0, -4.0  YYYY-MM-DD HH:MI:SS.NNN Y Y
 
 DB2  +3.0, -4.0  YYYY-MM-DD-HH:MI:SS.NNNNNN  Y Y
 +4.0  YYYY-MM-DD-HH:MI:SS.NNNNNN Y  
 +4.0  YYYY-MM-DD-HH:MI   Y
 
 Informix  +3.0, -4.0  YYYY-MM-DD HH:MI:SS.NNNNNN Y Y
 +4.0  YYYY-MM-DD HH:MI:SS.NNN Y  
 +4.0  YYYY-MM-DD HH:MI   Y
 
 Ingres  +3.0, -4.0  DD-MON-YYYY HH:MI:SS Y Y
 +4.0, -6.0  DD-MON-YYYY HH:MI:SS Y  
 +4.0, -6.0  DD-MON-YYYY HH:MI   Y
 
 Oracle  +3.0  DD-Mon-YYYY HH:MI PM Y Y
 
 Rdb  +3.0, -4.0  DD-MON-YYYY HH:MI Y Y
 
 SQLBase  +3.0, -6.0  DD-Mon-YYYY HH:MI PM Y Y
 
 SYBASE  +3.0  DD-MON-YYYY HH:MI Y Y

 

Default Database Date Formats +4.0

Database Date Formats
 DB2  YYYY-MM-DD-HH:MI:SS.NNNNNN
 YYYY-MM-DD
 Informix  YYYY-MM-DD HH:MI:SS.NNN
 MM/DD/YYYY
 MM-DD-YYYY
 MM.DD.YYYY
 Ingres ‑6.0   DD-MON-YYYY HH:MI:SS
 MM/DD/YYYY HH:MI:SS
 MM-DD-YYYY HH:MI:SS
 ODBC  MON DD YYYY HH:MIPM
 Oracle  DD-MON-YY
 Sybase  MON DD YYYY HH:MIPM
 MON DD YYYY [HH:MI[:SS[:NNN]]][PM]
 MON DD YYYY [HH:MI[:SS[.NNN]]][PM]
 YYYYMMDD [HH:MI[:SS[:NNN]]][PM]
 YYYYMMDD [HH:MI[:SS[.NNN]]][PM]
 SQLBase ‑6.0   YYYY-MM-DD-HH.MI.SS.NNNNNN
 YYYY-MM-DD
 HH.MI.SS.NNNNNN
Note: The Database independent format is SYYYYMMDDHH24MISSNNNNNN.
The PRINT, MOVE, DISPLAY, and SHOW commands will use the first format listed if no edit mask is specified.

 

Default Database Date Only Formats +4.2

Database Date Formats
 DB2  YYYY-MM-DD
 Informix  MM/DD/YYYY
 ODBC  DD-MON-YYYY

 

Default Database Time Only Formats +4.2

Database Time Formats
 DB2  HH24:MI:SS
 ODBC  HH24:MI:SS

 

Units Of Measure +4.0

 UOM  Meaning Definition
in cm mm pt dp
dp decipoint  0.001388    0.003526 0.03526  0.1000 1.0000 
pt point  0.01388   0.035260.35260  1.0000 10.0000 
mm millimeter  0.03937   0.1000 1.00000  2.8346 28.3464 
cm centimeter   0.3937   1.0000   10.00000    28.3464    283.4640 
in inch  1.0000   2.540025.40000  72.0000 720.0000 

 

Paper Size Names +4.0

 Name   Orientation  Inches Centimeters Points
 Width   Depth   Width   Depth   Width   Depth 
 Letter   Portrait    8.500    11.000    21.590    27.940    612.00    792.00 
 Legal   Portrait   8.500   14.000   21.590   35.560   612.00   1008.00 
 A4   Portrait   8.262   11.693   21.000   29.700   595.44   841.68 
 A3   Portrait   11.693   16.535   29.700   42.000   841.68   1190.55 
 Executive   Portrait   7.250   10.500   18.415   26.670   522.00   756.00 
 B5   Portrait   7.170   10.120   18.212   25.705   516.24   728.64 
 Com-10   Landscape   4.125   9.500   10.478   24.130   297.00   684.00 
 Monarch   Landscape   3.875   7.500   9.843   19.050   279.00   540.00 
 DL   Landscape   4.330   8.660   10.998   21.996   311.76   623.52 
 C5   Landscape   6.378   9.016   16.200   22.900   459.22   649.15 

 

Input Status

 Value   Indicates
 0  Successful.
 1  Bad type (did not match TYPE parameter).
 2  Too long (longer than MAXLEN or INTEGER out of range). 
 3 +4.0  No arguments remain on the command line in BATCH-MODE

 

Bar Code Types +3.0

Type Description Text
Length
Text
Type*
Checksum
 Recognized 
 %LAST-PAGE% 
 Allowed +9.0.1 
1   UPC-A  11,13, or 16  9    
2   UPC-E 11,13, or 16 9    
3   EAN/JAN-13 12,14, or 17 9    
4   EAN/JAN-8 7,9, or 12 9    
5   3 of 9 (code 39)  1 to 30 ‑8.2  9,X,p Y Y
 1 to 100 +8.2 
6   Extended 3 of 9  1 to 30 ‑8.2   9,X,x,p,c  Y Y
 1 to 100 +8.2 
7   Interleaved 2 of 5   2 to 30 ‑8.2  9 Y Y
 2 to 100 +8.2 
8   Code 128  1 to 30 ‑8.2  9,X,x,p,c   Y
 1 to 100 +8.2 
9   Codabar  1 to 30 ‑8.2  9 Y Y
 1 to 100 +8.2 
10   Zip+4 Postnet 5,9, or 11 9    
11   MSI Plessey  1 to 30 ‑8.2  9 Y Y
 1 to 100 +8.2 
12   Code 93  1 to 30 ‑8.2  9,X,p +4.0 Y
 1 to 100 +8.2 
13   Extended 93  1 to 30 ‑8.2  9,X,x,p +4.0 Y
 1 to 100 +8.2 
14   UCC-128 19 9    
15   HIBC  1 to 30 ‑8.2  9 Y Y
 1 to 100 +8.2 

NOTE: %LAST-PAGE% is a meta-tag allowed in both the TEXT and CAPTION text of a bar code

*Text Type Codes
9  Numbers (0-9)
X  Upper Case Letters (A-Z) 
x  Lower Case Letters (a-z)
p  Punctuation
c  Control Characters

 

-M File Entries  *8.0

Entry Default Max Size Is The Maximum ...
 BREAKS +2.26 100 ‑8.0  64K-1  4  breaks per EVALUATE or IF command.
1024 +8.0
 CURSORS +3.0, ‑6.0 6  60 ‑4.0 -  no. of concurrent database cursors. (SQLBase)
25 +4.0
 DYNAMICARGS +2.26 70 ‑8.0 32K-1  12 ‑3.0   no. of dynamic SQL arguments.
4096 +8.0 14 +3.0
 EXPRESSIONSPACE +2.26  2048 ‑4.0 64K-1 1  byte length for LET temporary string storage.
8192 +4.0 ‑8.0
64K-1 +8.0
 FORWARDREFS +2.26 200 ‑8.0 32K-1 8  no. of &column forward references.
1024 +8.0
 LONGSPACE +3.0 ‑8.0 13515 ‑4.0 32K-2 1  buffer size in bytes to transfer text and image data.
32K-2 +4.0
 NUMVARIABLES ‑4.0 240  32K 8  no. of numeric variables and literals.
 ONBREAKS   30 ‑8.0 64K-1 8  no. of ON-BREAK LEVEL= values per set.
1024 +8.0
 POSITIONS   900 ‑5.1 64K-1 13 ‑3.0  no. of position parameters.
1800 +5.1 ‑8.0 14 +3.0
32K-1 +8.0
 PROGLINEPARS   9000 ‑5.1 64K-1 2  no. of arguments for all program lines. Generally 3 or 4 times the PROGLINES value.
18000 +5.1 ‑8.0
32K-1 +8.0
 PROGLINES   2500 ‑5.1 32K-1 8  no. of program lines (SQR commands).
5000 +5.1 ‑8.0
16K-1 +8.0
 QUERIES   60 ‑8.0 32K-1 60  no. of BEGIN-SQL and BEGIN-SELECT paragraphs. Database dependent and can vary.
1024 +8.0
 QUERYARGS   240 ‑8.0 64K-1 6  no. of arguments (bind vars) for all SQL and SELECT statements. Value must be 1 more than number used.
4096 +8.0
 SQLSIZE   4000 ‑8.0 64K-1 1  length of a SQL statement in characters
16K-1 +8.0
 STRINGSPACE   10000 ‑5.1 64K-1 1  size in bytes of string space for program line arguments.
15000 +5.1 ‑8.0
32K-1 +8.0
 SUBVARS +2.26 100 ‑8.0 32K-1 8  no. of run-time substitution variables.
4096 +8.0
 VARIABLES   750 ‑5.1 32K-1 14 ‑3.0  no. of variables, literals, and database columns.
1500 +5.1 ‑8.0 22 +3.0  (Informix and Ingres ‑6.0)
16K-1 +8.0 20 +3.0  (RDB)
18 +3.0  (Others)
 WHENS +2.26 70 ‑8.0 64K-1 4  no. of WHEN arguments per EVALUATE command.
1024 +8.0
Note: Version 8.0 is deprecating this flag. Still usable, but only to increase a default. Values will increase themselves "on-the-fly" up to the architectural limit

 

Hardcoded Limits

Number Of... Limit
 Arrays (maximum) 20 ‑4.3.2
128 +4.3.2
 Bytes for INPUT buffer 511 ‑4.3.2
 2047 +4.3.2 
 Characters for Call System Using (maximum)  256 ‑4.0
512 +4.0
 Characters for SQR line (maximum)  255 ‑4.0
511 +4.0
 Characters for SQR.INI line (maximum)  512 
 Concurrent Open Cursors (maximum) 30 ‑4.0.2
100 +4.0.2
 Document Markers (maximum) 120 ‑4.3.2
512 +4.3.2
 Document Paragraphs (maximum) 20 ‑4.3.2
128 +4.3.2
 List Elements (maximum) +5.1 2048 ‑5.2
8192 +5.2
 OPEN files (maximum) 12 ‑4.3.2
256 +4.3.2
 PDF pages (maximum)  1000 +4.3.2.2  ‑4.3.3 
5000 +4.3.3
 >5000 but <? +6.2 at least 

 

SQR Return Values

 Non-VMS  VMS Reason
 0  1  Normal exit
 1  0  Error exit
 2  0x2622   Cannot process SQRERR.DAT
 3  0x2632  Command-line flag in error
 4  0x2642  Problem creating SQT file
 5  0x2652  Program did not compile
 6  0x2662  Problem with SQR/SQT file (open/read)
 7  0x2672  Problem with LIS file (create/write)
 8  0x2682  Problem with ERR file (create/write)
 9  0x2692  Problem with LOG file (create/write)
 10  0x26A2  Problem with POSTSCRI.STR file (open/read) 
 11  0x26B2  Cannot call SQR recursively
 12  0x26C2  Problem with Windows
 13  0x26D2  Internal error occurred
 14  0x26E2  Problem with SQRWIN.DLL
 15  0x26F2  Problem with ZCF file

 

Printer and Output File Types and Their Supported Image Types

 Printer Type  SQR Command Option   File Type
 SPF Output  ‑keep  BMP
 Windows Printer  ‑printer:wp  BMP
 PostScript Printer  ‑printer:ps  EPS
 Hewlett-Packard Printer  ‑printer:hp  HPGL
 HTML Output  ‑printer:ht *8.3  GIF, JPEG
 PDF Output  ‑printer:pd  GIF, JPEG, BMP +8.2 , PNG +8.2 
 Enhanced HTML Output  ‑printer:eh  GIF, JPEG, BMP +8.0 , EPS +8.0 , HPGL +8.0 , PNG +8.2 
 Enhanced HTML plus PDF Output   ‑printer:ep  GIF, JPEG, BMP +8.2EPS +8.0HPGL +8.0 , PNG +8.2 

 


HTML PROCEDURES +4.0

NOTES:
The following procedures are found in the file "html.inc which must be included in your program. In order to use any of these procedures, html_on must be called before any others.  You must use the command line flag ‑PRINTER:HT *8.3 and the PrinterHT*8.3 entry in the SQR.INI file must be set to Standard

HTML GENERAL PURPOSE:

HTML_BR(n_repeat_amount, t_line_break_attributes)
HTML_CENTER(t_center_attributes)
HTML_CENTER_END
HTML_HR(t_horizontal_rule_attributes)
HTML_IMG(t_img_attributes)
HTML_NOBR
HTML_NOBR_END
HTML_ON
HTML_P(t_paragraph_attributes)
HTML_P_END
HTML_SET_BODY_ATTRIBUTES(t_body_attributes)
HTML_SET_HEAD_TAGS(t_head_attributes)

HTML HEADINGS:

HTML_H1(t_h1_attributes)
HTML_H1_END
HTML_H2(t_h2_attributes)
HTML_H2_END
HTML_H3(t_h3_attributes)
HTML_H3_END
HTML_H4(t_h4_attributes)
HTML_H4_END
HTML_H5(t_h5_attributes)
HTML_H5_END
HTML_H6(t_h6_attributes)
HTML_H6_END

HTML HIGHLIGHTING:

HTML_BLINK(t_blink_attributes)
HTML_BLINK_END
HTML_CITE(t_cite_attributes)
HTML_CITE_END
HTML_CODE(t_code_attributes)
HTML_CODE_END
HTML_KBD(t_keyboard_attributes)
HTML_KBD_END
HTML_SAMP(t_samp_attributes)
HTML_SAMP_END
HTML_STRIKE(t_strike-through_attributes)
HTML_STRIKE_END
HTML_SUB(t_subscript_attributes)
HTML_SUB_END
HTML_SUP(t_superscript_attributes)
HTML_SUP_END

HTML HYPERTEXT LINKS:

HTML_A(t_link_attributes)
HTML_A_END

HTML LISTS:

HTML_DD(t_dl_definition_attributes)
HTML_DD_END
HTML_DIR(t_dir_attributes)
HTML_DIR_END
HTML_DL(t_definition_list_attributes)
HTML_DL_END
HTML_DT(t_dl_term_attributes)
HTML_DT_END
HTML_LI(t_list_item_attributes)
HTML_LI_END
HTML_MENU(t_menu_attributes)
HTML_MENU_END
HTML_OL(t_ordered_list_attributes)
HTML_OL_END
HTML_UL(t_unordered_list_attributes)
HTML_UL_END

HTML TABLES:

HTML_CAPTION(t_caption_attributes)
HTML_CAPTION_END
HTML_TABLE(t_table_attributes)
HTML_TABLE_END
HTML_TD(t_data_cell_attributes)
HTML_TD_END
HTML_TH(t_header_attributes)
HTML_TH_END
HTML_TR(t_row_attributes)
HTML_TR_END
Top
Copyright © 2009, Ray Ontko & Co. Last updated: Tuesday, May 11, 2010
Careers Library Products Services Site Map Search Contact Us About Us News