This option is used to import table definitions from the SQL server and to translate them into equivalent Zim definitions. To import SQL definitions into Zim, select the Tools/Import/Objects/From SQL option from the development center main menu. The SQL Definition Import window appears. On this window, choose the ODBC Server as the server from which…
Read more
The export facility is used to translate Zim definitions for entity sets and/or data relationships and create them on the designated SQL server. The definitions of the resulting tables (with associated indexes) correspond to each exported Zim EntitySet or data relationship definition. The Zim definitions to be exported are selected from the EntitySets and Relationships…
Read more
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
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
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
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
Even though per user entity sets are private and only seen by the user that created them, they can still be available to an ODBC Driver connection by means of the Dynamic Creation of a Data Source, which informs the work path that contains the per user entity sets. When the third party software connects…
Read more
Zim supports Microsoft Open Database Connectivity Drivers (ODBC, defined by Microsoft as a standard way for applications to access data stored in database files) which allows third-party tools to access a Zim database via the Zim ODBC Driver. This driver is used to access data from a Zim database that is either local to the…
Read more
Note: In Zim, constant strings can be represented either surrounded in single quotes (‘) or double quotes (“). In SQL, constant strings are surrounded by single quotes (‘) whereas identifiers are surrounded by double quotes (“). statement ::= SELECT select | INSERT insert | DELETE delete | UPDATE update | passthroughSQL passthroughSQL ::= any statement…
Read more
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
English 
Portuguese