@echo off
rem (c) Copyright IBM Corp. 2007 All rights reserved.
rem 
rem The following sample of source code ("Sample") is owned by International 
rem Business Machines Corporation or one of its subsidiaries ("IBM") and is 
rem copyrighted and licensed, not sold. You may use, copy, modify, and 
rem distribute the Sample in any form without payment to IBM, for the purpose of 
rem assisting you in the development of your applications.
rem 
rem The Sample code is provided to you on an "AS IS" basis, without warranty of 
rem any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR 
rem IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF 
rem MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions do 
rem not allow for the exclusion or limitation of implied warranties, so the above 
rem limitations or exclusions may not apply to you. IBM shall not be liable for 
rem any damages you suffer as a result of using, copying, modifying or 
rem distributing the Sample, even if IBM has been advised of the possibility of 
rem such damages.

rem BATCH FILE: spcat.bat
rem To catalog JDBC and SQLJ stored procedures on Windows
rem Catalogs the stored procedures in the SpServer library
rem SpDrop.db2 uncatalogs the stored procedures if previously cataloged
rem SpCreate.db2 catologs the stored procedures
rem Both CLP scripts can be run on their own
rem Usage: spcat

rem Uncatalog the stored procedures if previously cataloged
db2 -td@ -vf SpDrop.db2

rem Connect to 'sample' database
db2 connect to sample

rem Uninstall the jar file if already installed
db2 "CALL sqlj.remove_jar('MYJAR')"

rem Remove the jar file if already exists
del SpServer.jar

rem Create a jar file 'SPServer.jar' using the class file 'SpServer.class'
echo "Executing 'javac SpServer.java'..."
javac SpServer.java

echo "Executing 'jar cf SpServer.jar SpServer.class'..."
jar cf "%DB2PATH%\SpServer.jar" SpServer.class

rem Install the jar file using a unique jar-id.
db2 "CALL sqlj.install_jar('file:%DB2PATH%\SpServer.jar', 'MYJAR')"

rem Disconnect from 'sample' database
db2 connect reset

rem Catalog the stored procedures
db2 -td@ -vf SpCreate.db2

@echo on