DSXchange

In UNIX they should all be in separate groups. The recommended way is to have all in the same group as dsadm. So if that is dstage then these users have to be in dstage group as well as this new group. So lets say the new user is payrolluser then create a payrollgroup as well as dstage. Now create a...

By the way it is a free download from my tips page below my signature.

EtlStats is about 40 jobs. One of which is used to gather stats about job runs. It populates 3 tables ETL_JOB_HIST, ETL_ROW_HIST and ETL_PARAM_HIST. It also populates 3 hashed files so you can build your own restartable job logic. There are a whole bunch of other jobs which help extract metadata fro...

Do a search on EtlStats.

You usuaully need to land the value into a sequential file then read that value in job control or a routine to feed it into a parameter.

Job Sequence

JobA Select Max(id) from whatever => SeqFileA
|
V
RoutineA Read Value set Arg1 = SeqFileA.value
|
V
JobB (Set parameter = RoutineA.Arg1

My favorite book is called "Tips of the UNIX Masters". It is out of print but I have seen it used on Amazon.

You said you used it on 3 fields. Is this in one job? If so then you need to do what I suggested.

Have you checked your permissions to see if they have changed?

If EditServ.impl.JobDefnImpl@79427df4 is your job name then that is your problem. Eliminate the special characters.

If you look at this routine it uses @USER0. This is sort of a global variable for a connection to DataStage. You need to copy this routine and use @USER1 and @USER2 so you can have 3 copies of this routine and they will not step on each other.

I have a job included with EtlStats which will check to see if any job failed in a sequence called EtlChkSeqJobsNotRun. It is all job control so you have source code. It will email the log file as an html attachment any group of people you want if a job fails. So the logic to figure out which job is...

KIM!!!

There is a script called DSaveAsBmp.bat on my tips page which will do this for you. I would convert the BMP to a GIF.

Download EtlStats and search for how to use it.

The script DsJobReport.bat will do all jobs in a project but you can do it yourself if you want.