Category: Zim:X Interacting With SQL Databases

The Original Internet Language

Program Execution

Zim is capable of executing database commands in either of these three modes: 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 SERVERMODE, a Zim client accessing tables on Zim Integrated…
Read more

Tracing SQL Commands

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

Connecting and Recompiling the Zim Application

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

en_CAEnglish