DSXchange

Let's assume you've got a constant called svLINELENGTH (that is, a stage variable with an initial value of, say, 80 and no derivation). To get a string (let's call it svHeaderLine) centred use an expression such as Space(svLINELENGTH - Len(svHeaderLine) / 2) : svHeaderLine Division takes precedence ...

Was NLS enabled or disabled in 7.5 ?

Change your Oracle default date picture that governs display of dates.

Keep digging. Find out how the wrong value got into the hashed file in the first place (as per my earlier email).

We don't do "urgent". DSXchange is an all volunteer site whose members post if and when they can, and under no compulsion to do so. For example when you posted I was asleep (it was midnight my time). If you need "urgent" help sign up with your official support provider for premi...

This configuration offers two nodes, only one of which is in the default node pool (the one with "" as its pool name). The other one is in a node pool called "DB2". Non-DB2 stages will, unless specified otherwise, execute in the default node pool. In your configuration that means...

What's in the title bar of the stage when the stage with multiple input links is open?

... which is as it should be.

I did. Please read my complete post.

Premium membership is not expensive (less than 30c (Rs12) per day) and is well worth having!

(Thinks) Ah, I remember that wonderful Prime utility FIND_RING_BREAK.
<Ancient Dilbert reference> You could work out whose office carpet the token had fallen onto.</Ancient Dilbert reference>

PTERM isn't about phones.

It's a silent "P", as in swimming.

Hack through your terminfo database to see whether there's any mention of RING there, unless RING was part of your command line.

SET.TERM.TYPE, GET.TERM.TYPE, TERM and PTERM are closely related commands.

"As source and target" probably doesn't matter, provided the correct version of the DB2 client is installed on the DataStage server (engine tier). As far as DB2 is concerned, a DataStage job is just another client application.

Did you specify "treat as File Set" in the Sequential File stage and then have no files that matched your wildcard specification? That would cause this error.

Or even the same Convert(), as shown in my edited response from earlier.

As far as I can recall, the Hashed Files stage automatically performs a conversion if the data type is Date. You can check for this by temporarily dropping your Oconv() function. The internal format of 8/10/2002 (using "DMDY" conversion) is 12641, so I'm not clear where you got 15555. I'd ...