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

Controls required field checking for EntitySets and relationships with fields.

Syntax

SET CHECKNULLS ON|OFF

Comments

The CHECKNULLS option is set ON by default.
When CHECKNULLS is ON, an error results if a Required field is assigned the $Null property during an ADD, CHANGE, INSERT, or UPDATE command. Normally, you should always leave CHECKNULLS set ON.
Even if you switch null checking OFF, you should always explicitly or implicitly assign some value to every required field.

Note: A field is Required if its definition in the Object Dictionary specifies yes for Reqd.

See Also

ADD

CHANGE

INSERT

UPDATE

Specifies an end-of-file indicator for application documents.

Syntax

SET EOFVALUE character_constant|OFF

Parameters

Comments

The EOFVALUE option is set OFF by default (no character is recognized as an end-of-file).

The EOFVALUE option enables you to specify one or more characters that are to be recognized as an end-of-file indicator when the software reads an application document.

When reading input from the terminal as an application document, the software always recognizes a zero-length line as an end-of-file. The software also recognizes real end-of-file conditions, independent of the setting of EOFVALUE.

Example

set eofvalue “xyz”
add DataCollected from SerDevice
set eofvalue off
% batch complete – do something else

Assume that a device attached to your computer has been defined as an application document called SerDevice. The device is collecting data and sending it to your computer in batches that are terminated with a record containing the characters “xyz”. The above commands read the data without waiting between batches.

Controls command tracing.

Syntax

SET [LOCAL] TRACE ON|OFF

Parameters

Comments

The SET TRACE command controls command tracing. When TRACE is switched ON, each line of a procedure is displayed as it is executed. Each line is preceded by the procedure name and document line number as shown in the following example:

pCustReport[19] report from Customers

SET TRACE has no effect on compiled application programs.
SET TRACE is not affected by the SET RESET and SET RESTORE commands.

Example

To display the instructions in the procedure MyProg as they are executed, use

set trace on
MyProg

See Also

SET COMMANDTIMING

SET LEXTRACE

SET TRACEOUTPUT

Steps through a procedure one command at a time, halting after each command.

Syntax

SET SINGLESTEP ON|OFF

Comments

When SINGLESTEP is switched ON, execution is halted (by the HALT utility) after each command executed. To resume execution after the HALT, press Enter at the HALT prompt (>>).

Compiled application programs are not affected by SET SINGLESTEP.

The SET SINGLESTEP command is not affected by the SET RESET and SET RESTORE commands.

Example

To switch to singlestep, use

> set trace on
> set singlestep on

Now, if you execute an application program, it looks like this:

> DoCusts (“edit”)
procedure DoCusts (in ExMode)
>>output $setcount
35
>>(carriage return)
let dp = $true
>>.
.
.

See Also

SET STOP ERRORS

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

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

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

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

Turns set-processing messages on and off.

Syntax

SET MEMBERCOUNT ON|OFF

Comments

When MEMBERCOUNT is set ON, messages tracking the progress of set-processing commands are output. Messages overwrite each other at intervals specified by the SET MEMBERINTERVAL command.

Progress messages take the form nnn processed. Messages are output with a carriage return but with no line feed; therefore, successive messages are written to the same screen position.

The printing of progress messages can slow execution slightly.

Example

> set membercount on
> set member interval 10
> find Employees
200 processed.
200 selected.
>

The number of records processed and selected are displayed in increments of ten until all records are processed.

See Also

$MemberCount

SET ERRORS

SET MEMBERINTERVAL