DSXchange

Thanks John, will do the necessary changes and try the scripts out.

We have a need to replace a DB2 stage in a Datastage job with a Teradata stage. As we have lot of jobs to convert. We thought of exporting the jobs as XML and replacing the stages with the help of some scripts. Is it possible for me to get some insights on how the XML is structured & how to go a...

Hi, We use a ODBC stage to execute a stored procedure in SQL Server. The sp inserts and updates a table. All rows passing from the transformer are expected to be inserted. But, only few rows are getting inserted. We don't get any warnings or any other hint regarding the rejected rows. We compared th...

Refer:
viewtopic.php?t=111890&highlight=varbyte

Yes DSGuru. The SP is called at the target level.

Got this resolved. There was a problem with the DB. DBA resolved it.

My server version is 7.5.1.A. But the pdf says it supports DB2,Oracle and Sybase. But will give that a try.

STP stage doesn't support SQL Server, right?

No warning messages DSGuru :cry: Yes it is getting too hard for me.
I am looking for a way that would give me more log messages.

Hi, I am calling a SQL Server stored procedure using an ODBC stage. The stored proc is inserting rows in few tables. The job runs to successful completion but there were no rows inserted. When the stored procedure is executed via query analyser it is inserting rows. I am not able to find out what is...

Thanks all for replies. I'll mark the topic as resolved.

I need to call a oracle package - DBMS_STATS via a Datastage job to analyze a table. What are the options available to acheive this ?
The concern i have is - This is the only thing i have to do in the DS job. {I don't have a clue why the customer just want this to be in a DS job}

used the Insert SQL option. Need to use a dummy update also.

Looks like a limitation in the Oracle Enterprise stage. I changed the password, not to have a special character and the load worked fine. If the password has special characters in it, the “Upsert” mode works fine.

Hi All, I am using Oracle Enterprise stage to load a table. I am getting the following error: The call to sqlldr failed; the return code = 256 From this post [ttp://www.dsxchange.com/viewtopic.php?t=94832], I undestood that a trigger in the table is causing the problem. I need the trigger to be pres...