DSXchange

Massimiliano, if the parameter names "NomeFile5", "Directory5" are wrong, i.e. the job in question doesn't have parameters named like that, DS will abort the controlling job by itself, as you specified: hJob1 = DSAttachJob("OTCommonCopiaLog", DSJ.ERRFATAL) if you do not...

Hello,

I sometimes have to do something like that:

startdate=iconv('2000-01-01', "D-YMD")
enddate=iconv('2002-12-01', "D-YMD")
currdate=startdate

loop while currdate

Emma I think, there is no 'execution order' in a normal job with stages independent from each other (not linked together). These groups of transformers would all start simultaneously. To ensure that processing is done in a particular order, you would have to create multiple jobs to be executed one a...

Emma, I don't know if you still need this. I assume that you don't mean how to stop a batch job from director, but from within itself. I think there are at least 2 possibilities: - 'Call DSLogFatal(....)' would abort the controlling job - 'Return' would pass control back to the caller, i.e. the batc...

Ray, thank you very much, this information is very interesting and helpful!

Stephan

Thanks all of you for your help! As I want to read the value into a variable within a controlling job, I tried to store the value into a hash file as Kim suggested and then tried to use the 'UtilityHashLookup' within the controlling job. After having learnt how to do that, I succeeded. Thanks again ...

Vladimir,

splendid, this works now, it was just the uppercase letters. I wonder, why I can't find any hint on how to do this in the online help?

Thanks and Regards
Stephan

Sorry Vladimir, this didn't work either!

Stephan

I tried to use the UtilityHashLookup in a controlling job and declared it like this:

Deffun UtilityHashLookup(A1,A2,A3) Calling "*DataStage*UtilityHashLookup"

But I always get a fatal error??

Stephan

Yes, I'm currently doing it like that, but I thought, I'd better do it with on-board means. A benefit I'm expecting is that a routine using BCI should work with any kind of DBMS?

Stephan

Ray,

to get the ODBC drivers licenced ( we are using the Merant drivers that came along with our DS 5.2 server under HP-UX), who must be addressed and what are the costs?

Thank you and kind regards
Stephan

Dear all, I would sometimes want to read a single value from a database table into a variable within a controlling job, but couldn't find anything how this is to be done. I'm thinking of a routine that would just need the DSN name, user, password and the sql statement. Any idea? Thank you very much ...