DSXchange

Thanks a lot Joshi. I try it with ODBC and it works fine ! I never used ODBC stage before. Does it exist performance issue for large number of data or is it quite similar as Oracle stage ? Chulett, I agree you but I don't have the choice :? . They require something graphical in case of many joins to...

Hello, I need informations on this case : I have two ORACLE tables TABLE 1 : 3 rows --------- field1 / field2 X / W X / Y X / Z TABLE 2 : 2 rows --------- field1 / field2 X / A X / B I would like to have as result RESULT TABLE : 6 rows --------- field1 / field2 / field3 X / A / W X / A / Y X / A / Z...

Yes there are the same values for parameters in the two runs

thanks very much :D now it is ok! I've created a small routine for it, which reset if necessary. ************************************************************************* * Copyright (C) 2004, 1997-2003 Ascential Software Corporation. ALL Rights Reserved. * * This code may be copied ON condition tha...

Thanks Anupam, I'll try it!

Yes, I'am ok with you.

but the job called could become 'aborted' and unfortunately I couln't run it again from the routine RunJob without doing manually a compilation or doing something like 'reset before run'

bad news

ray.wurlod wrote:There is no routine for compiling a job.

ok thanks, that's what I was affraid of.

There is really no way ??

I think I don't have well explained it. I must use a job which calls others jobs with the routine UtilityRunJob(jobname, jobparameters, row limit, warning limit) but this routine doesn't do 'the reset if required then run' so it couldn't run the jobs in aborted state. I would like (if i can :) ) use...

Hello, I am new to DS Server and I would like to know if it exists a routine only to compile a job ? something like the routine UtilityRunJob but just to compile (I can't validate it because of 'dynamic' parameters (with sql)) to explain: my problem is that i run many times (in a sequence) a job whi...