@echo off
rem 
rem (c) Copyright IBM Corp. 2007 All rights reserved.
rem
rem The following sample of source code (<93>Sample<94>) 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
rem of assisting you in the development of your applications.
rem
rem The Sample code is provided to you on an "AS IS" basis, without warranty
rem of any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS
rem OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
rem MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions
rem do not allow for the exclusion or limitation of implied warranties, so the
rem above limitations or exclusions may not apply to you. IBM shall not be
rem liable for any damages you suffer as a result of using, copying, modifying
rem or distributing the Sample, even if IBM has been advised of the
rem possibility of such damages.

rem -------------------------------------------------------------------------
rem
rem  SOURCE FILE NAME: SpCat.db2
rem     
rem  SAMPLE: Drops and creates the procedures implemented in SpServer.vb
rem
rem  BATCH FILE: SpCat
rem    To catalog stored procedures on Windows 
rem
rem     SpDrop.db2      Drops the stored procedures from DB2's catalogs
rem     SpCreate.db2    Creates the stored procedures in DB2's catalogs 
rem
rem    Both CLP scripts can be run on their own
rem
rem    Usage: SpCat
rem --------------------------------------------------------------------------

db2 connect to sample
db2 -td@ -vf SpDrop.db2
db2 -td@ -vf SpCreate.db2
db2 connect reset