DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 222 matches
Author Message
 Topic: Integrating an iLOG Jrules (ODM) stage with a Java XOM
parag.s.27

Replies: 0
Views: 80

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 11, 2018 9:20 am   Subject: Integrating an iLOG Jrules (ODM) stage with a Java XOM
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
All,

Till date we have been using the ODM Jrules stage in the capacity of Dynamic XOM with the input as XML payload. Recently we have received a ODM Ruleset Jar as a Java XOM. We are not able to in ...
 Topic: XML construction for repeating duplicate values
parag.s.27

Replies: 1
Views: 396

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 24, 2017 8:27 am   Subject: XML construction for repeating duplicate values
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi,

I have a data condition where a customer has multiple addresses and phone numbers. I have a flat data set which looks like: -

ProfileID1 Address1 Phone1
ProfileID1 Address1 ...
Resolved
 Topic: XSD for the DataStage XML job report
parag.s.27

Replies: 4
Views: 1171

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 02, 2017 11:30 am   Subject: XSD for the DataStage XML job report
Thanks for the reply.

I thought about it and then created my own XSD and used XML parser. It is working as expected
Resolved
 Topic: XSD for the DataStage XML job report
parag.s.27

Replies: 4
Views: 1171

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 01, 2017 2:56 pm   Subject: XSD for the DataStage XML job report
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi,

I am trying to automate the process of documenting the DataStage job details such as

1. what all stages are used
2. If DB connector is used then what is the query/table used
3. what prope ...
 Topic: XML output stage in 8.1 is unnecessarily grouping elements
parag.s.27

Replies: 4
Views: 2408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 23, 2013 1:10 am   Subject: XML output stage in 8.1 is unnecessarily grouping elements
Hi,

I cannot use aggregate because the H1Party Node which is the key, repeats with each ORParty (repeating element) element. My requirement is to have the H1 party node appearing only once which ca ...
 Topic: XML output stage in 8.1 is unnecessarily grouping elements
parag.s.27

Replies: 4
Views: 2408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 20, 2013 7:59 am   Subject: XML output stage in 8.1 is unnecessarily grouping elements
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
All,

I have a task where I have a complex set of repeating elements that are expected in the XML message going to MQ. I have been trying for 2 days now but I am seeing that for the complex repeatin ...
 Topic: Issue in reading data with CFF stage for binary file
parag.s.27

Replies: 0
Views: 1115

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 13, 2011 10:50 am   Subject: Issue in reading data with CFF stage for binary file
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
After reading many posts we still could not find the solution hence posting it here.

We are trying to read a mainframe file using CFF stage. In the input binary file we are receiving "!" sign as pa ...
 Topic: Reading ,Writing German and Portuguse data from Datastage
parag.s.27

Replies: 4
Views: 3817

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Aug 14, 2011 9:15 pm   Subject: Re: Reading Brazil and Portuguse data from Datastage
I think you need to see the database settings. The Brazilian and Portugese data will mostly be a double byte character set which may not be written through DataStage using UTF-8.
Resolved
 Topic: Resolving Special characters in XML
parag.s.27

Replies: 9
Views: 7429

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Aug 14, 2011 9:02 pm   Subject: Resolving Special characters in XML
That is so true Ernie. Though I've been working with XML and WSDL in IIS for quite some time now, but every day is a new learning. I am just loving, how you can implement many things in DataStage whic ...
Resolved
 Topic: Resolving Special characters in XML
parag.s.27

Replies: 9
Views: 7429

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 11, 2011 3:36 pm   Subject: Resolving Special characters in XML
Though I got partial success but I think I'll resolve it further. By partial success I meant that in Internet explorer it is showing the entire element as text(in black color) but on Tibco side it is ...
Resolved
 Topic: Resolving Special characters in XML
parag.s.27

Replies: 9
Views: 7429

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 11, 2011 2:30 pm   Subject: Resolving Special characters in XML
Thanks Chulett for your time.

I resolved it in a cleaner way. The Idea is similar to what you said.
Resolved
 Topic: Resolving Special characters in XML
parag.s.27

Replies: 9
Views: 7429

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 11, 2011 2:09 pm   Subject: Resolving Special characters in XML
What I wanted to say is, if Data Element property is set then as you said, DataStage will not handle the Special characters such as &, <, > etc in that element.

Also if I have some repeat ...
Resolved
 Topic: Resolving Special characters in XML
parag.s.27

Replies: 9
Views: 7429

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 11, 2011 1:03 pm   Subject: Resolving Special characters in XML
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
We are facing an issue with special characters coming in XML message. For e.g. "&","<",">" etc. Now these special characters are automatically handle by DataStage for all the elements except ...
 Topic: Avoid sending null elements in XML message
parag.s.27

Replies: 11
Views: 10933

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 18, 2011 2:18 pm   Subject: Avoid sending null elements in XML message
I know about this setting, but on XML side only those elements should be dropped for which "min occur = 0", or basically the element is optional. In some cases the element is mandatory but it can acce ...
 Topic: Avoid sending null elements in XML message
parag.s.27

Replies: 11
Views: 10933

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 18, 2011 11:52 am   Subject: Avoid sending null elements in XML message
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
We have been dealing with XML messages using DS 8.1 for more than 2 yrs now. Did not switch to 8.5 yet.

We have found one typical issue in the integration of DataStage using MQ with any workflow b ...
 

 Jump to:   



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