rem HEADER
rem   $Header: wfrmita.sql 26.1 2001/11/05 20:18:45 ctilley ship $
rem NAM
rem   wfrmitt.sql - WorkFlow ReMove ITem Attribute
rem USAGE
rem   @wfrmita
rem DESCRIPTION
rem   DANGER *** DANGER *** DANGER *** DANGER *** DANGER *** DANGER
rem
rem   You will be prompted for the item type and attribute name.
rem   Deletes all workflow information for the specified item attribute.
rem
rem   DANGER *** DANGER *** DANGER *** DANGER *** DANGER *** DANGER

rem   dbdrv: none

set verify off
whenever sqlerror exit failure rollback;

accept type prompt "Enter Item Type: "
accept name prompt "Enter Item Attribute Name: "
 
prompt ---- wf_item_attribute_values
delete from wf_item_attribute_values
where  ITEM_TYPE = '&type'
and    NAME = '&name';
 
prompt ---- wf_item_attributes_tl
delete from wf_item_attributes_tl
where  ITEM_TYPE = '&type'
and    NAME = '&name';

prompt ---- wf_item_attributes
delete from wf_item_attributes
where  ITEM_TYPE = '&type'
and    NAME = '&name';

commit;
exit;