DSXchange

Hi,

Could anyone please let me know on how to invoke a Java class from Datastage.

The requirement is to invoke a java class and use its properties from Datastage and then propagate the records in the form of XML.

Amy help on this will be very helpful

What kind of Collation should be used to accept chinese characters in SQL server 2005 DB? If any pointers were available then it would be very helpful.

Thanks,
Corvus

The Project Default NLS is UTF-8 and the Stage NLS used to view data is also UTF-8.

I am now able to populate Chinese characters from DB2 UDB 9.1 to DB2 UDB 9.1. Although it is not showing up in "View Data". But in MS SQL Server 2005 the characters are showing as "�" The Project Default NLS is UTF-8 and the Job stages are also using UTF-8 as NLS. The Locale set ...

The Datastage Project is setup with Default NLS as UTF-8. The DB2 UDB 9.1 dbs are unicode databases with Codeset = UTF-8 and CodePage = 1208.

Datastage is populating "??" instead of chinese characters.

PLEASE HELP !!!

yes i tried using stored procedure stage but it asks for an ODBC connection to the DB2 database. We do not connect to DB2 using ODBC connection as standard adopted by the organisation. How do I connect the stored procedure stage without using ODBC? Is there a way?

Hi,

I need to call a DB2 stored procedure from Datastage 8.0.1 on unix.
The procedure should be called using a DSDB2 connection instead of ODBC connection.
Is there anyway where we can achieve the same without using an ODBC connection?

Thanks.

Hi, I came accross a requirement to Extract / Load data to / fro SalesForce.com (SFDC). Is there a component stage available from IBM to integrate with SFDC. Is this free of cost or would require licensing. Is there any critical design issues which should be kept in mind when coupling DS 8 with SFDC...

Hi, I did try with NLS Map ISO8859-1 and ISO8859-1+MARKS. I am receiving the following warning and the row is being rejected. However, using these two NLS maps I am able to view the pound character in the source stage but it is not getting inserted using the same NLS. Warning: ------------------ Row...