Skip to Main Content
Return to Navigation

Using Table Definitions

Table definitions are:

You need a table definition for each data source stage or data target stage you use in your job. You can import, create, or edit a table definition using DataStage Designer.

Creating Table Definitions

To create a new Table Definition, select New Table Definition from the Table Definition menu. The Table Definition window appears:

Image: Table Definition Window

This example illustrates the Table Definition Window.

Table Definition Window

The Table Definition window has these tabs:

  • General

    The General tab contains the data source type, data source name, table or file name, and other general information about the table definition.

  • Columns

    The Columns tab contains a grid displaying the column definitions for each field in the table definition.

  • Format

    The Format tab contains file format parameters for sequential files used in DataStage jobs

  • Relationships

    The Relationships tab displays the details of any relationship this table definition has with other tables, and allows you to define new relationships.

  • NLS

    If NLS is enabled, the NLS tab is enabled and contains the name of the map to use for the table definition.

  • Layout

    The Layout tab displays the schema format of the column definitions in a table.

  • Locator

    Using the Locator tab you can view and edit the data resource locator associated with the table definition. The data resource locator is a property of the table definition that describes the real world object from which the table definition was imported. The labels and contents of the fields in this window depend on the type of data source or target from which the locator originates.

  • Analytical Information

    The Analytical Information tab displays information about the table definition generated by Information Analyzer.

  • Parallel

    The Parallel tab displays detailed format information for the defined metadata for parallel jobs.

Importing Table Definitions

You can directly import a table definition from a source or target database. You can import table definitions from ODBC data sources, plug-in stages, UniVerse tables, hash files, UniData files, or sequential files.

In the DataStage Designer Repository window, right-click on Table Definitions. Select Import.

You can select the type of table definition data source from the available options.