XML Writer and Output Stage

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

XML Writer and Output Stage

Post by admin »

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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

XML Writer and Output Stage

Post by admin »

Hey Kiran,

How are things at the Hartford? I get ODS error email messages every now and then and think about you guys. Looks like you're working on those product files for Anne's team. How's that going? Not sure why you're having that problem. I take it the data is sorted by invoice?


ksurapan@hartfordlife.com wrote:









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

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

XML Writer and Output Stage

Post by admin »

have a look at viewtopic.php?t=86240&highlight=xml

topic: How to write XML tags which occur more than 1 time
....cmueller's response did the trick for me!


-----Original Message-----
From: Tony Curcio [mailto:tonycurcio@yahoo.com]
Sent: 23 February 2004 14:45
To: DataStage Users Discussion List
Subject: Re: XML Writer and Output Stage


Hey Kiran,

How are things at the Hartford? I get ODS error email messages every now
and then and think about you guys. Looks like you're working on those
product files for Anne's team. How's that going? Not sure why you're
having that problem. I take it the data is sorted by invoice?


ksurapan@hartfordlife.com wrote:









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

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users


This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended addressee, you must
not disclose, copy or take any action in reliance of this transmission.

The Company reserves the right to monitor all telecommunications that make
use of or passes through the Company facilities. This includes, but is not
limited to, E-mail, Internet, Facsimiles, Company Telephones and Company
Mobile Telephones. Please be advised that your telecommunication may be
intercepted, read, copied, deleted or retrieved by authorised personnel,
other than the sender or recipient of the original telecommunication, as
the Company sees fit.

Although this message and its contents have been scanned for viruses and no
viruses were detected, no responsibility whatsoever is accepted by the
Company, or any of its offices or companies for any loss or damage
arising in any way from receipt or use thereof.

If you have received this email in error please delete this message and
notify the Polk System Administrator at postmaster@polkglobal.com.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked