Usage
Deletes a previously defined object from the EDMM.
Syntax
DELETE { NODE | HOST | SERVER | DISTRIBUTION | PATHGROUP | SCHEDULER | ROUTING_SET | METHOD | CONVERSION_TABLE } object-name, ...;
DELETE REQUEST name FROM DISTRIBUTION distname ;
DELETE USER name AT [SERVER] name ;
DELETE TABLE MAPPING
TARGET fulltablename AT [SERVER] servername
FROM SOURCE fulltablename AT [SERVER] servername
;
DELETE JOINED TABLE AT [SERVER] servername
TARGET fulltablename FROM fulltablename
;
DELETE FILE MAPPING
TARGET FILE filename AT [SERVER] servername
FROM SOURCE fulltablename AT [SERVER] servername
;
Example
DELETE TABLE MAPPING
TARGET ricks.wmlrvg.CLAIMS AT SERVER orsonmsss
FROM SOURCE ricks.qadba.CLAIMS AT SERVER goodman
;
DELETE JOINED TABLE AT SERVER goodman
TARGET ricks.qadba.CLAIMS90
FROM ricks.qadba.CLAIMS
;
DELETE FILE MAPPING
TARGET FILE ricks.wmlrvg.CLAIMS AT SERVER orsonmsss
FROM SOURCE ricks.qadba.CLAIMS AT SERVER goodman
;