Configuring the Hierarchical stage after migration in DataStage

After you migrate a flow from legacy DataStage®, if the flow contained an XML Transformer stage, you must configure the Hierarchical stage that it is converted to by the migration service.

About this task

When you migrate a flow from legacy DataStage that contains an XML Transformer stage, the migration service automatically converts the stage to the Hierarchical stage. You must configure the Hierarchical stage before you can run the flow successfully.

The following example procedure shows how to configure the Hierarchical stage in a DataStage flow. The stage contains an XML parser step, XML composer step, and output step. The flow writes to a Peek stage.

Procedure

  1. Add the schema from the legacy DataStage flow to the flow that you migrated.
    1. Open the legacy DataStage job, then copy the XML output.
      This method is one way to copy the schema information. You can also use a different method.
    2. Generate and save an XSD file (XML schema) from the copied information.
      You can use an online schema generation tool to generate the file.
    3. Open the migrated DataStage flow, then double-click the Transformer stage to open it.
    4. On the Stage tab, click Edit assembly.
    5. Open the XML parser step, click Open libraries, then click New library +.
    6. In the New schema library window, specify a name, optional description, and optional folder name. Then, click Add.
      The new schema is shown in the list of library items.
    7. Open the new schema library, then click Add resource. Select and upload the XSD file that you saved earlier and the click Close.
  2. Specify the document root for the XML parser step.
    1. On the XML parser step page, next to the Document root field, click Browse.
    2. Select the table from the schema that you added to the library, then click Apply selection.
  3. Specify the document root for the XML composer step.
    1. Open the XML composer step, then click Browse next to the Document root field.
    2. Select the table from the schema that you added to the library, then click Apply selection.
  4. Configure the mappings for the XML composer step.
    1. Open the Mappings tab on the XML composer step page.
    2. From the Select target drop-down list in the Source column, select "Top."
    3. Click the Auto map tab.
      The mappings are displayed.
  5. Open the Mappings tab on the Output step page, then configure the mappings for the output step based on your DataStage flow.
  6. On the Output step page, click the Output column tab. Then, configure the output column for the output step based on your DataStage flow.
  7. Configure the source file for the flow by changing the parameter values as needed after migration.
  8. Run the flow.