DSXchange

Ok, wasn't aware of anything out of the box for Notes. If someone here has some practical experience with this, hope they sing out. In the meantime, perhaps it would help if you posted your ODBC config files. I'd also be curious if you've successfully used ODBC of any kind before this with DataStage...

What ODBC drivers are you using for this Notes connection? One that ships with DataStage or did you purchase something specifically for Notes?

And sometimes it's worth it to go get a dang baseball bat.

Hopefully you understood that the 'that' I was referring to was the 'required link property' question which has nothing to do with the current topic, hence the request.

Nope. For a procedure it would be 'IS', a table or view - 'AS'.

You can't "archive" or otherwise futz with a file that is being written to.

Start a new thread if you want help with that.

Try to keep up, Ray.

So the SQL itself is identical between the two? If so, then you need to open a case with your official support provider, I vaguely recall there may be a patch available for this...

If the generated query works and the user-defined one fails, I'd suspect the sql itself is the issue. Don'tcha think?

And failing that, 'jobmonapp'.

It's a UNIX problem, and as noted your list of filenames is 'too long' to be handled. How many XML files exist out there? How long is each pathname?

Triggers would control that, typically an 'OK' and an 'Otherwise'. Have you not tried that?

That error just literally means it can't find a job with the name specified in the project. /* Errors generated with the DSAPI */ #define DSJE_NOMORE -1001 /* All events matching the filter criteria have been returned. */ #define DSJE_BADPROJECT -1002 /* Unknown project name */ #define DSJE_NO_DATAS...

So... resolved?