RemoveExportDefinition - Teradata Database

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);