Zim 9 always runs under a Client/Server architecture where Zim Server is the server and the clients can be Zim, Zim Thin Client (ZIMTC) or ZimExplore. Zim Server can manage any number of different Zim databases at the same time, all of them located in the same physical machine where Zim Server is running (a…
Read more
Zim Server has many possible configurations. multi-user single-user Zim Integrated Server Usually, the Database Agent process accesses a local Zim database (local refers to relationship to the server). The Database Agent process is started much like any version of Zim: it has its own working directory; it uses Zim directory files to look up…
Read more
Zim enables you to connect to more than one remote database at the same time. This enables you to do join operations between different databases on different machines managed by different Zim database servers. No support for distributed concurrency control is available; updates which span multiple servers, though permitted, should be performed with care. As…
Read more
It is very important to make a distinction between Zim 9 Server and Zim Server Connectivity. Zim 9 Server always operates in Client/Server mode where Zim Server is the server and Zim, Zim Thin Client are the clients. The clients run a Zim application that accesses data provided by the server. Every time a client…
Read more
Because client and server are separate processes (and can even be on different machines) with Zim Server Connectivity, there are some new options for providing security, although the same basic mechanisms are used. Using ZIM Security Within Zim, security is provided through a combination of log in user names, passwords, and entity set, relationship, and…
Read more
There are two different moments when dealing with Zim Server Connectivity: 1) The preparation of client database: this step is done only once and creates data definitions to allow the client database to “see” what is defined in the other Zim database and it is obligatory; 2) The preparation of remote database: the other database…
Read more
The Zim “COMPILE” command is capable of compiling application programs in one of the same three modes as described for program execution: SQLMODE SQL mode SERVERMODE Zim Integrated Server mode ZIMMODE Standard Zim mode The default mode of operation is SERVERMODE. For all database servers except Zim Integrated Server, SERVERMODE and SQLMODE behave identically. In…
Read more
The application is compiled using the “compilemode” option “sqlmode” and conversion to a Zim Client-Server application is complete. If the application is to be developed for execution against a pre-existing SQL server database, then the Zim application should be compiled using the “compilemode” option “zimmode” to test the application for functionality and performance. Then the…
Read more
In order to access relational databases, Zim client-server generates SQL statements. You can see the statements generated by setting SQLTRACE on. Statements are generated when Zim statements containing references to SQL tables are parsed, compiled, or executed interpretively. Previewing the SQL statements generated provides an insight into the type or amount of work the database…
Read more
English 
Portuguese