-----------------------------------------------------------------------------
-- (c) Copyright IBM Corp. 2007 All rights reserved.
--
-- The following sample of source code ("Sample") is owned by International
-- Business Machines Corporation or one of its subsidiaries ("IBM") and is
-- copyrighted and licensed, not sold. You may use, copy, modify, and
-- distribute the Sample in any form without payment to IBM, for the purpose
-- of assisting you in the development of your applications.
--
-- The Sample code is provided to you on an "AS IS" basis, without warranty
-- of any kind. IBM HEREBY EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS
-- OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
-- MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Some jurisdictions
-- do not allow for the exclusion or limitation of implied warranties, so the
-- above limitations or exclusions may not apply to you. IBM shall not be
-- liable for any damages you suffer as a result of using, copying, modifying
-- or distributing the Sample, even if IBM has been advised of the
-- possibility of such damages.
-----------------------------------------------------------------------------
--
-- SOURCE FILE NAME: SpDrop.db2
--
-- SAMPLE: Drops the external procedures created in SpCreate.db2 for C#
--
--
-- To run this script from the CLP, perform the following steps:
-- 1. Connect to the database
-- 2. Issue the command:
--
-- "db2 -td@ -vf <script-name>"
--
-- where <script-name> represents the name of this script, SpDrop.db2
------------------------------------------------------------------------------
DROP PROCEDURE OUT_LANGUAGE (CHAR(8),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE OUT_PARAM (DECIMAL(9,2),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE IN_PARAMS (DECIMAL(9,2),
DECIMAL(9,2),
DECIMAL(9,2),
CHAR(3),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE INOUT_PARAM (DECIMAL(7,2),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE ONE_RESULT_SET (DECIMAL(7,2),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE CLOB_EXTRACT (CHAR(6),
VARCHAR(1000),
INTEGER,
VARCHAR(32))@
DROP PROCEDURE ALL_DATA_TYPES (SMALLINT,
INTEGER,
BIGINT,
REAL,
DOUBLE,
CHAR(1),
CHAR(15),
VARCHAR(12),
DATE,
TIME,
INTEGER,
VARCHAR(32))@