DSXchange

Hi - Sorry for the 6 months delay but we abandoned this project and restarted working on it now. So, at this stage the update is we were able to successfully establish a connection using Hive Connector in the sense that the "TEST" connection returns a successful message. Then we built a si...

Hello - We are on datastage ver 11.5 parallel running on linux. We have Dev, QA, and Prod servers but we noticed that datastage director monitor is properly displaying row counts in our Prod and QA servers but not in Dev server. So when you go to Director and right-click on any job in Finished/Abort...

Sorry, could not figure out how to post my own topic at first. Thank you for deleting the other two.

THANK YOU! It seems to work and I hope it captures all special characters. Only time will tell....I will come back here if I face further problems.

Hello - Anyone worked on removing special characters coming from DB2 and Ms Sql Server databases? Basically the special character can be anything thats not an alphabet/number or anything thats not on the keyboard. How would I go about writing something in Datastage v8.7 Parallel that would parse an ...

The problem is not just with how the data looks in view data but how it appears in the seq file being created. All numeric data whether integers or decimal numbers are appearing in the file with unnecessary leading and trailing zeroes. One way to handle that would be to use DecimalToString(column_na...