Category: Database Configuration

The Original Internet Language

Work Path

work path path where path is the disk directory path to the temporary work files for a session. The work path is valid for all users accessing the database and is formed by adding the work path with the user number that is entering the database at that time. For example: work path /usr/users Users…
Read more

Backscreen Hide

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…
Read more

File statistics

file statistics yes | no Specifies if statistics concerning the number of logical and physical input/output operations are to be recorded. The statistics are written to a text file called zimstats in the user’s work path. This option provides information about the file usage in the current Zim session whereas Zim Explore provides the same…
Read more

Activity Timeout

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…
Read more

Transaction Retries

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…
Read more

Disconnect Timeout

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…
Read more

Document Line Length

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 Windows 256 UNIX 256

SQL Database Name

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…
Read more

Server Request Tracing

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 Windows no UNIX no  

Maximum Parameters

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 Windows 20 UNIX 20  

en_CAEnglish