Define the Physical Location of a Teradata File

You can use the File editor to define the physical location of a file that is used in a database for Teradata physical models.

To define the physical location of a Teradata file

  1. Click Files on the Database menu.

    The File Editor opens.

  2. Select a file and work with the following options:

    Note: Click New <New> icon in property editors on the toolbar to create a new file.

    Name

    Specifies the name of the file.

    Residence

    Specifies where the file resides. Select from the drop-down. Valid values are Client or Server.

    Note: CA ERwin Data Modeler will not support the specification of files on the client for functions, stored procedures, and methods.

    Teradata Type

    Specifies the type of file. Select from the drop-down. Valid values are: Include, Library, Object, Source, and Package.

    Name on Server

    Specifies the name of the file on the server.

  3. (Optional) Click the Comment tab and enter any comments you want associated with the file.
  4. (Optional) Click the UDP tab to work with user-defined properties for the file.
  5. Click Close.

    The File Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor