DSXchange

Thank You Craig. This solved my problem

Hello, I have a requirement to execute a stored procedure after every 1000 rows inserted into the target table. For example after cdc there are a total of 3224 rows to be inserted, I need to execute the stored procedure a total of 3 times and use a value returned from the procedure and insert into t...

What I meant to say was that every call to the procedure is meant to generate a new number and return it whereas when I was invoking it from datastage the number being returned was a duplicate which is not possible unless the procedure was not invoked. Yes Im using an older version that does not hav...

We can use a table with IDENTITY column only if the Surrogate keys are unique across a table. What if the requirement is to have a unique value across the schema? I am using version 2008 and my dilemma is exactly this. I cannot use a state file and want the best possible alternative to use a squence...

Hello, I have a requirement to generate a unique Sequence number. We currently have a state file doing this but we need to be able to fetch it from a database instead. Our Database is MSSQL Server where there is no availability of a SEQUENCE object. I have therefore written a stored procedure to upd...

I have a job that is expected to create a view after successful insert of records in SQL Server. I have used the create view statement in the After SQL section. The problem is that even though the job fails due to a key violation error, the After SQL executes. Can I put a condition to execute the Af...

Hello everyone, I need some help for deciding which version of IIS to install. IIS v.9.1.2 comes with WAS v8.5.0.0 and this version of WAS is not compatible with Redhat 7.0. WAS v8.5.5.3 is the minimum requirement for Redhat 7.0. Does anybody know if WAS v8.5.5.3 is compatible with IIS v.9.1.2 ? Tha...

The issue I'm facing is I cannot pull columns from an oracle connector into the reject link for displaying in a log because they do not show up. I'm facing this on a DS 8.5 installation. Any help is highly appreciated

I'm facing the same issue as noted in this post. Is this an access issue or an installation issue?