Category: SET Commands

Enables or suppresses the display of warning messages.

Syntax

SET WARNINGS ON|OFF

Comments

The WARNINGS option is set ON by default.

When WARNINGS is ON, warning messages are displayed. Setting WARNINGS to OFF suppresses the display of warning messages. Warning messages are of the form

***Warning*** …

All types of messages can be simultaneously turned on or off with a SET MESSAGES command.

The SET WARNINGS command has no effect on the logging of messages in the “error trace” file. Message logging is governed by the configuration option error trace.

Example

set messages on
set warnings off

The preceding commands set error and information messages on, but warnings off.

See Also

SET ERRORS

SET INFORMATION

Enables or suppresses the display of error messages.

Syntax

SET ERRORS ON|OFF

Comments

The ERRORS option is set ON by default.

When ERRORS is ON, error messages are displayed. Setting ERRORS to OFF suppresses the display of such messages. Error messages are of the form:

*** Error*** . . .

or:

***Zim System Error*** . . .

All types of messages can be simultaneously turned on or off with a SET MESSAGES command.

SET ERRORS has no effect on the logging of messages in the “error trace” file as this logging is always on and cannot be disabled.

Example

set messages on
set errors off

The preceding commands set warning and information messages on, but error messages off.

See Also

SET INFORMATION

SET WARNINGS

Enables or suppresses the display of all system messages.

Syntax

SET MESSAGES ON|OFF

Comments

The MESSAGES option is set ON by default.

When MESSAGES is ON, all system messages (errors, warnings, information) are displayed. Setting MESSAGES to OFF suppresses the display of all messages.

The display of specific message types may be turned on or off using the SET ERRORS, SET INFORMATION, and SET WARNINGS commands.

The SET MESSAGES command has no effect on the logging of messages in the “error trace” file. Message logging is governed by the configuration option error trace.

Example

set messages on
set warnings off

The preceding commands set error and information messages on, but warnings off.

See Also

SET ERRORS

Controls the use of pauses during LIST output.

Syntax

SET PAUSE ON|OFF

Comments

The PAUSE option is set OFF by default.

When you set PAUSE ON, LIST output pauses after each “page” (i.e., the number of lines specified in the current PAGESIZE setting).

During a pause at the terminal, the message Press to continue, q to quit appears. (This message can be altered with ZIMLANG, the Language Customizer utility, if desired.)

Example

set output printer
set pause on
set pagesize 40
set pagewidth 120
list all Employees sorted by Department

The above SET PAUSE command ensures that the printer stops after each page, enabling you (for example) to manually feed a special form for each page of output.

See Also

SET HEADINGS

SET PAGEWIDTH

Controls the display of a XMLHEADER.

Syntax

SET XMLHEADER ON|OFF

Comments

When outputting data using the XML or XMLSIMPLE formats, a standard ISO header can be attached to the resulting document.

Example

set save

set output format xmlsimple

set XMLHEADER on

set output MyDoc

list 1 Docs

set restore

See Also

SET OUTPUT FORMAT

Syntax

SET TRANSACTION DEFAULTTYPE READ|NORMAL

Comments

This command is ignored by Zim 9.

Controls how trailing blanks in output lines are treated.

Syntax

SET OUTPUT TRIM ON|OFF

Comments

The OUTPUT TRIM option is set OFF by default.

Normally, trailing blanks are retained in the output stream. To remove trailing blanks, set OUTPUT TRIM to ON. This option works with single lines of text; to trim trailing blanks in fields, use $trim.

See Also

$trim

LIST

OUTPUT

REPORT FROM

Specifies if implicit transactions are to be retried automatically if a deadlock or a time-out occurs.

Syntax

SET AUTORETRY ON|OFF

Comments

The AUTORETRY option is set OFF by default.

When AUTORETRY is ON, implicit transactions that fail because of deadlock or time-outs will be retried until they finally succeed or an internal maximum number of retries is reached (which can be set by the database configuration option “transaction retries”).

If these implicit transactions fail, then an error message is printed.

Controls if virtual fields can be output using a LIST command.

Syntax

SET OUTPUT VIRTUALFIELD ON|OFF

Comments

The OUTPUT VIRTUALFIELD option is set ON by default.

Normally, LIST can output virtual fields. To suppress the output of virtual fields, set OUTPUT VIRTUALFIELD to OFF.

See Also

LIST

Sets an exclusive or shared access to a database.

Syntax

SET DATABASE ACCESS EXCLUSIVE|SHARED

Comments

This command enables a specific user (usually the database administrator) to grant himself/herself exclusive access to a ZIM database. Under normal conditions, database access is shared among users; however, in some situations, the administrator may want exclusive access to the database (i.e. urgent program recompilation or database maintenance).  To obtain exclusive access the database administrator can issue the command with the option EXCLUSIVE.

At this point the ZIM Server stops accepting new incoming transactions, waits for the existing transactions to end and then grants exclusive Database access to the specific user.  Any subsequent requests from other users are kept in a suspended state. As soon as all transactions stop, all files are closed. Therefore, it is possible to issue operating system commands to deal with physical database files.

When the exclusive access is no longer required, the command can be issued with the option SHARED.

From this point, Zim Server activity is resumed and all suspended state users can continue with their normal processing.

At the end of the session that set the exclusive access and if the access was not reverted to shared, then Zim Server automatically sets the shared attribute to that database.