DSXchange

Hi,
Is there any option to Debug PX jobs by setting Break points.

I am trying to load a SQL Server table from another SQL Server source table (Its a direct copy). Source table is having three timestamp fields. While Viewing source data form Dynamic RDBMS stage, I am able to view data (including timestamp, in the format of 2004-11-23 00:38:24.000). While running th...

Is Substrings() function available with DS EE(PX).

Thanks ray.
I will try with DRS.

In StoredProcedure (STPPX) stage Genral tab,under Database Vendor drop down list I am seeing Oracle only.
How can I invoke a SQL Server Stored procedure through the StoredProcedure Stage.

Hi Sumit,
Could check someone unchecked/disabled (by chance) "Allow Multiple Instance" property in Job Properties General Tab.

Yes, avoid that sub query and make a simple join.
While writing user defined SQLs in DS jobs, try to avoid using functions (Eg: DATE() etc.,) in WHERE clause.

Hi, One of our source is frontend CRM application (Third party application by LexisNexis Interface Software). CRM DB is on Oracle. We are having DataStage 7.5 Enterprise Edition. Do we need any special PACKs to access this data. We don't have any PACKs available. Could anyone explain how can I acces...

Thanks Ray

Hi Ray,
Thanks for your response.
I found a new plug-in SQL Server Enterprise stage in DataStage 7.5 Enterprise Edition (PX) documentation. I am confusing in this regard. Could you suggest the best.

Hi,
If we change uvodbc.config and .odbc.ini in DS Home directory,
do we need to restart DataStage Server?

Hi,
We have DataStage 7.5 Enterprise Edition(with PX). Target DB is on SQL Server 2000 Database.
Is there any specific plug-in stage for SQL Server 2000 connectivity. We are looking for the best stage for SQL Server connectivity.

Thanks Bryan and Ray.

Hi All, We have DataStage6.0 Server edition on IBM AIX 5.1 server(Eg:123.312.12.111) SQL Server 2000 DB(DB name is "MYDB") is on Windows NT server(Eg:110.211.10.121). I would like to configure SQL Server 2000 ODBC driver and Set-up DB connection on DS 6.0(Unix) server. Could anyone explain...

Thank you Ray and Vmc..
Regards