DSXchange

No, because a Transformer supports only one stream input. You would need to use a lookup for the data from one of the tables.

You'd need to read the entire file and write it out to a new file, 'deleting' those n bytes at each end by not writing them to the output. Assuming your goal is to create a new version of the file without those bytes, that is.

Do you need to know which column changed or just the fact that at least one of the column values was different? The former is just a direct comparison of all fields individually while the latter could leverage CRC32 to do CDD across all columns at once.

Right... from the Designer's Guide: There are some exception handler variables that can be used in the sequence of activities that the Exception Activity stage initiates. These are: * stage_label.$ErrSource. This is the stage label of the activity stage that raised the exception (for example, the jo...

Or that.

Search the forums for "Implicit conversion" and/or "Possible range limitation", you're not the first person to encounter this problem.

Screen output is captured in a dynamic array, not a string. The Field Mark delimiter needs to be removed so that you pass in a simple string to the parameter. That field mark is the 'not appropriate' part of the error message. The posts where you found this technique should also have explained this.

I would issue "cat <file> | ls -m" and capture the results.

Sorry, don't have 8.x or DB2. If that's all it takes to generate those warnings, as you noted it would be best to take this up with IBM as it does smelly kinda... buggy.

Perhaps in DS_AUDIT - a search for that name will turn up discussions on what it holds and how to query it.

Hmmm... never really thought of XMLInput as an active stage but if it is, you may be correct. Easy enough to check. Regardless, my main point was that adding one isn't any kind of a problem, we do that routinely here from Folder to XMLInput.

If it's anything like the Server Aggregator stage, you can help it out tremendously by presorting your data in a manner than support the grouping being done. This should, in essence, remove any 'large volumes' issues.

Read the 'multiserv.pdf' document in your Docs directory, it explains how to install multiple servers on the same host.

ps. You will need to install and use the MCM to access these two versions from a single client machine.

Ask if your database has any kind of 'inactivity timeout' settings, which can be triggered if no rows flow down a link for a period of time.

Or have the DBA kill the SID. That's usually the best way to clear any locks.