InfoShelf Home Tutorial Start Print Tutorial

List of Exercises

Exercise 4: Creating Row Data Types, continued

See " Compiling and Linking DataBlade Module Code" for detailed instructions on using the Visual C++ makefile (RowCircle.mak for this exercise) to compile the source code into the dynamic link library file (RowCircle.bld).

For more information about compiling on UNIX, see the DataBlade Developers Kit User's Guide.

Install the RowCircle DataBlade module into the %INFORMIXDIR%\extend\RowCircle.1.0 directory on the server machine.

See " Installing a DataBlade Module" for detailed installation instructions.

Ensure that the permissions on the RowCircle.bld file are read-only. (If your dynamic link library or shared object file is not read-only, a database server error occurs when you try to run it.)

See " Starting Informix Dynamic Server on Windows NT" for detailed instructions for starting Informix Dynamic Server on Windows NT.

For instructions on starting Informix Dynamic Server on UNIX, see the Administrator's Guide for your database server.

If the database in which you plan to test the RowCircle DataBlade module does not yet exist, create it using the following SQL statement:

create database rowtest with buffered log; 

See " Registering a DataBlade Module" for detailed instructions on registering using the BladeManager graphical user interface.

For information on registering using BladeManager from the command line, see the DataBlade Module Installation and Registration Guide.

After you install and register the DataBlade module, the Informix database accepts the new data types and routines and runs them as if they were built-in.

To test the RowCircle DataBlade module, execute these SQL operations using DB-Access or SQL Editor

1. Create the table tst_Point that contains an rciPoint column.

2. Insert sample data into tst_Point.

3. Run a SELECT statement that calculates the distance of a point from the origin (0, 0) for each record.

4. Create the table tst_RCirc.

5. Insert sample data into tst_RCirc.

6. Run a SELECT statement that calculates if a circle contains the origin (0, 0) for each record.

InfoShelf Home Tutorial Start Print Tutorial