Category: ZIM DBMS Tools

directories nn

where nn is the number of Zim directories that can be accessed at any one time.

Valid Settings

nn = numeric entry 3 to 200

When you are ready to run your application in production mode, you may want to hide the ZIM prompt which is known as the backscreen.  You can change the setting dynamically using the $setproperty method.  You can also find the current setting using the $getproperty method.

backscreen hide yes | no

Specifies if the application window (BACKSCREEN) is hidden when the client session starts up.

Valid Settings

yes indicates the application window is hidden; no indicates the application window is not hidden at start-up. The default is always no.

activity timeout nn

where nn is the maximum number of minutes a session can be left connected without any activity being performed. After this time is reached, the connection is severed.

The main goal of this option is to close unattended sessions after a certain amount of time.

Valid Settings

nn = numeric entry from 0 to 1000000, where 0 means infinity. The default value is always 0.

transaction retries n

n specifies the number of attempts to be made at retrying an implicit transaction that has failed because of deadlock. A setting of -1 causes the transaction to be retried until deadlock does not occur. This option applies only when the application has SET AUTORETRY set ON.

Valid Settings

-1 to 1000

Related Information

SET AUTORETRY

disconnect timeout nn

where nn is the maximum number of seconds the client and the server will wait for communication to resume in case there is an interruption. After this time has passed without any sign of reconnection, the communication is finally broken by either one of the peers.

Valid Settings

nn = numeric entry from 0 to 32765. The default value of zero indicates that the disconnection occurs immediately.

document line length nn

where nn specifies the maximum length of a line in an unstructured document used for importing data. This option can also be set during a session using the SET DOCLINELENGTH command.

Valid Settings

nn = numeric entry 256 to 32000

SQL database name xxx

where xxx is a three-letter identification to uniquely name Zim compiled programs from one database to another.

If there is to be more than one Zim application compiled against a given SQL server database, you have to uniquely identify each application. Conflicts can occur between programs with the same name.

Valid Settings

server request tracing yes | no

This option tells Zim Server to trace all incoming statements either in Zim or SQL from connections established by clients. The statements are logged to zimsvlog.zim. Care should be taken as it generates lots of printing and might result in performance degradation.

Valid Settings

maximum parameters nn

where nn specifies the maximum number of parameters and local variables that can be used in a procedure or local procedure.

Valid Settings

nn = numeric entry 0 to 256

maximum open windows nn

where nn specifies the maximum number of windows that can be open at one time.

Valid Settings

nn = numeric entry 0 to 127