Flat File Properties

You can modify an object's properties from its property sheet. To open a flat file property sheet, double-click its diagram symbol or its Browser entry in the Flat Files folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for flat files.

The General tab contains the following properties:

Property

Description

Name

Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users.

Code

Specifies the technical name of the object, which is used for generating code or scripts.

Comment

Specifies a descriptive comment for the object.

Stereotype

Extends the semantics of an object derived from existing objects but specific to your needs. You can enter stereotypes directly in this field, or add stereotypes to the list by specifying them in your model's resource file or in an extended model definition.

Separator

Specifies a column separator. You must select the Custom Delimiter mode in order to select a predefined value or enter a new one.

Row delimiter

Specifies a row delimiter, which separates records. You must select the Custom Delimiter mode in order to select a predefined value or enter a new one.

Header

Specifies whether you want to retrieve the column headers of the file whose path is specified in the Path field.

Mode

You can choose one of the following values:


  • CSV (Comma Separated Value) – Specifies a file which contains tabular data, and which uses a comma to separate values. When you select this option, the Separator field and the Row Delimiter field are not available.

  • Custom Delimiter – Lets you specify a column separator and a row delimiter to separate records.

  • Fixed Length – Lets you specify a row delimiter to separate records. When you select this option, the Separator field is not available.

Path

Specifies the path to the file containing data. Click the Select File tool to the right of the field to browse for a file.

Type

Type of the transformation process, when defined in a XEM attached to the model.


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com