Search found 10 matches

by Gopi Krishna
Tue Feb 04, 2014 4:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Zero or More repetitive elements from XML
Replies: 1
Views: 1657

Reading Zero or More repetitive elements from XML

Hi All, We are using Serice Director to use the DS job as a service. So we will receive the SOAP request as an input and my job will read the request and it will standardize the data and will gives the response. Following is the sample SOAP req which i will receive. <organization> </organizationReco...
by Gopi Krishna
Wed Dec 11, 2013 8:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process XML file with repetitive elements using the X
Replies: 6
Views: 3653

Hi Ernie, Thanks for the response. I dont have premium membership but i got what you are saying here. Basically you are suggesting to use HJOIN in XML stage but it will demand for two inputs as i know. My question is on what basis we need to split the single input xml file into two files and what st...
by Gopi Krishna
Wed Dec 11, 2013 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process XML file with repetitive elements using the X
Replies: 6
Views: 3653

Hi Nayan,

Thanks for the response.

Even if you check that it will ask you for the key for repititon there you can see only one column for repetition but in my case I need to do repetition on more than one column.
by Gopi Krishna
Wed Dec 11, 2013 7:35 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Passing repetitive elements from SOAP request to ISD stage
Replies: 7
Views: 8672

Hi Ernie, Thanks for the response. As you said, there could be 2 phone numbers and 5 emails or other unrelated combinations of email/phone numbers in the sets. But all those emails and phone numbers will belong to one single organization. At a time we will have one single organization information in...
by Gopi Krishna
Tue Dec 10, 2013 12:45 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Passing repetitive elements from SOAP request to ISD stage
Replies: 7
Views: 8672

Hi Ernie

Thanks for the response.

Right now I don't have Premium Membership so I am not able to see what you are saying here. Can anybody help me in getting this.

Thanks !
by Gopi Krishna
Fri Nov 29, 2013 3:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create XML file with repetitive elements using XML st
Replies: 3
Views: 3021

Hi Michael

Thanks for the response. Right now i am running the job with minimal validation only even though facing the issue.
by Gopi Krishna
Thu Nov 28, 2013 12:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create XML file with repetitive elements using XML st
Replies: 3
Views: 3021

How to create XML file with repetitive elements using XML st

I have a sequential which contains the data as below. EmpName,phonenumber,email xyz,12345,xyz@xyz.com xyz,12345,abc@abc.com xyz,56789,xyz@xyz.com xyz,56789,abc@abc.com I have to prepare an XML file with repetitive elements from this data as below. <Emp> <EmpName>XYZ</EmpName> <Phonenumber>12345</pho...
by Gopi Krishna
Thu Nov 28, 2013 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process XML file with repetitive elements using the X
Replies: 6
Views: 3653

How to process XML file with repetitive elements using the X

Hi All, I have the following XML file and need to convert the XML data into reguler records. <Emp> <EmpName>XYZ</EmpName> <Phonenumber>12345</phonenumber> <phonenumber>56789</phonenumber> <email>xyz@xyz.com</email> <email>abc@abc.com</email> </Emp> All the data belongs to one single employee. no res...
by Gopi Krishna
Thu Nov 28, 2013 12:49 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Passing repetitive elements from SOAP request to ISD stage
Replies: 7
Views: 8672

Passing repetitive elements from SOAP request to ISD stage

Hi All, In My current project we are calling the web service methods from Datastage which are implemented in JAVA.But before calling the webservice method i need to standardize the data which is coming as part of the SOAP request and then need to pass the standardized data to the web service method ...