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…
Read more
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…
Read more
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). Value Meaning 1 Information…
Read more
Controls automatic exposure of active windows on input requests. Syntax WINDOW SET INPUT EXPOSE ON|OFF Comments The WINDOW SET INPUT EXPOSE command is set ON by default. When WINDOW SET INPUT EXPOSE is ON, the current window (if active) is always exposed when input is requested (by a FORM INPUT, INPUT, or MENU INPUT command).…
Read more
Controls the spacing between columns in the output of LIST and OUTPUT commands. Syntax SET COLUMNSPACING num Parameters num Num can bean integer constant (e.g., 15, 200),a variable, form field, menu item, or parameter that evaluates to an integer,A setting of zero is valid. Comments The COLUMNSPACING option is set to 1 by default. The…
Read more
Calculates the arcsine of a number. Syntax $asin(number) Parameters number a number, or an expression that evaluates to a number 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…
Read more
MINUS Removes the members of one or more result sets from a another result set. Syntax set1 MINUS set2 Parameters set1 A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure. set2 A result set that resulted from the execution of a set-producing command.…
Read more
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…
Read more
Performs a bit-wise NOT of a value. Syntax $not(char) Parameters char a character string, or an expression that evaluates to a character string Return Value Character string. Comments The $not function reverses the bit pattern of a single character in the fashion of a Boolean NOT and returns the resulting character. If the char string…
Read more
Indicates the character set used by the application database. Syntax $dbcharset Return Value 2 for ANSI or 3 for UTF-8, depending on the character set specified when the database was initialized. Cannot be reset by an application program. Description When you initialize a new application database, the database (ZIMBOOT) administrative utility requires you to specify…
Read more
English 
Portuguese