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.
-
Add the schema from the legacy DataStage flow to
the flow that you migrated.
- 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.
- Generate and save an XSD file (XML schema) from the copied information.
You
can use an online schema generation tool to generate the file.
- Open the migrated DataStage flow, then
double-click the Transformer stage to open it.
- On the Stage tab, click Edit
assembly.
- Open the XML parser step, click Open libraries, then click
New library +.
- 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.
- Open the new schema library, then click Add resource. Select
and upload the XSD file that you saved earlier and the click Close.
- Specify the document root for the XML parser step.
- On the XML parser step page, next to the Document
root field, click Browse.
- Select the table from the schema that you added to the library, then click
Apply selection.
- Specify the document root for the XML composer step.
- Open the XML composer step, then click Browse next to the
Document root field.
- Select the table from the schema that you added to the library, then click
Apply selection.
- Configure the mappings for the XML composer step.
- Open the Mappings tab on the XML composer
step page.
- From the Select target drop-down list in the
Source column, select "Top."
- Click the Auto map tab.
The mappings are
displayed.
- Open the Mappings tab on the Output step
page, then configure the mappings for the output step based on your DataStage flow.
- On the Output step page, click the Output
column tab. Then, configure the output column for the output step based on your DataStage flow.
- Configure the source file for the flow by changing the parameter values as needed after
migration.
- Run the flow.