DSXchange

I have seen this warning message, if there are two similarly named transformers in a job. Then compiling works, but running produces this error. Usually it is not possible to name stage as other one, but sometimes you can just bypass this accidentally. But renaming other transformer should work.

I created a test and worked properly when I used the routine changing the $ UserStatus within a server job. However, I need to do this in a basic transformer inserted in a parallel job. This way is not working, the value is not assigned to the variable $ UserStatus. Thank you, There is no way you c...

... But when i used Sparse lookup i see that the output link is getting more records than actual records in the main link(ie updated dataset) . I dont know how it is getting those many records when the input link is showing only few records and the referenece link only few records. for example when...

I am answering my own question. There seems to be a bug as reported here: viewtopic.php?t=128327&highlight=istools

I wonder why I can not get the command functioning. I do have a lot of content in my project, but the export does nothing. It does not even create an empty target file, please see output below. BTW, what is file extension .isx used here? Is the format supposed to be somehow different from regular .d...

Please take a look at another thread for the this issue. viewtopic.php?t=122186

I found out that this error message index too large with SCD stage is quite generic. For example I have two versions of client software installed, one with client side patch from support and another one without the patch. When using Oracle DBSequence for surrogate key generator inside SCD those clie...

Support has a client side patch for this known issue.

bkumar103 wrote:you have two oracle stages in the design... verify which oracle stage is throwing this error.

<- error log didn't tell me that what is incorrect stage

singhald wrote:What value you have specified in remote server text box ?

there is parameter which are pointing to database in remoter server.
#$VVDB#

If I run server job using same source and target database, it finish without any errors.

DataStage v. 8.0.1 fixpack 1a Windows/AIX/Linux

There was a problem (bug) related to SCD stage with the setup above. However there is a patch e121091_v2 available from support and now it seems to work as it should.

Thanks for your reply. The problem is that DSOpenJob requires Jobname as parameter. How can you refer the job where the routine is called from? You just can't hardcode jobname in your routine, neither parametrising the name is a convenient solution. It would require the routine calls to be changed b...

Hi! I solved my problem, I didn't give any path, where I want to create project. Need to click browse button and define right directory path.

Hi! I am working with Enterprise Edition 8.0.1 and I tried to create new project, but I got a message: "error updating secondary indicies". Does anyone to know,what cause this problem and how can I solve it?

br Minna

I try to figure out how to use DSGetJobInfo in Parallel C++ routine, but coud not find any examples. I have following Server routine which I try to translate into Parallel routine. It simply returns USERSTATUS of the job. $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSJ_XFUNCS.H ErrorCode = 0 ...