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