Commands by Category

Commands That Manage Data

ADD adds data to EntitySets and relationships.

AFT (utility program) adds data from the terminal to any EntitySet or relationship with fields.

CFT (utility program) changes, with data from the terminal, any EntitySet, relationship with fields, form, or result set.

CHANGE changes data in EntitySets, relationships, forms, or sets.

COMPUTE computes the results of one or more expressions for a set of records.

DELETE deletes data from EntitySets or relationships with fields.

LIST lists data from the database.

 

Commands That Manage Sets

Sets

-> (Dynamic rename) renames a component of the set specification in the main command.

-> (Result set) assigns a name to the set of records processed by the main command.

EVALUATE evaluates expressions while the main command processes a set of records.

FIND finds records that match specified conditions, producing a result set.

SET CHECKSETS controls consistency checking of result sets.

SET CURRENTSET makes a specified result set the current set.

SET MEMBERCOUNT turns set-processing messages on and off.

SET MEMBERINTERVAL sets the interval between set-processing progress messages.

A Set Specification identifies particular records in an Zim database.

A Set Specification (ISQL) identifies particular records in an SQL database.

SORT sorts the members of a result set.

SORTED BY sorts the members of the set produced by the main command.

USING qualifies a relationship in a set specification.

Set Membership

COMPLETE used as a part of set specification to select both matching and non-matching members of an EntitySet, a relationship with fields, a form, a menu, a result set, or a structured application document.

INTERSECT extracts the common members of two or more result sets.

KEEP extracts some components from a set while discarding others.

MINUS removes the members of one or more result sets from a particular result set.

UNION combines the members of two or more result sets into a single result set.

UNRELATED used in a set specification to select non-matching members of an EntitySet, relationship with fields, application document, or result set.

WHERE (Condition) states a condition that limits the records processed by the main command.

Current Member

BOTTOM moves the current member pointer to the last member of a result set.

DOWN moves the current member pointer one or more members "down" in a result set.

LOCATE moves the current member pointer to a particular member of a result set.

NEXT (same as DOWN).

PREVIOUS (same as UP).

SORT sorts the members of a result set.

TOP moves the current member pointer to the first member of a result set.

UP moves the current member pointer one or more members "up" in a result set.

 

Commands That Manage Forms and Displays

DISPLAY DEFINE calls up the Screen Painter to paint a display.

FORM CLEAR resets specified form field values to their defaults.

FORM CLOSE closes the current form or display in the current window.

FORM DEFINE calls up the Screen Painter to paint a form object.

FORM DISPLAY displays the form fields of the currently open form or display in the current window.

FORM INPUT shift focus to the open form in the current window and requests input from the application user.

FORM OPEN opens a form or display in the current window.

FORM REPORT writes the values of the fields in the current form or display to the current output device.

FORM RESTORE makes the "next" saved form or display in the current window the current form or display.

FORM SAVE saves the current form or display in its current state for later use in the current window.

FORM SCROLL causes scrolling under application program control.

FORM SET (Attributes) modifies certain attributes of open forms, form fields, or displays; specifies attributes to be applied to form fields that get focus.

FORM SET FOCUS sets the focus on a specified form or form field.

FORM SET LIST sets the contents of a list box or combo box from an expression or from a set.

FORM SET SCROLL establishes a scrolling association between a form and a result set.

 

Commands That Manage Menus

MENU CLEAR resets menu item values to their defaults.

MENU CLOSE closes the open menu in the current window.

MENU DEFINE calls up the Screen Painter to paint a menu object.

MENU DISPLAY displays the open menu in the current window.

MENU INPUT shifts the focus to the open menu in the current window and requests input from the application user.

MENU OPEN opens a menu in the current window.

MENU SET (Attributes) modifies the individual attributes of menus or menu items.

 

Commands That Manage Windows

SET CURSOR switches the display of the text-entry cursor on or off.

SET INPUT TIMEOUT controls how long a FORM INPUT or MENU INPUT command waits for user interaction.

SET MESSAGES WINDOW activates or deactivates the use of the message window for system messages.

SET MOUSE controls the use of a pointing device in Zim for Windows.

SET TIMEOUT controls how long the software waits to acquire a lock.

WINDOW ACTIVATE makes an open window available to the application user.

WINDOW CLEAR clears the client area of a window.

WINDOW CLOSE closes an open window.

WINDOW DEACTIVATE makes an open window unavailable to the application user.

WINDOW DEFINE calls up the Screen Painter to paint a window object.

WINDOW DISPLAY controls the display of windows on the desktop.

WINDOW MOVE moves a window to a new location.

WINDOW OPEN opens a window for use in subsequent window-handling commands.

WINDOW SCROLL scrolls an open window under application program control.

WINDOW SET (Attributes) modifies the individual attributes of open windows.

WINDOW SET ACCELERATOR establishes the accelerator keys for the current window.

WINDOW SET CURRENT makes an open window the current window.

WINDOW SET CURSOR sets the location of the focus in the current window. Determines if the cursor can move outside unprotected form fields in the current window.

WINDOW SET INPUT controls the display location of serial input from the keyboard.

WINDOW SET INPUT EXPOSE controls automatic exposure of active windows on input requests.

WINDOW SET OUTPUT controls the display location of serial output.

WINDOW SET SCROLL establishes SCROLL action keys for the current window.

WINDOW SIZE resizes, maximizes, minimizes, or restores the previous dimensions of an open window.

 

Commands That Manage Objects

Automated Tools

DC (utility program) starts up the Development Center.

DISPLAY DEFINE calls up the Screen Painter to paint displays, forms, menus, and windows.

FORM DEFINE calls up the Screen Painter to paint forms, menus, and windows.

MENU DEFINE calls up the Screen Painter to paint menus and windows.

WINDOW DEFINE calls up the Screen Painter to paint windows.

Manual Manipulation

CREATE creates objects in an application directory.

ERASE erases objects from an application directory.

RENAME changes the name of certain types of objects.

Availability and Value Management

ACCESS opens an application directory to use the objects contained in it.

CONNECT establishes a connection to an SQL database.

DISCONNECT releases a connection to an SQL database.

DISPOSE releases memory occupied by user-defined variables (including form fields and menu items) or result sets.

LET assigns a value to a variable object.

RELEASE closes an application directory.

REMOTEEXEC executes a command against a target server.

Commands That Generate Programs

GENERATE generates application code from a template.

 

Commands That Control Programs and the Sequence of Execution

Procedures

LOCALPROCEDURE defines and marks the start of a local procedure within an application program document.

ENDPROCEDURE marks the end of a procedure.

PROCEDURE defines and marks the start of a procedure.

Structures

CASE enables conditional execution of commands.

ELSE marks a portion of an IF command.

ELSEIF marks a portion of an IF command.

ENDCASE marks the end of a CASE command.

ENDIF marks the end of an IF command.

ENDON marks the end of an exception handler.

ENDWHILE marks the end of a WHILE command.

IF enables conditional execution of commands.

ON declares a block of commands to be a handler for a specified exception condition.

OTHERWISE marks a portion of a CASE command.

WHEN marks a portion of a CASE command.

WHILE enables repeated execution of commands.

Flow

BREAK exits from a WHILE loop.

BYE exits the current application session, returning control to the operating system.

CONTINUE restarts a WHILE loop.

GOTO branches to another location in an application program.

GOTO NEXT branches from an exception handler to the command following the command that triggered the exception.

GOTO PREVIOUS branches from an exception handler to the command that triggered the exception.

RETURN stops execution of the current application program and returns to the "previous" program.

SET EXCEPTION triggers an exception handler in the absence of an exception condition.

SLEEP suspends the execution of an application for a specified period of time.

STOP stops execution of the current application program and returns to the software's command prompt.

TRANSFORM transfers control to another procedure.

 

Commands That Create Reports

BREAK breaks the body of a report into summary groups.

COLUMN BREAK breaks the body of a column-oriented report into summary groups.

DETAIL LINE specifies the fields that are selected for a report.

ENDREPORT marks the end of a group of report commands.

PAGE FOOTING specifies the page footing for a report.

PAGE HEADING specifies the page heading for a report.

PAGE LEFT specifies the vertical heading for each page in a column-oriented report.

PAGE RIGHT specifies the vertical footing for each page in a column-oriented report.

REPORT FOOTING specifies the report footing.

REPORT HEADING specifies the report heading.

REPORT FROM selects data for a report and specifies overall report format.

 

Commands That Manage Input and Output

INPUT gets serial input from the application user.

OUTPUT outputs the results of one or more expressions.

PAUSE causes execution to be halted and a message to be displayed.

PRINT prints the contents of a window or application document.

RELOAD (utility program) reloads data from an application document into an EntitySet or relationship with fields.

SET COLUMNSPACING specifies the spacing between columns in the output of the LIST and OUTPUT commands.

SET DELIMITER specifies the current delimiter.

SET DOCLINELENGTH adjusts the size of the internal data buffer used to read unstructured application documents.

SET DOCUMENT FORMAT sets the format of the application document.

SET EOFVALUE specifies the application document end-of-file indicator string.

SET EOLNTRANSLATE translates carriage return/line feed sequences.

SET ERRORS displays or suppresses error messages.

SET HEADINGS controls the display of headings during LIST output.

SET INFORMATION displays or suppresses information messages.

SET INPUT FORMAT specifies the format for data input.

SET INPUT TIMEOUT sets the timeout limit for input requests.

SET MESSAGES displays or suppresses all software messages.

SET NULLVALUE specifies the characters to be displayed for the $Null value.

SET OUTPUT specifies the current output device.

SET OUTPUT FIELDLISTWIDTH specifies how ListWidth is to be treated in LIST output.

SET OUTPUT FORMAT specifies the format for data output.

SET OUTPUT MASKFIELD specifies how the FieldMask is to be treated in LIST output.

SET OUTPUT TRIM specifies how trailing blanks in the output stream are to be treated.

SET OUTPUT VIRTUALFIELD specifies if virtual fields can be output with a LIST command.

SET PAGESIZE controls the length of pages in LIST output.

SET PAGEWIDTH controls the width of pages in LIST output.

SET PAUSE controls the use of pauses during LIST output.

SET TEXTDELIMITER sets the current text delimiter for "comma-delimited" format.

SET TRACE OUTPUT records tracing information.

SET WARNINGS displays or suppresses warning messages.

UNLOAD (utility program) unloads data from an EntitySet or relationship with fields.

ZIMLOAD (utility program) reloads an entire application (objects and data) from a series of special disk files.

ZIMSAVE (utility program) saves an entire application (objects and data) in a series of disk files.

 

Commands That Manage Transactions

ENDTRANSACTION marks the end of an explicit transaction.

QUITTRANSACTION marks the end of an explicit transaction in progress, discarding the results.

SET AUTORETRY specifies that implicit transactions are to be retried automatically if deadlock occurs.

SET TRANSACTION DEFAULTTYPE specifies if implicit transactions are assumed to be read-only or read/write.

SET TRANSACTION FLOW traces the execution of explicit transaction commands.

TRANSACTION starts an explicit transaction in a multi-user environment.

 

Commands That Manage Security

DECRYPT decrypts the data in an EntitySet or relationship with fields.

ENCRYPT encrypts the data in an EntitySet or relationship with fields.

LOGIN identifies the current user to Zim for security purposes.

PASSWORD changes or assigns a password.

PERMISSION grants permission to other users to access your data.

 

Commands for Testing and Debugging

DEPENDENCY produces or deletes object dependency information.

DESCERR (utility program) describes a specified error.

EXPLERR (utility program) explains the most likely cause of the last error to occur.

HALT (utility program) sets break points in application programs where execution is halted.

PARSE tests a command for syntactic and semantic accuracy.

PAUSE causes execution to be halted and a message to be displayed.

SET COMMANDTIMING displays how much time each command takes to execute.

SET DEPENDENCY specifies if dependencies between objects are to be tracked.

SET FLOW controls the call tracing of procedures.

SET LEXTRACE controls lexical tracing.

SET QUOTING specifies if quotation marks are required for character strings.

SET RUNTIME determines if compiled versions of application programs are to be executed.

SET SINGLESTEP steps through a procedure one command at a time, halting after each command.

SET STOP ERRORS halts the execution of an application program if an error occurs.

SET TRACE controls command tracing.

SET TRANSACTION FLOW traces the execution of explicit transaction commands.

SET XREF turns the output of cross-reference information on or off during parsing and compiling.

 

Commands That Manage Program Compilation

COMPILE compiles an application program.

SET COMPILEMODE controls the behavior of the compiler.

SET EXECUTEMODE controls the mode of software execution.

SET RUNTIME determines if compiled versions of application programs are to be executed.

SET SQLCOMPILE controls the compilation of generated SQL statements within the SQL database.

UNCOMPILE marks an application program as "not compiled".

 

Commands That Access External Products and Processes

EDIT starts a text editor.

HELP presents on-line help information.

GRAPH starts a graphics program.

SYSTEM sends a command to the operating system.

 

Commands That Manage the Application Environment

Special Characters

SET ESCAPECHAR controls the use of the escape character in quoted character strings.

SET QUOTING specifies if quotation marks are required for character strings.

SET SPECIALSCAN controls how special characters in unstructured application documents are treated.

Terminal Screen

CLEAR clears the current window.

CURSOR positions the cursor in the current window.

SCREEN CLEAR clears the screen and establishes the application window (BACKSCREEN) as the current window (all other open windows are hidden).

SCREEN RESET resets the application window (BACKSCREEN) by redisplaying all active windows over it.

Software Functions

SET AUTOSAVE controls flushing of modified records to disk in single-user systems.

SET BREAKABLE controls the use of the "break" key.

SET CHECKNULLS turns required field checking on and off for EntitySets and relationships with fields.

SET RESET resets most global application environment settings to their default state.

SET RESTORE restores the top group of settings in the stack of saved global settings created by SET SAVE.

SET SAVE saves the current global application environment settings in their current state for later use.

SET SELECTIVITY specifies index selectivity for indexed fields.

SET SIZE sets the estimated number of records in an EntitySet, relationship, application document, or result set.

SET STRATEGY investigates retrieval strategies.