remove_imdc - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

The remove_imdc function removes a specified IMDC, if possible.

Syntax

SELECT * FROM remove_imdc (
  input
  imdc (imdc_name)
);

Input

Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).

Arguments

imdc
Specifies the name of the IMDC to remove.

Schema of Output

Column Name Description
TaskIdx Task index of the partition that hosts the data.
RemoveResult Function result, one of these values:
Value Meaning
Removed The IMDC was successfully removed.
Nonexistent The IMDC does not exist in the vworker.
Failed The attempt to remove the IMDC failed. (A specific failure message appears.)