@echo off


rem     Richard A. DeVenezia
rem     SUGI 29 - "Greetings from the Edge"
rem     www.devenezia.com/papers


rem
rem Database gateway example for use with SAS version 9.1+
rem The gateway runs as a thread in the SAS hosted JVM and is
rem accessed through the DATA Step javaobj component.
rem

rem
rem Step 1. compile gateway example java classes
rem

mkdir class

cd java\
javac -d ..\class\ -classpath ..\class\ Gateway*.java

if errorlevel 1 goto done

cd ..

rem
rem Step 2. set important environment variables
rem

set SAS9="c:\opt\sas\v91\sas.exe"
set CLASSPATH=class;c:\opt\jars\pg73jdbc3.jar;c:\opt\jars\mysql-connector-java-3.0.11-stable-bin.jar

rem
rem Step 3. run push/pull sample program against a postgresql database server (running at www.devenezia.com)
rem

set database=mysql
%SAS9% -sysin sas/gateway-sample.sas -jreoptions (-Djava.class.path=%CLASSPATH%) -noovp -log %database%-test.log -print %database%-test.lst > %database%-test.stdout 2>%database%-test.stderr

rem
rem Step 4. run push/pull sample program against a mysql database server (running locally)
rem

set database=pgsql
%SAS9% -sysin sas/gateway-sample.sas -jreoptions (-Djava.class.path=%CLASSPATH%) -noovp -log %database%-test.log -print %database%-test.lst > %database%-test.stdout 2>%database%-test.stderr

:done