DSXchange

But it behaves the same way even though I 'check'/'not check' the "Automatically handle..." option. Shouldn't checking/unchecking the option change the behavior in some way? That would be totally dependant on the actual design of your Sequence job. You can check the option and not get any change in...

Surely, but if the job only logs a greenie, your job control has no idea that an error occured and will motor merrily down the highway...

That was something I was wondering but couldn't confirm for myself - does the "DB2 plug-in" include a Filter option?

You passed what variable 'like this'? Never mind, here's a quick overview of what you need to do... You need to read up on the User Variables stage in the Designer Guide pdf. That's in Chapter 6 - the Job Sequences chapter - in my version of the guide. In your case, to solve this particular problem,...

Welcome! :D I haven't worked with the CFF stage anytime recently, but do recall that while it supports OCCURS it does not support one with a DEPENDING ON clause. Check the Functionality section of the CFF Stage pdf documenation for more information. Didn't think it would 'crash' anything, however.

You lost your connection to the Oracle database when SQL Loader was trying to start up. Something else to take to your DBA and see if they'll help you figure out the actual problem.

'Resouce busy' means you are attempting an operation that requires exclusive access to the table and you don't have it. Something like a 'truncate' for example. Your assertation that 'no one is working with the database' cannot be true. Perhaps this other person... is you? Do you have jobs or proces...

Didn't you say they also send a 'stats' file? Couldn't you use that as you've mentioned earlier, poll for that file to trigger the processing of the main data file? Assuming they send it last, of course. The other 'work arounds' I've seen people use: 1) When the file shows up, snag the file size. Co...

reddyla wrote:Not Brian, that's what I was wondering.

Excellent! I think I'll start calling him "Not Brian" too.

Hey - what happened? Suddenly we're Resolved - can you please share with us the resolution?

Put some effort into figuring this out on your own. At least a little. Please. For example, from the command prompt type "dsjob -logdetail" and see what happens. A bog standard usage error just like you would expect from any UNIX command where the syntax is revealed. It is also fully documented in ...

DSCOMMAND?

That -log option is for writing log entries - hence your message. You want to use one or more of the following:

-logsum
-logdetail
-lognewest

Yah, sorry - Parameters of that nature are not visible to routines. However, I would think you should be able to pass it in as an argument to your routine and then reference it as I suggested in the call itself. Worth a shot.

Can you tell I've never had much need for environment variables?

Right - this wasn't a generic 'temporary storage' question, but rather a very specific TMPDIR setting related question. At least I hope it was... maybe we're both off the mark. Hold on, I'm sure we'll find out soon enough. Perhaps /TMPDIR (missed the slash in the first go around) is something specif...

Let's take a step back. Temp is temp. Anything that goes there is fair game for nukage after the process that created it... ends. If you are 'staging' data there then you are asking for trouble. Here's what the documentation says on the subject: TMPDIR. This defaults to /tmp. It is used for miscella...