DSXchange

If you add a copy or transform stage does the error go away? Can you do a "view data" on the dataset? Can you tell me where you got the SQL Server stage, I haven't seen that stage before and would like to use it as well. Already there are copy, transform and lookup stages. If i view the d...

If you add a copy or transform stage does the error go away? Can you do a "view data" on the dataset? Can you tell me where you got the SQL Server stage, I haven't seen that stage before and would like to use it as well. Already there are copy, transform and lookup stages. If i view the d...

Hi
I am getting error Fatal:Transfer doesnot have the output interface destination. I have source as dataset and target as SQL server stage. Normally this job works fine. In the director we have only this error. No other information detected there. Can anyone suggest pointers to resolve it?

I faced a similar problem. The round- about way is to define user-defined parameters at the job level and map the same to environment variables in the sequencer. This should work, atleast it did for me.

There is no rejected records in Join. You can't get the matched and unmatched records in two separate links using join stage. Instead You can capture the nonmatching records from JOIN by using a transformer satge or a filter stage after the join stage: Full Outer Join: Give a condition on the transf...

Till yesterday it is running fine. Today only we are getting this error. In other dsx's also i have checked and we are having this similar parameter defined. But they are running fine.

Thanks in advance,
Raj Kiran Kaile.

Hi all, I am trying to extract data from the DB2 tables. i have used a DB2 API stage to extract the data and for the server name i have used the user defined administrator variable #$IMM_LGY_DB_DSN#. Now iam getting an error saying that "Unable to connect to DB2 server '#DSCAPIOP__IMM_LGY_DB_DS...

Hi all, I am trying to extract data from the DB2 tables. i have used a DB2 API stage to extract the data and for the server name i have used the user defined administrator variable #$IMM_LGY_DB_DSN#. Now iam getting an error saying that "Unable to connect to DB2 server '#DSCAPIOP__IMM_LGY_DB_DS...

Yes Ray, I compiled the Job afetr making it as multiple instance Job. But logs I have here for is ... <jobName>.<scriptName> no 1 or 2. Here i restate my query, will the Invocation ID take the any special character(e.g:dot(.)) in its name to make an instance of the Job. Ray, please clarify.

All, I created a parallel Job and made it as multiple instance Job. I need to run this Job twice in the single script. So, i gave like this ... <jobName>.<scriptName>.1 ... <jobName>.<scriptName>.2 But it is not accepting 1 or 2 instead being run twice with creating single log(for the latest call). ...

Hi,

I got a way to do it. i am using two output columns in XML input stage.

/dept/sector/@value
/dept/sector/user/@Name

then i am using a filter to split into diff files.

Thanks!

Hi, I have an XML as follows <dept> <sector value="Delete"> <User Name = "xx112"/> <User Name = "xx113"/> </sector> <sector value="Create"> <User Name = "xx114"/> <User Name = "xx115"/> </sector> </dept> My requirement is to get Users under...

After transformation stage, I have alots of other stages. But I need to have those records in the same partition.

Can anyone confirm me, wheather these records be placed in same partition.

All, We have created three tools in DataStage 7.5.1 in our project. They are, 1. ListJobParameters.dsx - List out all job parameters present in a server/parallel job and Job Sequence from an input DSX file. In detail, this DataStage Server Job will provide all the Job parameters components such as P...

Thanks Ray,

Really such a valuable pointer. I created a server Job and before that i created a transform function(Server Routine) then use that routine in the transformer Stage, renders the desired result. It is working now.