DSXchange

1) Do you still need help with this?

2) Sure... depends on what you do in that event. In your shoes I'd probably do something with an error file and in the event it is non-empty after processing, use an Email Notification stage to send it out as an attachment.

Hmmm... think I'm leaning towards suggesting two WFF stages in a Sequence for this.

AFAIK, it is still 'just an Oracle database' so you'd access it like any other via the Oracle Connector etc. Any 'how do I?' questions should go to your Oracle DBA - you do have one, do you not? Worst case it should be easy enough to google up stuff like that. FYI - typically stats would be maintain...

If all of these 'steps' are in a single job then that's your problem. Sequential files support multiple readers but only one writer at a time. The steps would have to be completely separate for your approach to work.

Investigate the Oracle RANK function for an alternate solution.

That too.

How about letting us know what you are trying to accomplish?

It's not an operating system command. It needs to be run from a TCL prompt which is why you would typically use the Adminstrator client. From the command line, you'd have to leverage dssh to run it.

When a job aborts, any uncommitted records are rolled back. This isn't a DataStage thing but rather a database thing, one can only roll back uncommitted transactions.

Please reread my response... pay particular attention to the 'remove them' part.

Your format string needs to match the incoming data. Since your incoming string does not have dashes or spaces or colons in it, remove them from the format you are specifying. It's all about what it is, not what you want it to be.

I thought that might be the primary difference but not being certain decided to wait for someone more smarter to wander along.

So no one will run the job but instead when ever a file is appeared in that directory on the other server, the sequence job should trigger by itself. Just wanted to point out that nothing can 'trigger by itself'. Something must trigger it, so something must be watching for the file to arrive. Forge...

Honestly not sure, only the 'Enterprise' stage is documented in the manuals I have. I'd stick with that one.

By "app" you meant what - job?

That would be a horizontal pivot - columns to rows. You'll probably need to hard code the 'header' values and then pivot them in pairs with their corresponding field.