analytics/informix/extend/spatial.8.22.FC2/examples/odbc

This directory contains example programs which demonstrate how to
insert and fetch geometry data to and from a database using the
Informix Spatial DataBlade and the Informix ODBC driver.

On Unix, to compile and run these example programs, you need a version
the Informix ODBC Library which is availale in th Cient SDK recommended
for your Infomrix Server.


I. Directory contents
=====================

1. Programs which demonstrate how to load all geometry types
-------------------------------------------------------------------------
load_shapes.c - Creates a table with an ST_Geometry column and
inserts examples of all geometry types in ESRI
shape format, using the SE_GeomFromShape function.
load_wkb.c - Creates a table with an ST_Geometry column and
inserts examples of all geometry types in OGIS
WKB format, using the ST_GeomFromWKB function.


2. Programs which are shown as fragments in the Users Guide
-------------------------------------------------------------------------
asbinary.c - ST_AsBinary example.
asshape.c - SE_AsShape example.
geomfromshape.c - SE_GeomFromShape example.
geomfromwkb.c - ST_GeomFromWKB example.
interiorring.c - ST_InteriorRingN example.
linefromshape.c - SE_LineFromShape example.
linefromwkb.c - ST_LineFromWKB example.
mlinefromshape.c - SE_MLineFromShape example.
mlinefromwkb.c - ST_MLineFromWKB example.
mpointfromshape.c - SE_MPointFromShape example.
mpointfromwkb.c - ST_MPointFromWKB example.
mpolyfromshape.c - SE_MPolyFromShape example.
mpolyfromwkb.c - ST_MPolyFromWKB example.
pointfromshape.c - SE_PointFromShape example.
pointfromwkb.c - ST_PointFromWKB example.
polyfromshape.c - SE_PolyFromWKB example.
polyfromwkb.c - ST_PolyFromWKB example.
shapetosql.c - SE_ShapeToSQL example.
wkbtosql.c - ST_WKBToSQL example.


3. Common code, used by all of the above programs
-------------------------------------------------------------------------
commfuncs.h - Header file containing data structure definitions,
constants and function prototypes
commfuncs.c - Functions which serialize and de-serialize
numeric data, swapping bytes if necessary
odbcutils.c - Functions for establishing a server connection
and checking ODBC library function return status.
shapefuncs.c - Functions for converting geometry data to and from
ESRI shape format.
wkbfuncs.c - Functions for converting geometry data to and from
OpenGIS Well-Known Binary format.


4. Other files
-------------------------------------------------------------------------
Readme.txt - This file.
Makefile - Makefile for compiling all programs on Unix and Linux platforms.
For Unix and Linux, the Makefile may need to be changed to
add platform specific compiler options may need to be specified.
SOLARIS 32 and 64 are currently included.

There is rudimentary support for Windows build by
uncommenting the Windows only section of the Makefile.
This makefile is designed to work with MS VS2005 and MKS.
cleanup.sql - SQL script for dropping tables created by demo programs.




II. Setting up and running the demos
====================================

1. Running the Makefile
-----------------------
You can use the Makefile to compile each demo program individually or
compile them all at one time. To compile only a single demo, pass its
name as a command-line argument to make. Not passing any command-line
argument will cause all the demo programs to be compiled.

To successfully run the Makefile, you need to have the INFORMIXDIR
environment variable set to the directory where the Client-SDK is
installed.

The Makefile is configured for Solaris platforms. You might need
to change it slightly for other platforms.


2. Command-line arguments
-------------------------
The demo programs all take a DSN name and an optional SRID as
command-line arguments. If you do not specify an SRID, the programs
will use SRID = 0, which is pre-loaded into the spatial_references
table when you register the Spatial DataBlade in a database.