Distributed asset delete triggers

Rational® Asset Analyzer creates these distributed asset delete triggers.

Triggering event	Trigger name	Triggered action	Table name	Conditions
After delete from DMH_ARCH_MANIFEST	DMHARMD1	Delete row or rows from	DMH_AMF_CLASSPATH	MANIFEST_ID = FILE_ID
After delete from DMH_ARCH_MANIFEST	DMHARMD1	Delete row or rows from	DMH_REFS_JBC	FILE_ID = FILE_ID
After delete from DMH_ASSET_CONT	DMHBCRD2	Delete row or rows from	DMH_BYTECODE_ROOT	CMPNT_TYPE_ID = 138 AND CONTAINER_ID=CONTAINER_ID
	DMHJARD2	Delete row or rows from	DMH_JAR	CMPNT_TYPE_ID = 137 AND CONTAINER_ID=CONTAINER_ID
	DMHPAQD2	Delete row or rows from	DMH_PACKAGE	CMPNT_TYPE_ID = 114 AND CONTAINER_ID=CONTAINER_ID
	DMHTRACI	Delete row or rows from	DMH_CHANGE_FOCUS DMH_CHANGE_IMPACT	RELATED_ID_1 = CONTAINER_ID AND CMPNT_TYPE_ID = CMPNT_TYPE_ID
	DMHTRACI	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = CONTAINER_ID AND ASSET_TYPE_ID = CMPNT_TYPE_ID
After delete from DMH_ASSET_FILE	DMHARMD2	Delete row or rows from	DMH_ARCH_MANIFEST	CMPNT_TYPE_ID = 101 AND DMH_ASSET_FILE FILE_ID = FILE_ID
	DMHASFD1	Delete row or rows from	DMH_CHANGE_FOCUS DMH_CHANGE_IMPACT	RELATED_ID_1 = FILE_ID AND CMPNT_TYPE_ID = CMPNT_TYPE_ID
	DMHASFD1	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = FILE_ID AND ASSET_TYPE_ID = CMPNT_TYPE_ID
	DMHCLFD2	Delete row or rows from	DMH_BYTECODE_CLASS	CMPNT_TYPE_ID = 102 AND FILE_ID = FILE_ID
	DMHCPPD2	Delete row or rows from	DMH_CPP	CMPNT_TYPE_ID = 105 AND FILE_ID = FILE_ID
	DMHEARD2	Delete row or rows from	DMH_EAR	CMPNT_TYPE_ID = 106 AND FILE_ID = FILE_ID
	DMHHTMD2	Delete row or rows from	DMH_HTML	CMPNT_TYPE_ID = 111 AND FILE_ID = FILE_ID
	DMHJ2ED2	Delete row or rows from	DMH_JEECLIENT	CMPNT_TYPE_ID = 112 AND FILE_ID = FILE_ID
	DMHEJJD2	Delete row or rows from	DMH_EJBJAR	CMPNT_TYPE_ID = 108 AND FILE_ID = FILE_ID
	DMHJSPD2	Delete row or rows from	DMH_JSP	CMPNT_TYPE_ID = 115 AND FILE_ID = FILE_ID
	DMHRR1D2	Delete row or rows from	DMH_RAR	CMPNT_TYPE_ID = 118 AND FILE_ID = FILE_ID
	DMHSTFD2	Delete row or rows from	DMH_FILE_SYMBOL	CMPNT_TYPE_ID = 55 AND FILE_ID = FILE_ID
	DMHTGLD2	Delete row or rows from	DMH_TAGLIB	CMPNT_TYPE_ID = 117 AND FILE_ID = FILE_ID
	DMHWARD2	Delete row or rows from	DMH_WAR	CMPNT_TYPE_ID = 125 AND FILE_ID = FILE_ID
	DMHWDLD2	Delete row or rows from	DMH_WSDL	CMPNT_TYPE_ID = 128 AND FILE_ID = FILE_ID
	DMHWSED2	Delete row or rows from	DMH_WS_ENDPOINT	CMPNT_TYPE_ID = 129 AND FILE_ID = FILE_ID
	DMHWSJD2	Delete row or rows from	DMH_WS_JAXRPC	CMPNT_TYPE_ID = 139 AND FILE_ID = FILE_ID
	DMHXMLD2	Delete row or rows from	DMH_XML	CMPNT_TYPE_ID = 126 AND FILE_ID = FILE_ID
After delete from DMH_BYTECODE_CLASS	DMHCLFD1	Delete row or rows from	DMH_JBC_FIELD DMH_JBC_METHOD DMH_HIERARCHY_JBC	CLASS_ID = FILE_ID
After delete from DMH_BYTECODE_CLASS	DMHCLFD1	Delete row or rows from	DMH_REFS_JBC DMH_REFS_JBF DMH_REFS_JBM	FILE_ID = FILE_ID
After delete from DMH_CPP	DMHCPPD1	Delete row or rows from	DMH_CPP_DEF_MACROS DMH_CPP_INC_FILES DMH_CPP_GLBL_FUNCS DMH_CPP_GLBL_VARS DMH_CPP_MBMR_FUNCS DMH_CPP_MBMR_VARS	CPP_ID = ID
			DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 105
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 105
After delete from DMH_EAR	DMHEARD1	Delete row or rows from	DMH_EAR_EJBJARS DMH_EAR_JEECLIENTS DMH_EAR_WARS	EAR_ID = FILE_ID
After delete from DMH_EJB	DMHEJBD1	Delete row or rows from	DMH_CHANGE_FOCUS DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 107
			DMH_EJB_ENTITY DMH_EJB_ENV_ENTRYS DMH_EJB_LOCAL_REF DMH_EJB_MSG_DRVN DMH_EJB_QUERY DMH_EJB_REF DMH_EJB_RSRC_ENVS DMH_EJB_RSRC_REFS DMH_EJB_SESSION	EJB_ID = ID
			DMH_LINK	LINK_ID = LINK_ID AND ASSET_TYPE_ID = 107 AND ASSET_ID = ID AND LINK_TYPE_ID = 102
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 107
After delete from DMH_EJBJAR	DMHEJJD1	Delete row or rows from	DMH_EJB DMH_EJB_RELATION	EJBJAR_ID = FILE_ID
After delete from DMH_EJBJAR	DMHEJJD1	Delete row or rows from	DMH_REFS_JBC	FILE_ID = FILE_ID
After delete from DMH_EVENT_LISTENER	DMHEVTD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 120
After delete from DMH_EVENT_LISTENER	DMHEVTD1	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 120
After delete from DMH_FILTER	DMHFL1D1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 109
			DMH_FLTR_PARAMS	FILTER_ID = ID
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 109
After delete from DMH_HTML	DMHHTMD1	Delete row or rows from	DMH_HTML_HEADINGS	HTML_ID = FILE_ID
After delete from DMH_HTML	DMHHTMD1	Delete row or rows from	DMH_REFS_URL	FILE_ID = FILE_ID
After delete from DMH_JBC_FIELD	DMHFLDD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 103
After delete from DMH_JBC_FIELD	DMHFLDD1	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 103
After delete from DMH_JBC_METHOD	DMHMETD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 104
After delete from DMH_JBC_METHOD	DMHMETD1	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 104
After delete from DMH_JEECLIENT	DMHJ2ED1	Delete row or rows from	DMH_JC_ENV_ENTRYS DMH_JC_EJB_REF DMH_JC_RSRC_REFS	JEECLIENT_ID = FILE_ID
After delete from DMH_JEECLIENT	DMHJ2ED1	Delete row or rows from	DMH_REFS_JBC	FILE_ID = FILE_ID
After delete from DMH_JSP	DMHJSPD1	Delete row or rows from	DMH_JSP_BEANS DMH_JSP_HEADINGS DMH_JSP_METHOD_USE DMH_JSP_TAGLIBS	JSP_ID = FILE_ID
After delete from DMH_JSP	DMHJSPD1	Delete row or rows from	DMH_REFS_JBC DMH_REFS_URL	FILE_ID = FILE_ID
After delete from DMH_RAR	DMHRR1D1	Delete row or rows from	DMH_RAR_CFG_PROPS	RAR_ID = FILE_ID
After delete from DMH_RAR	DMHRR1D1	Delete row or rows from	DMH_REFS_JBC	FILE_ID = FILE_ID
After delete from DMH_SCAN_ROOT	DMHCRWD1	Delete row or rows from	DMH_ANALYSIS_QUEUE	RELATED_ID_1 = ID AND CMPNT_TYPE_ID_1 = 50
After delete from DMH_SCAN_ROOT	DMHCRWD1	Delete row or rows from	DMH_SCAN_ROOT_DAT	SCAN_ROOT_ID = ID
After delete from DMH_SERVLET	DMHSETD1	Delete row or rows from	DMH_CHANGE_FOCUS DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 119
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 119
			DMH_SRVLT_PARAMS DMH_SRVLT_URL_PTRN	SERVLET_ID = ID
After delete from DMH_TAG	DMHTAGD1	Delete row or rows from	DMH_CHANGE_FOCUS DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 116
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 116
			DMH_TAG_ATTRS DMH_TAG_VRBL	TAG_ID = ID
After delete from DMH_TAGLIB	DMHTGLD1	Delete row or rows from	DMH_TAG DMH_TABLIB_VLDTR	TAGLIB_ID = FILE_ID
After delete from DMH_TAGLIB	DMHTGLD1	Delete row or rows from	DMH_REFS_JBC	FILE_ID = FILE_ID
After delete from DMH_TAGLIB_VLDTR	DMHVL1D1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 121
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 121
			DMH_VLDTR_PARAM	VALIDATOR_ID = ID
After delete from DMH_USERINPUTASSET	DMHTRUA1	Delete row or rows from	DMH_USRINASST_PRPS	ASSET_ID = ASSET_ID
After delete from DMH_USERINPUTLINK	DMHTRUL1	Delete row or rows from	DMH_USRINASST_SCOL DMH_USRINASST_TCOL	ASSET_ID = ASSET_ID
After delete from DMH_WAR	DMHWARD1	Delete row or rows from	DMH_EVENT_LISTENER DMH_FILTER DMH_SERVLET DMH_WAR_ENV_ENTRYS DMH_WAR_EJB_REF DMH_WAR_LCL_EJBREF DMH_WAR_RSRC_REFS	WAR_ID = FILE_ID
After delete from DMH_WAR	DMHWARD1	Delete row or rows from	DMH_REFS_JBC DMH_REFS_URL	FILE_ID = FILE_ID
After delete from DMH_WS_ENDPOINT	DMHWSED1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = FILE_ID AND (CMPNT_TYPE_ID = 129 OR CMPNT_TYPE_ID = 135 OR CMPNT_TYPE_ID = 136)
			DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = FILE_ID AND (ASSET_TYPE_ID = 129 OR ASSET_TYPE_ID = 135 OR ASSET_TYPE_ID = 136)
			DMH_REFS_URL	FILE_ID = FILE_ID
			DMH_WS_HANDLER DMH_WS_PORTCOM	ENDPOINT_ID = FILE_ID
After delete from DMH_WS_JAXRPC	DMHWSJD1	Delete row or rows from	DMH_WS_PKG_MAP DMH_WS_SEI_MAP DMH_WS_SRV_MAP DMH_WS_TYP_MAP	JAXRPC_ID = FILE_ID
After delete from DMH_WS_JAXRPC	DMHWSJD1	Delete row or rows from	DMH_REFS_JBC DMH_REFS_JBM	FILE_ID = FILE_ID
After delete from DMH_WS_SEI_MAP	DMHWSID1	Delete row or rows from	DMH_WS_MTD_MAP	SEI_ID = ID
After delete from DMH_WSDL	DMHWDLD1	Delete row or rows from	DMH_WSDL_BIND DMH_WSDL_IMPORT DMH_WSDL_PORT DMH_WSDL_PORTTYPE DMH_WSDL_SERVICE DMH_WSDL_TYPE	WSDL_ID = FILE_ID
After delete from DMH_WSDL_PORT	DMHWDPD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 134
After delete from DMH_WSDL_PORTTYPE	DMHWDRD1	Delete row or rows from	DMH_WSDL_OPR	PORTTYPE_ID = ID
After delete from DMH_WSDL_SERVICE	DMHWDSD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 130
After delete from DMH_WSDL_SERVICE	DMHWDSD1	Delete row or rows from	DMH_LINK_SOURCE DMH_LINK_TARGET	ASSET_ID_1 = ID AND ASSET_TYPE_ID = 130
After delete from DMH_WSDL_TYPE	DMHWDYD1	Delete row or rows from	DMH_CHANGE_IMPACT	RELATED_ID_1 = ID AND CMPNT_TYPE_ID = 133
After delete from DMH_XML	DMHXMLD1	Delete row or rows from	DMH_XML_ATTLIST DMH_XML_ELEMENTS	XML_ID = FILE_ID