# A makefile to compile embeded SQL C programs
#
# input: sta-select.sqc (a static SQL c program) and
#        dyn-select.sqc (a dynamic SQL c program)
# output: dyn-select  (executable codes)
#

DB2DIR = /opt/IBMdb2/V6.1
Cflags = -I $(DB2DIR)/include \
         -L $(DB2DIR)/lib \
         -R $(DB2DIR)/lib \
         -ldb2

#all: dyn-select

# The first thing is to connect to the database and precompile the programs.
# This generates C programs where all SQL commands (except dynamic SQL
# queries inside dyn-select.sqc) are replaced by subroutine calls.
# 

dyn-select.c: dyn-select.sqc
	db2 connect to c343h
	db2 prep dyn-select.sqc
	db2 connect reset

sta-select.c:sta-select.sqc
	db2 connect to c343h
	db2 prep sta-select.sqc
	db2 connect reset

# The next step is to compile the C programs and
# generate the executable codes.

sta-select: sta-select.c
	gcc -Wall $(Cflags) -o sta-select sta-select.c -I/u/dbinst2/sqllib/bin/db2

dyn-select: dyn-select.c
	gcc -Wall $(Cflags) -o dyn-select dyn-select.c