DSXchange

It's definitely something after the folder stage, I just don't know what. I tested with an ereplace() function after my folder stage to strip out \" and they're still there.

OK, the \ escaping each double quote makes sense. How do I stop it from doing that? Like I mentioned, when I'm testing "FolderStage --> Sequential File" I don't have that in my output, but "FolderStage --> RTI Output Stage" my SoapUI response contains the escape slashes and \r\n ...

I'm new to REST binding and put together my first test. The results data-wise I'm getting is fine, but I don't understand why it has the appended \r\n and extra slash characters all throughout the response. Is this normal or what controls that? I've tried both attaching the ISD_Output stage at the r...

I'm new to DB2 connectivity from DataStage using the DB2 Connector Stage and running into an issue with schema qualifiers. The existing SQL in our DataStage jobs don't require schema qualifiers on tables (Netezza). The SQL runs against the database table list as defined in the ODBC.ini file database...

Are you connecting via a tunnelling protocol, like Citrix? ... Myself (Client) and the IIS Server are on the same network, no tunneling. When I watch the "top" command, it's continuous "uvsh" and "sleep" commands at the top of the list. So it may just be our system is ...

Curious if this is normal or if we have an issue that could be resolved... I've noticed for a while now on our Production IIS 9.2 Linux server when using DataStage Designer it will frequently freeze/hang. I'll be typing a derivation when Designer hangs, then a few seconds later everything I typed qu...

Nice! The JDBC option works for us and we're on SUSE Linux 11 w/ IIS 9.1 I'll leave some notes here in case it helps anyone else searching on this. 1. Installed the IBM DasbDB driver connection software found within the "Downloads" section from the IBM DashDB Cloud Bluemix page (ie. ibm_da...

Looking for someone who can show me through personal experience how they configured DataStage 9.1 to connect to a Cloud DashDB instance? I'm following their documentation but having issues or some things aren't specifically clear. For example, I've got the DashDB Linux driver installed, but there ar...

Is there an XMETA repository query that can give me a unique list of all hashed tables referenced in hashed stages across all of our DataStage jobs? Or maybe an alternate method? I want to exclude system hashed tables, only hashed files put into the "File Name" field in hashed file stages

Had an issue where the database abnormally terminated the session and DataStage just spun this warning over and over and never actually aborted to start a new session. Interested in seeing if I could force this situation to rollover into a new instance. 7:03 AM [DataStage][SQL Client][ODBC]FATAL 1: ...

I can't seem to find a configuration anywhere, but is it possible to enable "Abort Job after x number of warnings" with a DataStage job enabled as a Web Service?

:oops: BAH! Another case of "discovered the fix immediately after posting a forum question"!. Let me share what I did. Simply adding a MinOccurs="0" to the XSD omits the parent element if the child element is omitted. <xs:element name="EMail" minOccurs="0"> <x...

I'm working with an embedded element and I want the entire structure omitted if the child element is NULL. I have "Omit Null Elements" checked, but it's only removing the child element and leaving the parent element. Is there a way to code this or the XSD to remove both the child and paren...

HA! Saw another member post about runtime performance issues with the XML stage and discovered the "enable logging" had an impact. I followed suit and disabled logging in my XML stage and the 17min runtime dropped to 45secs

Ok, I've got it working and getting the exact XML output that I want, but I'm concerned about the performance. My XML stage with the setup described below takes almost 17min to process 10,000 input records joined to 30,000 records generated by the Pivot Stage XML Composer Steps 1. Input - Link#1) Pr...