Configuring a Write Schema

You can configure write schemas using Business Object Editor.

Procedure

  1. Configure attributes in the Write Business Object.
    For detailed information about these attributes, see Write Schema Configuration Reference.
  2. Edit attributes.
    Attributes are editable. You can change the fields of the attributes or change the number of attributes.
    Note: If you want to make significant changes to WriteSchema(Classic), you can regenerate the write schema rather than edit it.
    • To edit an attribute, click the attribute.
    • To add an attribute, click Add.
    • To remove a field, click Remove.
    • To shuffle fields, click Up or Down.
    • To set default value for an attribute, right-click the attribute.
  3. Modify the relationship of file records in a write schema.
    The write schema reflects the relationship of the file records. The relationship in the write schema determines the sequence of lines that are generated in the output file.
    For example, if the write schema is defined as follows:
    WriteSchema
    	FileRecord_Parent
    		FileRecord_Child_1
    			FileRecord_Child_2
    		...
    		...
    The sequence of the lines in the output file is:
    FileRecord_Parent
    	FileRecord_Child_1
    	FileRecord_Child_1
    	...
    		FileRecord_Child_2
    	...
    	...
    You can rearrange the order of the child records of a write schema. Right-click the child record you want to change, select Move Up or Move Down in the pop-up menu to change the order.

    Once you change the order of the child records of a write schema, the child records are written to a file in the exact same order as you have configured for the write schema at design time.

    Note: If you have set the adfiles.toggleChildRecordsOrdering property in the TRA file, and then rearrange the order of the child records in TIBCO Business Studio, the property setting has no effect.

    If you have enabled the adfiles.toggleChildRecordsOrdering property for projects created in earlier versions of 6.2, you can also run the projects successfully in this release.

    When you have to write child records as part of a parent record, you can promote a child record. A promoted child becomes a field of type record in the parent record.

    Conversely, you can demote a promoted child record.