About Precompiled Statements

The Mimer SQL Mobile database server that runs on your handheld device has a very small footprint. This is achieved by creating and storing precompiled statements that give you access to the data stored on your device.

For example, to store the statement: SELECT col1,col2 FROM tab, you would use the SQL command CREATE STATEMENT as follows:

CREATE STATEMENT sel1 SELECT col1, col2 FROM tab
        

The statement, named sel1, is stored in the database. When you run your application it executes the following statement:

EXECUTE STATEMENT sel1

The same method is used for all types of data manipulation statements and calls to stored procedures.

Create and Store Precompiled Statements

The following are examples of precompiled SQL statements:

CREATE STATEMENT ins1 INSERT INTO tab(col1, col2) VALUES('ABC', :col2_value)

CREATE STATEMENT upd1 UPDATE tab SET col2=col2 + 10
WHERE col1 = :hw_col1

CREATE STATEMENT proc1 CALL proc('ABC', 10, 20)

The INSERT statement, ins1, inserts the string 'ABC' into col1. The second parameter, :col2_value, is a parameter marker and is represented by a host variable in an application program.

Tip: As size is of great consequence on any handheld device, you should minimize the size of the database by removing objects that are not needed.

Precompiled Statements in the Example Environment

In the example environment, if you chose to install it, there are a number of precompiled statements ready for use which you can review on your workstation.

To review them:

1. Click Start, browse to your Mimer SQL Mobile program group and select Mimer Explorer.
2. Login to the example environment. If you accepted the default settings when installing, the user name is: mimer_store, and the password is: GoodiesRUs. Mimer Explorer starts.
3. To execute a precompiled statement, just click on it.