DSXchange

Hi Ray,

I would like to get the manual.

Thanks

MAT

Sure you can Include the following at the top of your routine (jobcontrol library) : $INCLUDE DSINCLUDE JOBCONTROL.H And use the following functions: * Attach hjob = DSAttachJob(JobName,DSJ.ERRFATAL) * Run ErrCode = DSRunJob(hjob, DSJ.RUNNORMAL) * Wait for termination ErrCode = DSWaitForJob(hjob) * ...

Hi,
If your are refering to CPU count you read from DS Administrator, it refers to your license. It is the number of processors you are allowed to use with DS. If your hardware is below or equal it will work fine.

Regards

MAT

Christophe, I am not aware of a file for storing job logs but you can access them easily with DataStage Basic. You can use several Basic functions depending on what you want. In my project, I use a routine to attach the job for which I need the log. After DSAttachJob(). You can attach a job after it...

Hi, Yes, I tried using DSMakeJobReport. Datastage tells me the job has no stages, I only get start time, end time but nothing about job logs. The only way I've found is by using DSGetLogSummary and filtering the array afterwards. Finally, I decided to "hardcode" the names of my jobs in a v...

What I am trying to do here is to generate a full report about a sequencer. We have to do this because even if my team is developping the entire project, we are not the ones who will be watching over the servers when DataStage runs it. Production guys will need to know quickly what is going wrong (i...

Hello all,

Does anyone know if it is possible to obtain a list containing names of the job activities within a job sequencer using BASIC functions?

Thanks

MAT

thanks guys. It worked.

MAT

Hi, I need to load seq files in DB2 tables. My inserts work well except when i have Date and Timestamp formats. I receive a SQL error, saying it does not recognize the datetime format. It is surprising because I do not have trouble loading these formats normally. Do I need a special formatting for D...

Thanks Vincent, I am now fairly certain that my problem was coming from the calls to DSWaitForJob() within my routine. With this structure, I could not ask for DS to run many jobs at the same time, the server was always waiting for a job to finish. Problem is I had to use DSWaitForJob() to get the s...

Thanks Kev...it may not be what I wanted to hear but it confirms what I was thinking [:(]. I guess I'll ask the folks from Ascential about what can be done about it. The team and especially the client does not like the idea of having server passwords in plain text on UNIX and it is something I need ...

Hi, Using a file to store parameters for my jobs, I would like to store in the file encrypted passwords the way DataStage does it. Obviously for reading and writing them after. Is it possible? I know someone said once he had isolated DataStage encryption function? Does anyone know more about it? Tha...

Thank you all, Here is some precision, I am using a single routine similar to UtilityRunJob made by the sdk. Using "Routine Activity" Jobs in a Job Sequencer on DS Server. I call the same routine every time with the name of the job I want to run. I do not run the same job twice in one sequ...

thanks for a quick reply!! I am using Server. The problem is not about running jobs in parallel, it's when running them from a routine. It this case, they always run one after another. Also, my company is moving to PX for the next project, are you saying there is a bug about running parallel jobs in...

Hi, I am running my jobs with a routine controling them to be able to set parameters and get some info about links and other things. My problem is that when I create my sequences, I use the same routine to call all my job but I would like them to run in parallel. When I run my jobs without a routine...