An ODBC Data Source to access a Zim database can be configured in two different ways: . Using the Zim ODBC Driver Setup to create a data source; . Using Zim language to dynamically create and maintain a data source tailored for specific needs like calling a third party software from within Zim. In both…
Read more
If the server function requires parameters (called input host variables), these can be supplied by placing parameter markers in the syntax (indicated with a ‘?’) and then specifying the parameters as the second and subsequent arguments to $ServerFunction. Here is an example: change all orders where orderno = 1003 \ let RequiredByDate = $ServerFunc(‘trunc( ?,…
Read more
ZimWeb includes page template support. This allows you to combine parameters from Zim with the page (web page, etc.) delivered to the client. Template file format A page template is just a regular page (HTML etc.), with parameter placeholders to indicate where each parameter to be supplied by the Zim application is to be placed.…
Read more
Key Guidelines for Creating Secure ZimWeb Applications Secure access to the ZimWeb Administration servlet such that unpriviledged users cannot access it.The installation instructions for Tomcat (See Installation) show how to reserve it for a given user name and password. Ensure that the client DEBUG facility is disabled by default by setting the allow-debug configuration option…
Read more
The various XML technologies incorporated into ZimWeb may require references from one source to another (e.g. one XSLT stylesheet referencing another, or a reference to an external image in XSL-FO). The following explains precisely how references to other sources (URIs) are interpreted in different circumstances. URIs in XML generated by the Zim database agent…
Read more
There are two ways of tracing the activity of the Zim Server Connectivity: 1) At the client side: when accessing a remote database, Zim translates Zim commands syntax into an appropriate syntax for execution on the remote server. In general, Zim commands are executed through a combination of processing at the server (or at several…
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
When developing client-server database applications, it is important to consider the location of the data. Any data under the control of the database server contributes to both the load on the network as well as load on the server machine. Because of this, it is important to analyze the data associated with a given application…
Read more
In Client-Server applications, you do not have to do anything special to access or manipulate data stored in the SQL database. The data definitions of objects under Zim’s control and the data definitions of objects not under Zim’s control are exactly the same. To an application, Zim manipulates both in exactly the same way. The…
Read more
Zim supports two types of transactions: implicit and explicit. An implicit transaction is associated with each individual Zim command that accesses the database in some manner (either read/only or read/write). When the command ends, all locks that were acquired are released and any database updates are committed to the database. If the command fails (e.g.…
Read more
English 
Portuguese