DSXchange

The OpenSeq statement will take its Else clause if the file does not exist. Note that the file will be open for writing and locked - you will still need a CloseSeq statement once you have performed your test. You could also call DSExecute to execute a UNIX test -f pathname command (yes, even though ...

Possibly the best place (most comprehensive list) is the UniVerse manuals - also available through IBM web site - although these don't give the DataStage-specific commands

Only if you want to. It's not necessary.

You are violating an Oracle constraint. Your design must prevent this from occurring. On one node what you have done may work, but what happens when the duplicates are on separate nodes?

Did you trim Char(160)?

Data Set and File Set descriptor files include the configuration with which they were written. When it comes time to read them, a virtual "read only" descriptor is created from this. (You can accomplish the same thing using the -x option with orchadmin command.)

We've just completed upgrading BioGrid from 8.1 to 8.5. They have a comprehensive Business Glossary full of medical terms, since they're a medical research company. Thus far, they don't use MDW at all, but we may be able to wean them onto it as more and more research institutions become part of thei...

The character on the end is 0xA0 (ASCII 160). See if you can work out how it got there. You should be able to trim it off.

They START in serial fashion - such is the nature of sequence (special case of server job). But they run simultaneously. Even if you create your own job control routine with PHANTOM statements, you're never going to do better than that without using a multi-threaded scheduler.

Go back to your orignal design and add a Reject link to the Sequential File stage that reads the file. This will capture the header and trailer rows and begin a stream of processing in which you can do what you like, for example re-parse with a Column Import stage.

If you're on UNIX (as stated) Task Manager isn't going to help - you'd need ps -ef command, probably with grep. Add the environment variable that reports job startup to work out what's happening. Also purge old entries from the &PH& directory. Think about changing your design so that all sta...

Fork join.

Probably two nested fork joins.

Why bother with the "Y" and "N"?

Create a routine that invokes DSSendMail().

But have you learned anything (apart from begging for solutions)?