Setting up stock data examples

Set up the stock data examples. Use the sample queries and sample programs to practice handling time series data.

Procedure

To install the sample database schema and to compile the sample C programs:
  1. 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.
  2. 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.

Results

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.