DSXchange

I would think all you would have to do is specific the data type as a Decimal and that would take care of your problem. Other than that you'd have to do some fancy substringing to determine if there is only one character to the left of the decimal and if that character is a zero and if so then subst...

I'm trying to figure out the best way to bring in a look up value into a transformer. My look up table is date bound so I want to look up the key appropriate key value so if my source has a "Service_Date" and my look up table is "My_Key, Start_Date, End_Date" and I'm joining in o...

Simple question, how to do you escape a literal string when concatenating in a transformer? This doesn't work: "<doc xmls=\"google.com\" >":DSLink1.col:"</doc>" As you can see I have a literal string that uses double quotes and I can't remember what the character is tha...

In the web service that I'm using, when I upload, the payload/message, which happens to be an XML document, on the receiving end the message has been HTML escaped so "<" becomes "&lt". Does anyone know how to prevent this? I found this thread, and the posted said they changed...

I too would like to know how you resolved the issue. Changing the encoding style? Where? How? to What?

Just so I can mark this topic as resolved the bug with the webservice was a namespace in the XML of my payload. So the XML SOAP object was all correct but then the payload that was being delivered, an XML document, that document need it's namespace declared in it. So the best explanation I can provi...

Does anyone know how to see the actual SOAP call the web service stage constructs? I'm doing some debugging why I'm getting an error like this: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: at com.ascentialsoftware.wsclient.WebService.callService(WebService...

How do you turn off row buffering? I'm having the same issue.

How do you increase the size of the row buffer??

Here's how you do it, and I'm not a premium poster so you should be able to read all of my message 8) Had the same issue once, and so I added a surrogate key with an extra xml tag in my group to make it unique so Datastage wouldn't roll up my results. (Granted roll up is probably the proper thing to...

I use the ODBC stage to read DBFs. Be sure though, sometimes I need to make sure that the CDX and FPT files of the databse are in the same directory of the DBF file that the ODBC connection is pointed to.

I haven't tested this but in the FTP stage, could you just define a file pattern like file_*.csv Other options would be to Use a sequence to loop through each file that needs processing. There's many ways you can define a list such as statically, OS scripting, or read in a master file from the FTP t...

Solved it! In the output column of the XML Output stage, define just a single column but in the Description (where you put the XPath when working with XML) just put a single / The datatype I've just left as Unknown and so far that's working. I now have a single sting of xml text that I can do whatev...

I'm looking for some help with the XML Output stage, so far I've just used the stage to write a file to the OS. So my job looks like this so far {Database} -> {Transformer} -> {XML Output} So the input tab of the XML Stage I write my XPath expressions and everything is working great. So the next thi...

Hey Community So I've come across a weird anomaly in Datastage that I can't figure out. I have a directory of symbolic links that point to a mounted drive. I use the Linux FIND command to make a comma delimited list that I can later loop through. find *.dbf | tr '\n' ',' I execute this in a sequence...