Error Tables (Teradata)

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 Model > Error Tables 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 New > Error Table.

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

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