Controls the display or suppression of headings in LIST command output.

Syntax

SET HEADINGS ON|OFF

Comments

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.

Example

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

LIST

SET PAGESIZE

SET PAUSE

Indicates the Zim:X product currently being used.

Syntax

$zimproduct

Return Value

A number according to the description below. Cannot be reset by an application program.

Description

See Also

$ZimOS
$ZimVersion

Adjusts the size of the internal data buffer used to read unstructured application documents.

Syntax

SET DOCLINELENGTH num

Parameters

Comments

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

SET SPECIALSCAN

Tests if Zim is connected to a particular server.

Syntax

$isconnected(string)

Parameters

Return Value

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

Example

$isconnected("ZIMSERV")

Evaluates to $True if a previous CONNECT statement to ZIMSERV was successfully issued.

See Also

CONNECT

DISCONNECT

Extracts the day number associated with a specified date value.

Syntax

$day(date)

Parameters

Return Value

Character string.

Comments

This function extracts day information from standard date values. Date is often the system variable $Date.

Example

$day(19981225)

Evaluates to “25”.

$day($date+7)

Evaluates to “1” when $Date is 19991225.

See Also

$adddays

$Date

$dayname

$month

$monthname

$weekday

$year

SET SQLTRACE

Controls the tracing of software-generated SQL commands.

Syntax

SET SQLTRACE ON|OFF

Comments

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.

Example

> 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

COMPILE

PARSE

SET COMPILEMODE

SET EXECUTEMODE

UNCOMPILE

Resets the application window (BACKSCREEN) by re-displaying all active windows over it.

Syntax

SCREEN RESET

Comments

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.

Example

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

See Also

FORM INPUT

The error severity level generated by the last command that returned an error severity level.

Syntax

$lasterrlevel

Value

A number (1 to 4). Can be reset by an application program.

Description

The error severity level of the most recently executed command that returned an error severity level other than 0 (success).

See Also

$ErrCode

$ErrLevel

$LastErrMessage

$MaxErrLevel

System Variables

Controls the spacing between columns in the output of LIST and OUTPUT commands.

Syntax

SET COLUMNSPACING num

Parameters

Comments

The COLUMNSPACING option is set to 1 by default.

The SET COLUMNSPACING command specifies the number of spaces to be inserted between successive columns in the output generated by the LIST, SELECT, and OUTPUT commands.

Example

To specify three spaces between columns, use the following:

set columnspacing 3

See Also

LIST

OUTPUT

SELECT

Calculates the arcsine of a number.

Syntax

$asin(number)

Parameters

Return Value

Number, with the same number of decimal places as number.

Comments

Use $asin to calculate the arcsine (in radians) of a number. The value returned by this function has the same number of decimal places as number. The absolute value of the number must be between 0 and 1.

Example

let vAngle[2] = $asin(0.500)

The preceding command sets the second element of array variable vAngle to 0.524.

See Also

$acos

$atan

$atan2

$sin

$sinh

About Functional Expressions