DSXchange

We have XML_VALUE column as BLOB in Oracle Table and we are using LongVarBinary data type for this column in DataStage which is working fine. You may want to try this option. FYI, we are using Oracle Connector Stage in DS 9.1 and 11.3.

Hello All, I have a requirement where I want to pass a parameter value and a column value from the source and fetch the result from SAP table. If it returns the value then I have to use one logic using the return result and if it does not return any value back then I will have to implement another b...

Hello All, Below is my requirement related to inner XML block, -<s:LineItems> <s:Code>0000</s:Code> -<s:Values> <s:CodeValue>01</s:CodeValue> </s:Values> -<s:Values> <s:CodeValue>02</s:CodeValue> </s:Values> -<s:Values> <s:CodeValue>03</s:CodeValue> </s:Values> </s:LineItems> Below is what I am gett...

Hello All,

I have used UStringToString function to change this from Unicode to ANSI to resolve this issue. This is now giving me desired result.

Thanks.

Additional information: 1. Inside job we are using XML Output encoding as UTF8. 2. While storing the XML in BLOB using DataStage it is storing it as PC-Unicode type of file. However, SeeBeyond is storing it as PC-ANSI 3. We have removed 'Unicode' property from the Extended drop down under table defi...

Hello All, We are converting our applications from SeeBeyond to DataStage-9.1/11.3. In one of the Job we have to store XML objects in Oracle BLOB column. We have used LongVarBinary in datastage to map it to BLOB column in Oracle. There is some weird thing happening and we are unable to understand it...

Thanks Ray for your suggestions. I defined the "Value" column (Column-B) as a Key column in the Input of XML Output Stage and it gave me expected result.

Thanks Ray. Unfortunately, it is a single line XML block. Any solution for this scenario?

Thanks Ernie. To remove extra data elements in XML because of DummyKey I am looking for any option. So far I could not figure out any solution. Here is what I have to achieve: My XML structure <s:LineItems> <s:Code>2810945</s:Code> <s:Values> <s:DummyKey>123</s:DummyKey> <s:CodeValue>S</s:CodeValue>...

Thanks Ernie for your reply. I am just wondering, after adding dummykey element with it's value (counter 1,2,3, etc) in the XML data block, how to cleanup this from that XML block in the subsequent transformer? Are you suggesting to use function like ereplace and replace dummykey elelments with ZERO...

Hello All, I have below values in the source: COL-A COL-B 2810945 S 2810965 S 2810985 S 4025390 H 4041510 B 4041512 B I am expecting below XML structure <s:LineItems> <s:Code>2810945</s:Code> <s:Values> <s:CodeValue>S</s:CodeValue> </s:Values> </s:LineItems> <s:LineItems> <s:Code>2810965</s:Code> <s...

Thanks Ernie. I used option-2 and used Ereplace function to add the namespaces and it worked as expected. Thanks for your help!

Hello All, I am reading data from a table and creating XML blocks and storing in the Oracle target table as BLOB. I am using Oracle Connector Stage ==> XML Output Stage ==> Transformer Stage ==> XML Output Stage ==> Oracle Connector Stage to generate below XML. I am able to generate XML structure an...