DSXchange

Not sure if Kenneth Bland wants to advertise his particular solution or not - but he has a very nice collection of routines called "KBA Job Control". It can automate a complex series of server jobs with little to no effort required on your part and constantly keep X jobs running in parallel at any g...

Ok, getting closer. The lack of a 'where' clause isn't important in this context. What is important is that every column returned by your query has a column to 'land' in as defined on your Columns tab. I'm guessing (from the error message) that you are missing some there or perhaps have extra ones d...

So where exactly, in all of these steps, do you get the error? Initial extract, reference lookup or insert? And I'm still curious - are any of the OCI stages using custom sql? If you are, that's the first place I'd look for the problem as you generally shouldn't see something like this with generate...

It's not all that obscure, did you look it up? $ oerr ORA 1036 01036, 00000, "illegal variable name/number" // *Cause: Unable to find bind context on user side // *Action: Make sure that the variable being bound is in the sql statement. Generally this is from using Custom SQL. Make sure al...

When you do, consider putting the derivation (DATE.TAG(@DATE)) in the 'Initial Value' area when you define the variable. Then simply use it in your Transformation derivations. This way you incur the overhead of the system call to get the current date once and then simply leverage it after that. In y...

I know there is that stage in job sequencer that sends an email, but I was wondering if there is somewhere to set up email notification if the job fails? You mean somewhere other than by using a Sequencer? There are a couple of options. An Enterprise Scheduler (like Control-M) can do that as part o...

Failing that, you could also export the project and then search for the table name in the file.

Or just wait for Uncle Ray to come along and post some for us.

I'm curious why you would need to call a Sequence job from a Server job? In all the time I've been dealing with this tool, this isn't a situation I've found myself in, hence the curiosity. Why not just let your Sequencer Job run your Server job first and then carry on and execute the Command stage a...

Well, 50 is the default setting for the Warnings limit, so it doesn't suprise me when you say everything aborts when a job hits that limit. When you run it "seperately", i.e. manually from Director (I assume) and specifically set the limits to "No Limit" then again it is expected behaviour that mult...

denzilsyb wrote:Thought I'd just document how the above error was fixed.

Thanks for doing that. It adds greatly to the value of the 'library' here, the next person that comes along with the issue will have a resolution as well! Imagine that.

AFAIK, an environment variable is an environment variable. The ones you set inside the Administrator become 'common' when a job in the project runs. My suggestion was to not worry about trying to pass it into the routine, rather to look it up from inside the routine. Really don't think you need any ...

Twenty-eight tables at once? In one job? No wonder it is slow. There must be some kind of bulk loader available for DB2, yes? Why not spin them off to flat files and then bulk load them? Either that or instantiate the job - create 28 'instances' that each load via one connection just their portion a...

Use CONVERT to change your delimited lists into dynamic arrays and then something like INDEX or LOCATE to do the dirty work. From what I recall, there should be plenty of examples of same here if you search.

As noted by the compiler error you received, this stage (and anything hooked to it) cannot stand alone. The Exception Handler is not the 'first activity', more like a last one. Your sequence job needs to contain a 'normal' (for lack of a better word) series of Server Jobs and/or other Stages that it...