/* Example by Sean aka TimeTraveler      */
/* NY/CT Music Events:                   */
/*   send blank msg to museworks-        */
/*   subscribe _at_ yahoogroups.com      */
/*   or visit museworksentertainment.com */

#include <stdio.h>
#include <stdlib.h>              /* needed for getenv() */

#include "/path/to/eqldefs.h"
#include "/path/to/local_eqsqlca.h"
#include "/path/to/ingres_def.h"

## static char *DBSDBN;    /* env var 'dbserver::dbname' */
## float mx;
## float av;

int main() {
        DBSDBN = getenv("DBSDBN");

##      INGRES DBSDBN

##      RANGE OF r IS racers

##      RETRIEVE        (
##              mx=max(r.mph),
##              av=avg(r.mph)
##              )

        printf("+--------+--------+\n");
        printf("|MPH              |\n");
        printf("+--------+--------+\n");
        printf("|Max     |Avg     |\n");
        printf("|%8.2f|%8.2f|\n",mx,av);
        printf("+--------+--------+\n\n");

##      EXIT

        return(0);
}

/* Compile instructions:
 *      #!/bin/ksh
 *      # vars - Obviously compile args vill vary.
 *      #        Check before use.
 *      opts="-L/usr/Binaries/Libs/lib -lingfns"
 *      opts="${opts} -L/opt/ingres/lib"
 *      opts="${opts} -lsocket -lnsl -lelf -laio"
 *      opts="${opts} -lingres -ldl -lrt"
 *      opts="${opts} -L/path/to/EPN/lib/ -lm"
 *      a=`basename $1 | sed 's/\..*$//'`
 *      # main compile program
 *      /bin/rm -f ${a} ${a}.o
 *      eqc -o.hh -d -ferr_${a}.c ${a}.eql
 *      gcc -I. -I/opt/ingres/files -g -Wall -c err_${a}.c
 *      /bin/mv -f err_${a}.o ${a}.o
 *      gcc -o ${a} ${a}.o ${opts}
 */