XML Writer and Output Stage
Posted: Mon Feb 23, 2004 8:40 am
Hi there,
We are using DataStage 6.0.1 and I installed xml pack 2.0 and trying to
create an xml output. I am facing a problem where there are multiple
products for an Invoice and I do not know how to repeat the tags for
the products. The output records looks like this.
1
2004-02-20
56789.98
Y
-
12
ABCS
63
1
2004-02-20
56789.98
Y
-
45
DUEF
48
But I want the output in the following format where the Product is
repeating for the same Invoice.
1
2004-02-20
56789.98
Y
-
12
ABCS
63
45
DUEF
48
The Invoices and the Products are two hash files in the job which are
joined in the transformer and sent out to XML writer stage.
Do I have to pass the output to the Sequential file stage from the XML
Writer stage?
Could someone suggest me to get around this problem ASAP please.
Thanks
Netboyks.
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
We are using DataStage 6.0.1 and I installed xml pack 2.0 and trying to
create an xml output. I am facing a problem where there are multiple
products for an Invoice and I do not know how to repeat the tags for
the products. The output records looks like this.
1
2004-02-20
56789.98
Y
-
12
ABCS
63
1
2004-02-20
56789.98
Y
-
45
DUEF
48
But I want the output in the following format where the Product is
repeating for the same Invoice.
1
2004-02-20
56789.98
Y
-
12
ABCS
63
45
DUEF
48
The Invoices and the Products are two hash files in the job which are
joined in the transformer and sent out to XML writer stage.
Do I have to pass the output to the Sequential file stage from the XML
Writer stage?
Could someone suggest me to get around this problem ASAP please.
Thanks
Netboyks.
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users