DSXchange

The fact that you're using substring and concatenation suggests that you are generating a string data type.

Use a function like TimeToString() to convert the incoming string to a time, and then assemble CurrentDate() and that result into a timestamp.

You need five character null-replacement for field abc and nine character null-replacement for field klm. As suggested, this is set on a per-column basis by accessing the extended properties via Edit Row menu option (or you can double-click on the row number in the Columns grid).

Decimal data types are displayed with leading and trailing zeroes so that you can be sure that the precision and scale are handled correctly. The only way to lose them in a parallel job, without using BASIC components, is to convert to string and trim the leading zeroes (and trailing zeroes if desir...

Without worrying too much about the difference, what do you understand to be the definition of each?

Having answered that, has it contributed to your understanding of the difference between them?

If DSUTILITY is a DataStage utility, what is the generic term for a file utility?

Is is NOT the configuration file. The only thing the configuration file supplies is the node name used in the error message. Somewhere a process has failed (or been killed). The configuration file is NOT a process. Even though you are only running one job, that does not preclude other activities on ...

I think what's required is expressible in SQL as SELECT TheKey,Count(*) FROM TheFile GROUP BY TheKey HAVING Count(*) = 1; Why not extract it with SQL? The approach using sorted data and stage variables is also valid, provided you employ a key-based partitioning algorithm. Another des...

Because you've specified fixed-width format, any null-substitute value you specify must have the correct number of characters as the field in question - in the cited case, three. So "_" (three space characters) would be a valid representation of NULL; a single space character is not.

In server jobs you'll find that display width is double the precision when the data type is NChar or NVarChar. Internally, DataStage NLS uses its own idiosyncratic UTF-8 encoding of Unicode code points, so as to preserve dynamic array delimter characters as single-byte characters. This means that Un...

Try sending it to a text file. This has the second-least conversion.

(A Data Set has least, but you're then relying on View Data which others have suggested is a tad suspect.)

Seems like three years!

<sings>Tried for three years, seems like thirty...</sings>
(Jesus Christ Superstar - Tim Rice and Andrew Lloyd Webber)

As an alternative, try using

That text usually relates to the clearing of a hashed or directory-type file. Find a CLEAR.FILE command somewhere in you job or in a routine executed from it.

Assertion: this has nothing at all to do with the configuration file.

A search for "unexpected" may prove fruitful.

No they're Anglo-Nubians.