15.00 - RemoveExportDefinition - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

RemoveExportDefinition

Purpose  

Removes a user-defined export width definition.

Syntax  

where:

 

Syntax element …

Specifies …

SYSLIB

the name of the database where the stored procedure is located.

export_definition_name

an existing user-defined export definition name.

You cannot specify 'Expected', 'Compatibility', or 'Maximum'.

result_message

the output message of the stored procedure.

Authorization

You must have EXECUTE privileges on the stored procedure or on the SYSLIB database.

Argument Types

Expressions passed to this procedure must have the following data types:

  • export_definition_name = VARCHAR(n) CHARACTER SET LATIN, where the maximum value for n is 30.
  • result_message = VARCHAR(100) CHARACTER SET UNICODE
  • You can also pass arguments with data types that can be converted to the above types using Teradata Database implicit data type conversion rules.

    Usage Notes

    To delete an existing user-defined export width definition, call the RemoveExportDefinition stored procedure with the following arguments:

  • export_definition_name is a LATIN character string that specifies the name of the existing export width definition you want to delete.
  • result_message is an output parameter that contains the output message of the stored procedure.
  • RemoveExportDefinition deletes the specified export width definition from the DBC.ExportWidth table.

    Note: You cannot specify 'Expected', 'Compatibility', or 'Maximum' for export_definition_name. In addition, you cannot delete an export width definition if it is assigned to a user.

    Example  

    The following statement deletes the user-defined export width definition named MyExportWidth.

    CALL SYSLIB.RemoveExportDefinition('MyExportWidth',msg);