DSXchange

These header files are in a sub-directory called DSU_BP in the project directory on the server (engine). They are not header files supplied with DataStage but, presumably, were written in-house or by a contractor. Since they are text files you can read them with any text editor. With a product like ...

In server edition you can use Hashed File stage or UniVerse stage. The tricky part - discussed in the documents referred to - is determining the job number and therefore the hashed file name RT_LOGnnn.

Yes, using Director. Disable the display of categories.

Check the schemas thoroughly to ensure that there's no Extended property making one of the integers unsigned.

Yes. The easiest would be a DataStage job. Other methods use queries against the database capturing the output into a file using COMO, DIVERT.OUT or simple redirection.

I usually encounter them as Decimal(7,3) or subrecord containing degrees, minutes, seconds and direction. In N years of working with databases I have not encountered a data type called Geographical (though QualityStage does have a GeoMatch matching technique).

Is there some setting for bcp that allows it to recognize the "nnnnnnn." format for decimals with a scale of 0?

Only if the column is named. You can't do it with RCP.

You'll need to enlist someone like Harry Potter.

You just CANNOT avoid I/O when moving stuff to and from disk!

Do a "where used" on the table definition. You DO rigorously manage your metadata, don't you?

As soon as you need to perform some operation on a column that column must be named on the input link - it can not "magically" be produced there by RCP. That is, your Trim() function has to have an argument.

Note that the *.ds files will always differ from each other. Comparing those is pointless. Werner's approach will get you what you seek, or very close to it.

For starters, the SQL for a lookup will (must?) contain a WHERE clause. Your alleged "test" SQL does not.

Apparently Prometric do offer a "ten dollar exam", though I'm not sure whether that's available for DataStage. Could be worth checking out, though.