DSXchange

I removed the namespace declatation and it worked. Thanks!

BTW, the version is 8.0

I have a Server job to read XML file and write into sequential file. The issue is, the job finishes successfully with no output. Is there any option i need to change in the XMLInput stage? XML Input file ---------------- <?xml version="1.0"?> <customers> <customer id="55000"> <na...

Is it possible to acheive it with in Datastage XML output stage? sed -e "/<name>/{N;N;/<\/name>/s/\n//g;}" -e "/<product_code>/{N;N;/<\/product_code>/s/\n//g;}" -e "/<quantity>/{N;N;/<\/quantity>/s/\n//g;}" -e "/<unit_price>/{N;N;/<\/unit_price>/s/\n//g;}" file

The XML output when opened in a notepad has new line charactes in between the open and close tags as below. <?xml version="1.0" encoding="UTF-8"?> <customers xmlns="http://www.cust.org/Customers" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="htt...

Thats is exactly what i am trying to find out if WAVES has been purchases or not. No one here seems to remember anything about WAVES. Datastage is installed on Unix. Any default folder i can look into to see if WAVES is installed? Any particular file i can search for? I doubt if you have purchased &...

Thanks, this works!!!

ray.wurlod wrote:Set the Change Mode property to Explicit Keys, All Values

Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you ...

Thanks for the repsonses..I will try them out..

The requirement is to capture changes at sequential file level (about 50 columns). Any column may have changes. Is there a way to capture the changes (insert, delete, update indicator) without specifying all 50 columns as keys in Change Capture stage?

There are sub categories under WAVES Rules (AT, AU, US etc - they are country codes i guess). unser each county , i find CLS, DCT, PAT, SET etc. I provisioned them all. I also have WAVES stage under 'Data Quality' palette.

The worst part is none out here know if WAVES was purchased or not. But I do see WAVES under the repository and assumed that it was purchased.

I am new to Datastage/Qualitystage. The requirement is to cleanse international addresses. I am using WAVES stage and I do not know what should to be given for 'WAVES database location' option. If I give any random UNIX directory, the error is receive is 'error opening file the bind.tx'. It is looki...