Indicates a positive value (unary +) or adds two values.
[expression1]+expression2
The plus sign (+) adds the expression on the right to the expression on the left.
| expression1 | a number or expression that evaluates to a number |
| expression2 | a number or expression that evaluates to a number |
Arithmetic operators indicate the sign of a number or perform arithmetic operations (addition, subtraction, multiplication, division, exponentiation).
Converts alphabetic characters to upper case.
$toupper(source)| source | any value, or an expression that yields any value |
Character string, in which all letters are uppercase.
$toupper returns a character string in which all letters are upper case. If source is not of a character data type, it is converted to a character data type before the function is applied.
$toupper("the QUICK BROWN fox is 30 years oLD")Evaluates to “THE QUICK BROWN FOX IS 30 YEARS OLD”.
Controls the display or suppression of headings in LIST command output.
SET HEADINGS ON|OFF
The HEADINGS option is set ON by default.
When you set HEADINGS OFF, output from the LIST and SELECT commands omits field headings from the columns displaying each field’s contents.
The HEADINGS setting affects the width of the columns output by LIST and SELECT. When headings are ON, the longer of the field’s width or its heading is used as the character width of the column in which the field’s content appears. When headings are OFF, the field’s width is always used to set the character width of the column.
set output ExportDoc
set headings off
list all Employees
set output terminal
The SET HEADINGS command is used to suppress headings when the output of a LIST command is being sent to a file.
See Also
Indicates the Zim:X product currently being used.
$zimproduct
A number according to the description below. Cannot be reset by an application program.
| Value | Product |
| 2 | ZimPrompt |
| 9 | ZimServer |
| 12 | ZimQTC |
Adjusts the size of the internal data buffer used to read unstructured application documents.
SET DOCLINELENGTH num
| num | Num can be an integer constant (e.g., 15, 200), a variable, form field, menu item, or parameter that evaluates to an integer. Num must be between 1 and 32000. |
At the start of an application session, DOCLINELENGTH is determined by the applicable document line length configuration option. If no document line length is explicitly specified, 256 is used by default.
The current value of DOCLINELENGTH is saved by the SET SAVE command, and restored by the SET RESTORE command. The SET RESET command resets DOCLINELENGTH to its configured or default value.
See Also
Tests if Zim is connected to a particular server.
$isconnected(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if Zim is connected to the server name contained in string; if the server name is invalid or there is no connection, evaluates to 0 ($False).
$isconnected("ZIMSERV")Evaluates to $True if a previous CONNECT statement to ZIMSERV was successfully issued.
Extracts the day number associated with a specified date value.
$day(date)| date | a data, or an expression that evaluates to a date, in the form YYYYMMDD |
Character string.
This function extracts day information from standard date values. Date is often the system variable $Date.
$day(19981225)
Evaluates to “25”.
$day($date+7)
Evaluates to “1” when $Date is 19991225.
Controls the tracing of software-generated SQL commands.
SET SQLTRACE ON|OFF
The SQLTRACE option is set OFF by default.
When SQLTRACE is switched ON, all SQL statements generated are displayed at the terminal. SQL statements are generated during command or program parsing, interactive or interpretive execution, and compiling, if a command statement refers to an EntitySet or relationship identified as being managed by an SQL database server.
> set sqltrace on
> list all Customers format CC LastName
select cc, lastname from customers
When the software parses, executes, or compiles the statement list all Customers format CC LastName with SQL tracing set on, select cc, lastname from customers appears at the terminal.
See Also
Resets the application window (BACKSCREEN) by re-displaying all active windows over it.
SCREEN RESET
The SCREEN RESET command reverses a SCREEN CLEAR command by hiding the application window (BACKSCREEN) beneath all other active windows and making it the least current window.
During an input request, the Ctrl-R key sequence entered by the user has the same effect as SCREEN RESET.
SCREEN RESET
is equivalent to the following sequence of commands:
window clear backscreen
window set not current backscreen
window display backscreen hide
screen clear % clear prev. data & expose application window
output “Output to printer? (y/n)” ;
input Response
if Response = “y”
set output printer
endif
screen reset
The error severity level generated by the last command that returned an error severity level.
$lasterrlevel
A number (1 to 4). Can be reset by an application program.
The error severity level of the most recently executed command that returned an error severity level other than 0 (success).
| Value | Meaning |
| 1 | Information message |
| 2 | Warning |
| 3 | User error |
| 4 | System error |
Portuguese 
English