DSXchange

Hello DataStage gurus, I have a problem with a parallel job that uses a web service and the error message is per below: Web_Services_Transformer_6: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/enve...

Hallo gurus, this is a follow up topic to ODBC Connection to MSSQL Server 2000 which I have resolved but have been trying for the last two days. I have configured the ODBC connection on AIX server that runs DS, but I just want to find out if is there any configuration that must be done on Win 2K sid...

Hello Gurus, I've tried to search the previous postings but to no evail.I need help on setting up ODBC connections from AIX to a SQL Server 2000 db running on a Windows environment. I have edited the dsenv,.odbc.ini and uvodbc.config files with the relevant parameters. I also copied the uvodbc.confi...

Thank you all for your responses, I will use the JavaPack as the business rules are already built in Java (for reusability). Your help is always appreciated my gurus.

Hello DS Gurus, I need to design something on DataStage that can enable me to check some business rules by calling a Java class before it is written to a Dataset (table). I had a check on some previous postings and JavaPack was mentioned. I would to find out is there anyone who has done something li...

Thanks Ray I'll try that...

Hi guys, I need to load more than one file into DB2 tables using Datastage, I tried using the Folder stage but everything was written into one line and my sql script to extract substrings in the file so as to pupulate my table field failed. Is there any other stage I can use to achieve this in a bes...

Hi all. I'm new in Datastage development and I need to migrate data from a staging table to a final table on DB2. I need to only export data that conform to the business rules to the final table and all the rest sent to an error table. How can I achieve this, is Reject table appropriate for this and...