DSXchange

Welcome aboard. :D Read them as VarChar (or Char, if fixed width) and use a Convert() function in a Transformer stage to remove the commas. You can effect the data type conversion in the same expression. StringToDecimal(Convert(",", "", InLink.TheNumber))

Nulls are populated in a flat file with whatever you specify as the Null Field Value property.

That's cool, because my advice was going to be to push back on the daft requirement!

Use the Data Set Management utility. Choose one node in the top grid, and you will see the pathnames of the segment files in the lower grid. There you will see that DataStage uses a long, complex, generated name to avoid name clashes.

Arnd means to look at the hardware. For example, is one directory on local disk and the other in a SAN?

The Char columns are padded with 0x00 (ASCII NUL), not with 0x20 (ASCII space). You can see this by viewing the output with a hex editor, such as UltraEdit. You can change this behaviour by setting the value of environment variable APT_STRING_PADCHAR to 0x20. The reason the data don't seem to be fix...

Please advise HOW this was resolved.

THE major difference is that the Switch stage operates on values, while the Filter stage operates on WHERE expressions, to determine which rows are sent along each output link.

If you use a Sort stage, it can generate a key change column. If this is 1, you have a new key; if this is 0 you have a duplicate.

Are you following Chinese tradition, where a newborn is deemed to be age 1 (credit for "time already served", presumably)?

Search the forum. One way is to use
I vaguely remember posting a routine called IsMultiInstance but that really has been superseded by the new InfoType key for DSGetJobInfo - that is, DSJ.MULTIINVOKABLE.

Clearly the better approach is to use a disciplined approach to development that avoids unecessary locks.

Have your job pivot this row into five rows, and write them to a hashed file using keys "A", "B", "C", "D" and "E". In a job sequence create a User Variables activity to read these - well, the four you need anyway, using Trans() functions or the utility routine that reads a record from a hashed file...

mallikharjuna wrote:What is the difference between 7.5 and 7.5.2 in server jobs?

.2

The method is different depending on whether the environment variable was defined in the login shell or in the DataStage Administrator. Be wary of this while searching.