DSXchange

Leave it empty unless there is actually an escape character in your data.

Most of the metadata for repository columns is not in the public domain, and the vendor reserves the right to change same (and is doing so in the next release). You can determine what is accessible with the LIST.DICT command (from the Administrator client command window), for example LIST.DICT DS_JO...

In the Transformer stage detect whether the lookup succeeded (if not, LocCd from that link will be null) using If .. Then .. Else, and supply your default values in that expression.

They are usually installed on separate machines. Order is unimportant. Both must be installed before clients can connect to server.

7.5 was the next release after 7.1. There was no version 7.2, 7.3 or 7.4.

This is an annoying message, which is really an informational message but displays as a warning on the grounds that it's "unusual". It stems from a difference (of two bytes?!!) between what your ulimit specifies (for data) and the hard limit coded in DataStage. Get your UNIX administrator to increas...

From memory, you can also adjust precision and scale with a Modify stage. Just specify the correct values on input and output links, and supply the appropriate function if automatic casting is not possible (which you can determine from the manual).

Of course there are limits, but you'll never hit most of them. For example, a DataSet or FileSet can contain a maximum of 10000 files each not larger than 2GB per processing node. You can do the math. The main limitation seems to be the unwillingness of some to spend a couple of thousand dollars get...

Not much I can add to Arnd's response. The default location is a directory called Datasets.

The next release. It's currently carrying the code name "Hawk", will probably be version 8.0. Prior to the IBM announcement Ascential was aiming for a release date of September 2005; expect this to slip slightly. It's currently in beta; you can sign up for the beta program on Ascential's web site. T...

Welcome aboard! :D

You've identified what needs to be done. Brief the DBA about what you need to achieve with the tool, and why. Perhaps the DBA could be made a Directory Administrator, then you could guide the DBA through running the entire directory creation process.

The only thing I can suggest is that you check the datafile definition for the output file, to ensure that the HN column is not being overwritten by some other column. That is, check that the start and length of every field are correct. My suspicion is that you are (accidentally) overwriting the HN ...

If it's really urgent sign up for premium support with your support provider, and learn the true cost of urgent. This forum is an all volunteer effort, with participants posting as and when they can. "Urgent" is not possible, unless you want to purchase the services of some of the independent consul...

Uninstall is a manual process. Fortunately there's not much to it, provided your system has been well-managed. 1. If you have hashed files in other directories, delete them. Use UNIX command ( rm -rf ); it's OK. 2. Delete each project directory. Again, use rm -rf ; you can obtain a list of project d...

If your TimeStamp format is the default then you will require two digits in the hour component. Check also that you have a TimeStamp format that includes fractional seconds.