Set up the stock data examples. Use the sample queries
and sample programs to practice handling time series data.
To install the sample database schema and to compile
the sample C programs:
- Set the following environment variables:
- MACHINE=machine
- PROD_VERSION=version
- USERFUNCDIR=$INFORMIXDIR/extend/TimeSeries.version/examples
The version is the internal TimeSeries version
number, for example 5.00.UC1. Check the installation directory for
the correct version number. The machine is the
name of the operating system, as listed in the $INFORMIXDIR/incl/dbdk/makeinc file,
for example, linux.
- Run the examples_setup.sql command from
the $INFORMIXDIR/extend/TimeSeries.version/examples directory: make -f Makefile MY_DATABASE=dbname The dbname is the name of a database.
Sample queries and programs are located in the same examples directory.
Precede queries with the BEGIN WORK statement and follow them with
the ROLLBACK WORK statement.