Defining Tables in Zim

Defining Tables in Zim

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

Defining Tables in Zim

When an EntitySet or data relationship is created, it is declared to be a table managed either by Zim or by an SQL server. This declaration is done by the field EntType in the data dictionary EntitySet EntitySets or, for data relationships only, in the field RelType in the data dictionary EntitySet Relationships. This flag is checked to determine whether standard Zim code or SQL code (including SQL statements) should be generated when the object is referenced in a Zim command. The following tables indicate how to specify whether Zim or a SQL Server is managing an EntitySet or data relationship.

EntType and RelTypeManaged By
blankZim
“ZIM”Zim
“JDBCSAM”JDBC SAM

For example, if the field EntType in the definition of the EntitySet Customers contained the SAM name JDBCSAM, then the EntitySet Customers is a table managed by the JDBC SAM which in turn will handle data from this entity set that is located on a particular SQL database server.

If the field EntType or RelType is either blank or the value “ZIM”, the object continues to be managed by Zim; no other object definitions are required.

When the object is created, a check ensures that the SAM name in the field EntType or RelType is a valid server name.

Was this article helpful?
5 out of 5 stars

1 rating

5 Stars 100%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish