DSXchange

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 integrate the Java XOM because the Ruleset name in the input expects one value and the Java XOM has many ...

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 Phone2 ProfileID1 Address2 Phone1 ProfileID1 Address2 Phone2 When I am constructing the XML messages via XML composer, the ...

Thanks for the reply.

I thought about it and then created my own XSD and used XML parser. It is working as expected

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 properties are selected for real time stages etc I am generating the DataStage job report from designer by selecti...

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 cannot happen in Aggregate becuase it will create those many business Payload nodes. So I get something l...

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 repeating elements, the value is automatically getting deduped - grouoped even though the trigger column is som...

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 part of FIRST_NAME column as per the mainframe system DB2 table. When we are reading this file ...

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.

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 which are not part of IIS architecture

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 able to parse it but not completely because I did not send all elements for testing. I used somethin...

Thanks Chulett for your time.

I resolved it in a cleaner way. The Idea is similar to what you said.

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 repeating elements then I need to perform some transformations in a transformer prior to XML stage to create a repe...

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 the "repeating elements". I could figure out that issue is happen...

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 accept the empty tag. I am not sure whether DataStage can itself determine based on the XSD th...

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 based tools such as TIBCO. For e.g if an element in XSD is having a Date Time data type, then TIBCO will ...