Defining UniData 6 Output Data

When you extract data from a UniData^® 6 data source, the UniData 6 stage has an output link. The properties of this link and the column definitions of the data are defined on the Outputs page in the UniData 6 Stage dialog box.

The Outputs page has the following two fields and four tabs:

• Output name. The name of the output link. Choose the link you want to edit from the Output name list. This list displays all the output links from the UniVerse^® stage.
• Normalize on. This list allows you to normalize (or unnest) data. You can normalize either on an association or on a single unassociated multivalued column. The Normalize on list is only enabled for nonreference output links where meta data has been defined that contains multivalued fields.
• General. Displayed by default. Contains the following components:
  • Table name. Contains the name of the tables being accessed. You can also use a job parameter to specify the table name.
  • Browse . Displays the Table Definitions dialog box, allowing you to choose a suitable table.
  • Description. Contains an optional description of the output link.
• Columns. Contains the column definitions for the data being output on the chosen link. Also specifies which columns are aggregated.
• Selection. Contains optional SQL SELECT clauses for the conditional extraction of data.
• View SQL. Displays the SQL statement used to extract the data from the chosen table or tables. You cannot edit the SQL statement, but you can use Copy to copy it to the Clipboard for use elsewhere.

Click View Data to open the Data Browser. This enables you to look at the data associated with the input link.