DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Mon Feb 23, 2004 8:40 am Reply with quote    Back to top    

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

_________________
PLEASE READ
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
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Mon Feb 23, 2004 8:44 am Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Mon Feb 23, 2004 8:55 am Reply with quote    Back to top    

have a look at http://www.dsxchange.com/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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours