Categoria: ZIM:X Connectivity

The Original Internet Language

Importing and Exporting SQL Definitions

The Import/Export functions of the Zim Development Center application provides support for the import/export and translation of database object definitions between the Zim and SQL server environments. In particular, Zim EntitySet and data relationship definitions can be exported to the SQL server to create corresponding tables and indexes. Additionally, SQL table definitions can be extracted…
Leia mais

Importing SQL Definitions into Zim

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…
Leia mais

Exporting Zim Definitions to SQL

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…
Leia mais

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…
Leia mais

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…
Leia mais

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…
Leia mais

Logging in to a Database

The driver provides a login dialog under one of two conditions. The login appears if the application using the driver passes it a blank user id or password the user id or password variables are not defined in the registry The User ID and Password passed to the driver from the application override those defined…
Leia mais

Introduction to ZimWeb

Adding More Power and Flexibility to Zim Zim is a powerful and flexible environment for developing and using all types of database applications. Zim‘s Entity-Relationship (ER) data model and fully-integrated Object Dictionary enable progressive program development, whether the information processing system is simple or complex. Zim Server provides a database server capability that can be…
Leia mais

ODBC Driver

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…
Leia mais

Supported SQL Grammar

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…
Leia mais

pt_BRPortuguese