Category: SET Commands

The Original Internet Language

SET (EntitySet/Data Relationship Attribute)

SET (EntitySet/Data Relationship Attribute) Modifies the value of an attribute of a database object. Syntax SET tablename tabletype [ “ZIMSERV” | “JDBCSAM” | alias name ] SET tablename [ remname |  remowner ] value SET fieldname [ remname ] value tablename is the name of an EntitySet or data relationship fieldname is the name of…
Read more

SET COMMANDTIMING

Displays how much time each command takes to execute. Syntax SET COMMANDTIMING ON|OFF Comments The COMMANDTIMING option is set OFF by default. The SET COMMANDTIMING command controls the output of command timing messages. In UNIX, the format of command timing messages is source, line, IU|RU, user ticks, elapsed user ticks, IS|RS, system ticks, elapsed system…
Read more

SET XML ROWELEMENT

Defines the title of the row element Syntax set xml rowelement constant Parameters constant A character string or an expression that evaluates to a character string Comments SET XML ROWELEMENT defines the identification of the row element for each row data that is printed whenever the set output format xml or xmlsimple is set. By…
Read more

SET NULLVALUE

Specifies the characters to be displayed for $Null values. Syntax SET NULLVALUE constant Parameters constant A character string, or an expression that evaluates to a character string. Comments The NULLVALUE option is set to a space character by default. When a value to be output is $Null, the specified constant is displayed. Example To specify…
Read more

SET TRACE OUTPUT

Records tracing information. Syntax SET TRACE OUTPUT docname [APPEND] Parameters docname The name of an application document. All subsequent trace output is sent to the specified document. APPEND Indicates that subsequent trace output is to be appended to the existing contents of docname. Comments Normally, information generated by the commands SET COMMANDTIMING, SET FLOW, SET…
Read more

SET INFORMATION

Enables or suppresses the display of information messages. Syntax SET INFORMATION ON|OFF Comments The INFORMATION option is set ON by default. When INFORMATION is ON, information messages are displayed. Setting INFORMATION to OFF suppresses the display of such messages. Information messages are of the form: nnn selected after a FIND command nnn added after an…
Read more

SET SQLCOMPILE

SET SQLCOMPILE Controls the compilation of generated SQL statements within the SQL database. Syntax SET SQLCOMPILE ON|OFF Comments The SQLCOMPILE option is OFF by default. The software stores SQL statements generated in the compiled code and executes them dynamically at run time. When SQLCOMPILE is switched ON, the software attempts to compile all generated SQL…
Read more

SET CHECKSETS

Controls consistency checking of result sets. Syntax SET CHECKSETS ON|OFF Comments The CHECKSETS option is set ON by default. When CHECKSETS is ON, the software checks certain aspects of the component structure of result sets for consistency. This consistency checking is performed when a command creates a result set (using the -> (Result set) subcommand),…
Read more

SET EXECUTEMODE

SET EXECUTEMODE Controls the mode of software execution. Syntax SET EXECUTEMODE SQLMODE | ZIMMODE | SERVERMODE Comments The EXECUTEMODE option is set to SQLMODE by default. The SQLMODE option executes SQL database code. The SERVERMODE option executes integrated Zim server code. The ZIMMODE option executes standard Zim code. In ZIMMODE, EntType, RelType, and so on…
Read more

SET STOP ERRORS

Halts the execution of an application program if an error occurs. Syntax SET STOP ERRORS ON|OFF Comments The STOP ERRORS option is OFF by default. When STOP ERRORS is switched ON, execution is halted (by the HALT utility) when an error occurs. To resume execution after the HALT, press Enter at the HALT prompt (>>).…
Read more

en_CAEnglish