DSXchange

We are having a similar issue. We are going to change the kernel default config settigns. The Install and Upgrade manual suggests the kernel may need to be rebuilt. I'll let you know what we find.

You could also remove the checkmark beside the "Generate Formatted Output" in the XML stage. This will condense the output, though it will condense it more than the XML you have above.

I use the below to replace a CR in a comment field. You can do something similar

Convert(char(10), ". ",AOStyleComment.RemarkType)

How many records are in table you are joining with?

This ended up being a bug. The macro was instead returning the datetime of the last compilation.

As a workaround, IBM supplied
OCONV(@DATE,"DYMD-[4,2,2"):" ":OCONV(@TIME,"MTS")

I am setting the initial value of a stage variable to Macro DSJobStartTimestamp. I am having an issue where the value updates intermitantly. It will be the same for three executions (command line), then update on the next run. Has anyone run into a similar scenario. Of lesser concern, I am intereste...

Based on what you supplied, the names do not match and the error suggests as much. There is a pdf ..../Ascential/DataStage/branded_odbc/books/books.pdf that can help with this configuration and testing the connection with ../bin/example. I would also double check the port. It may not be the default ...

You need to create a separate entry in .odbc.ini for each DB you want to connect to and the names should match.