DSXchange

A job in which a Sequential File stage uses a named pipe expects there to be another process on the other end of that pipe. (Actually that's generally true; it's not just a DataStage thing.)

If the inputs are Sequential Files with identical metadata you don't need DataStage at all; you can simply use cat to append the contents of the second to the first. If you then need to work on the composite result, use a Sequential File stage to process the result - maybe use a cat command in a fil...

I think we're becoming confused. By "batch job" do you mean the task of getting each job's job status? Can I output to the txt file in batch job? Yes How to make it??? OpenSeq, WriteSeq, CloseSeq Can I call a routine from batch job??? Yes How to call ??? What kind of routine? Why not just create a r...

Have you tried attaching another link to the stage? This can sometimes "wake it up". You can delete the link afterwards.

A three-digit number in this field is interpreted as the decimal ASCII value of the quote character. The same technique can be used in the delimiter character and quote character fields in Sequential File stages. If you have NLS enabled you can also use a four-digit hexadecimal number which is the U...

Can't help you without knowing precisely what values are coming in and precisely how you want to compare them. DataStage does not have a COALESCE function (though you could write one, but it would need to have a fixed nujmber of arguments). How about posting the clear specification of your compariso...

That's not what a Folder stage does. Read the Folder stage chapter in Server Job Developer's Guide or look in on-line help.

The engine permissions are critical (particularly in the bin directory). If they have been changed DataStage may not work at all. Either reinstall or get your support provider to tell you how to reset the permissions (there is a script). Within a project, best practice is to have dsadm as the owner ...

No idea, having not played with this. Port numbers to avoid are any already in /etc/services, particularly 31538 (DataStage RPC), 23 (telnet), 22 (SSH), 21 (FTP) and any pairs specified for ProfileStage/QualityStage (these port numbers are user-selectable, e.g. 6010 and 6011).

It might be interesting to try "import with selection" so that the DSX is read into a temporary file that is displayed so you can select components to import. If this succeeds, there's nothing wrong with the DSX file.

Why not just re-import without qualification enabled?

This is a sharing site. Please post again explaining what was really wrong and how you solved it.

"Should". Famous last words. Read my earlier post again.

Performance is bad (not acceptable).

Presumably lost updates are acceptable!

... and it's not blocked by a firewall, and the mainframe folks permit it...