Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\admin\sql\wfrmita.sql
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;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de