Category: ZIM Product Suite

The Original Internet Language

Isolation Levels

DB2 provides support for three levels of multiple user concurrency control. These isolation levels select the extent to which database operations performed by one user are isolated from concurrent operations performed by other users. “Repeatable Read” isolation level means that locks are held on all rows read or updated by a user for the duration…
Read more

The JDBC Connectivity to SQL Database Servers

Zim can manipulate and retrieve data from third-party data sources as well as from a Zim database. Client applications for SQL database servers are designed and developed as complete Zim application systems. The objective of the Zim product is 100 percent source code portability of applications including seamless access to databases being managed by SQL…
Read more

Portability Benefits of Zim Client-Server

A Zim Client-Server application can be developed as a stand-alone standard Zim application on any supported platform. Once developed, the application can be moved easily to another platform and configured to access remote data sources. Because of this capability, Zim enables you to separate your application from the ultimate data source, enabling development to be…
Read more

Zim Server Performance Tuning

After running your Zim applications for a while, it will probably be needed to re-configure Zim Server to provide better performance. Basically, three things can be taken into account: 1) Maximize the use of shared memory by allocating as many buffers and areas as possible; 2) At the same time, balance the use of shared…
Read more

Memory Use in the Client

Because Zim 9 always operates in the client/server mode, memory operations performed by the client are not affected by what is being done in the server and vice-versa. When running Zim on Windows in the client side, the local machine is dedicated to the client session; therefore, all resources available can be used solely for…
Read more

Memory Use in the Server

If the contents of all files that an application requires at any given time could be stored in memory, response time would be very rapid. Using main memory is much quicker than using disk input/output (I/O) because the time required to access files from disk is much greater than that required to access them from…
Read more

Performance Tuning

When considering the performance of an application, individual users have different criteria in mind. To some, performance is the speed at which an application responds to the requests of an application user. To others, it is the ability of the application to run properly within the limits set by the hardware or operating system. Performance…
Read more

DDE Error Return Codes

The return value of $DDEFunction is one of the following. A negative result indicates failure. Value Description 0 DDE service completed successfully. -1001 Bad DDE service indicator type; p2 is not of type longint or int. -1002 Unknown DDE service indicator value; p2 not 1, 2, 3, 4, or 5. -1003 Attempt to CONNECT failed.…
Read more

Zim Integrated Server (ZIS)

Windows Zim Server can be started manually from the Start menu, or the Startup folder. You can also start the process from the command prompt:   start zsvserv.exe [-p <port number> | -s <service>]   This command starts Zim Server in its own console window. The -p option sets the port number on which the server is listening. The -s option does the…
Read more

Error Handling

Errors generated during the Zim Server Connectivity activity can be checked via the system variables $SQLErrCode and $SQLErrMsg. The first one contains the error number and the second one the message text corresponding to that error number.

en_CAEnglish