Creating a flat file schema

About this task

To create a Flat File Schema:

Procedure

  1. Select the Project tab from the Toolbox located on the right side of the main Studio pane.
  2. To create a new Flat File Schema, choose from one of the following options:
    • In the Project tab, right-click the Flat File Schemas folder and from the list select New Flat File Schema.
    • In the Project tab, click New Flat File Schema (New flat file schema icon in shape of a piece of paper with a green plus sign in the top right corner ).
    The Basic Wizard dialog box is displayed.
  3. Enter a valid node name for the Flat File Schema in the Name field.
  4. Optional: If you want to use an existing Flat File Schema as a starting point, select the Inherit from an existing Flat File Schema check box. Click [...] to browse for the existing Flat File Schema from the Project Explorer dialog box, and click OK.
  5. Click OK and press Enter. The Flat File Schema Editor opens and the Flat File Schema is displayed beneath the Flat File Schemas folder in the Project tab.  In addition, a root node of the same name as the one shown in the Schema Layout tab.
  6. Configure the root node:
    1. Click the root node in the Schema Layout tab. The properties for the root node are displayed.
    2. Configure the root node properties.
  7. Define the records, fields, and groups of the Flat File Schema for your Flat File data. Start from the outermost structure of data and work inwards. For an example on how to build a Flat File Schema from data see Mixed positional and delimited example or the "Developing the BookOrder Project" section of the Getting Started Guide.
  8. Optional: You can select the Type Library tab and define the shared record types, group types, and field types for the data:
  9. Select the Schema Layout tab, and add records, groups, and fields to the root node:
    • Add a Record to define the major components of the message or for fields with complex structure.
    • Add a Group to define a set of records or groups that repeat as a set.
    • Add a Field to define the data within each record.
    • Add Several Children, of any type, to quickly build the content of records or groups.
  10. Test the Flat File Schema.

    The icons representing fields, field types, records, record types, groups, and group types are displayed in the Schema Layout and Type Library tabs as shown in the following table:

    Node Type Icon Displayed in Tabs
    Field or field type that is not based on a field type
    Field or field type that is based on a field type
    Record or record type that is not based on a record type
    Record or record type that is based on a record type
    Group or group type that is not based on a group type
    Group or group type that is based on a group type



Feedback | Notices


Timestamp icon Last updated: Thursday, December 17, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/creating_a_flat_file_schema.html