Page 2 of 2
Posted: Mon Jan 28, 2008 11:02 pm
by rohitchattar
We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.
We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?
Please suggest.
Posted: Mon Jan 28, 2008 11:04 pm
by chulett
Suggest you open a case with your official Support provider at this point if you truly can't find any differences between the two servers.
And no, that kind of reference lookup without a key field is not a problem.
Posted: Mon Jan 28, 2008 11:06 pm
by rohitchattar
We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.
We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?
Please suggest.
Posted: Mon Jan 28, 2008 11:07 pm
by rohitchattar
We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.
We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?
Please suggest.
Posted: Tue Jan 29, 2008 12:54 am
by ray.wurlod
It is impossible - on either system - to have a reference link without a key column. How would you specify which row(s) to return?
Posted: Tue Jan 29, 2008 1:02 am
by chulett
Actually, it's not impossible. For an Oracle sequence, you simply use a query of "select X.NEXTVAL from DUAL" with a single non-key column to hold the result. No key is supplied in the reference link and it returns a new key for every record through the job.
I've done this and it works 'fine' although it is not my preferred methodology.
Posted: Tue Jan 29, 2008 1:10 am
by ray.wurlod
OK, not impossible, but insane if the reference column has many rows.