Show TOC

Error Tables (Teradata)Locate this document in the navigation structure

Teradata can record errors encounterd when writing to a data table in an error table associated with the data table. Error tables are supported for Teradata v12 and higher. PowerDesigner models error tables as extended objects with a stereotype of <<ErrorTable>>.

Creating an Error Table

You can create an error table in any of the following ways:

  • Select Start of the navigation path Model Next navigation step Error Tables End of the navigation path to access the List of Error Tables, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select Start of the navigation path New Next navigation step Error Table End of the navigation path.

Error Table Properties

You can modify an object's properties from its property sheet. To open an error table property sheet, double-click its diagram symbol or its Browser entry in the Error Tables folder.

The following extended attributes are available on the General tab:

Name

Description

Owner

Specifies the name of the database containing the error table.

Scripting name: Owner

Data table

Specifies the data table for which the error table is being created.

Scripting name: DataTable

Use name at generation

Specifies that the error table will be generated with its name.

Scripting name: HasName