DSXchange

How to do WHAT ?!!!

^O is a single character. So your assumptions about character position shifting are incorrect. This is the character Ctrl-O, also understood as Char(15). It only displays as apparently two characters.

That technically would still not be the FTP stage, but the Collector inserted on its input. Make sure that the collection algorithm is set to Sort/Merge any time you need to preserve sorting when collecting to a single node.

Agreed, but constructing the reverse logic is feasible.

Show us what you are currently doing, in particular the generated sqlldr load script.

There is NO WAY that FTP can change the sorted order in a file. FTP sends a stream, from the first byte in the file to the last. In that order. Network software looks after putting sections into packets and reassembling the packets in the correct order. Something else is happening, or your diagnosti...

I don't know, but I'd try "=" in the other options too, for example

The Data Set descriptor file includes information about the configuration with which it was written. It is this information that is used when reading the file (though orchadmin dump has an option not to do this). It gets even more interesting in grid configurations, but they have figured out a way t...

The logic is supplied with the product, in the Routines branch of the repository. There are SDK routines for converting COBOL data types.

Watching paint dry can be more entertaining than most current U.S. TV shows.

Are you running one of the 7.x versions that permits Director to run on a PDA device? (Note that this was a short lived foray by the vendor; it is no longer available in version 8.)

Kim Duke has a web-based navigation tool (DWNav) that you might also investigate.

By placing a Sequential File stage with appropriately-set File property on the other end of the reject-handling output link.

Actually i want to know if i could delete the whole folder at once instead of deleting datasets individually to save time. I need to create a fresh folder for datasets in another path. NO Data Sets' data files live in multiple directories. If you delete all the *.ds files (which is what I am guessi...

For version 8.0.1, the MQ client-only stage is installed by default in the Real Time pallette. That seems to be true if the DataStage server is on Windows but not if the DataStage server is on AIX. On AIX we get the WebSphere MQ Connector on the parallel jobs palette, but nothing on the server jobs...