DSXchange

Read the file using a hex dump utility, such as the od -xc command, to learn what the characters are. I suspect that you have one or two binary representations of numbers in there. As Ernie noted, you need to speak with whoever authored that file and understand what is truly stored in each of its by...

For starters, don't push. Your last two posts were at 10:48pm and 1:22am my time. DSXchange is an all volunteer site whose members post if and when they can, at the same time being under no obligation to do so. If you effect the pivot using a Transformer stage, does it still hang? How, precisely, ar...

All patches are to be found at Fix Central

Because the composer (conductor) inserts a tsort operator with all default settings (over which you have no control apart from memory allocation*) when you use a link sort. An explicit Sort stage gives you that control, via the stage Advanced properties. * via APT_TSORT_STRESS_BLOCKSIZE environment ...

An internet search will reveal to you that a semaphore is a place for a program to wait for some event to occur (even for an amount of time to elapse). Semaphores are implemented in different ways on different platforms, but in all cases they should be released once finished with. If they aren't, th...

Did you mention the cast (change of data type) in the Modify stage specification? (Use ustring if Unicode, UTF-8, etc., are in play; use string otherwise.)

Then, yes, the warning is because you are using a link sort. Use an explicit Sort stage to eliminate the warning (keeping the Preserve Partitioning = "Clear" setting in the stage upstream of that). Or you could demote the warning with a message handler since you know it doesn't affect what...

Welcome aboard. DataStage is unable to find the $DSHOME/.odbcini file (whose pathname may also be stored in the ODBCINI environment variable). Seems to me you need to make sure that the .odbc.ini file exists and contains all needed DSNs. Also make sure that there exists a file called uvodbc.config (...

Did you specify "Sort" mode for the Aggregator stage, since your data are already sorted by the grouping key?

Transforms are only available for use in DataStage BASIC expressions, such as in server jobs and sequences. They are not available in the parallel Transformer stage. Parallel jobs have other strategies, such as the LastRowInGroup() function and the ability to use stage variables' execution order to ...

Look at your data. You have two entries for January. Use a Remove Duplicates stage to keep only the last in each group, if that's what you need.

Why are you using Sequential File stage? Or, to put it another way, why aren't you using the MQ Connector?

You should not have to rebuild the project. However, with any problem with GenRuntime, it may be useful to re-start both the engine and the agents. Also check whether there are any patches relating to GenRuntime - they exist for earlier versions.

Not in Transformer stage but possibly in XML Input stage or XML stage.

Did you set Preserve Partitioning to Clear in the preceding stage in the job?