DSXchange

There's no way around the fact that you have to check five-digit prefix, four-digit prefix, and so on. Read-cached hashed file is the fastest mechanism "out of the box" to determine whether you have a hit. Otherwise you can create a routine that compares against a bit map, or a map of 1 and 0 charac...

You are trying to update the hashed file in real time. That's OK, but it means that you can't use cache - the hashed file is cached for reading before the job starts processing rows, and isn't updated thereafter. It also means you need two separate Hashed File stages, though they refer to the same h...

FUNCTION AddSecondsToTimestamp(argTimestamp, argSeconds) $COPYRIGHT "Copyright (c) 2002-2005 Ray Wurlod. All rights reserved." $* Adds seconds (signed integer) to timestamp. DEFFUN IsValid(TestValue, DataType) Calling "DSU.IsValid" * Some bullet p...

Ultimately you will need a routine, to handle the possibility that the time offset has to rewind the date (for example going backwards 45 minutes from 00:30). Design the logic as a program specification (in English or any other language with which you are comfortable). Make sure you have all possibi...

It's a question of whether it's supported or not.

You can get 7.5x2 running on XP Pro, but IBM won't support it. I'm not sure about 2000 Server.

dxp wrote:is there any specific reason why this facility is not provided in join stage.

You'd have to ask that of the manufacturer.
Have you considered a Lookup stage with two reference inputs as an alternative?

chulett wrote:Well, there is a specific version of DataStage EE that allows you to run PX jobs on Windows - 7.5.X2 - from what I recall.

No dot, little "X". 7.5x2

Was this table loaded from a text file whose first name contained column headings but this was not set as a property in the Sequential File stage in that job?

Are you just trying to load the stored procedure names in to a VARCHAR2 column in an Oracle table? That is a very easy job; read them with a Sequential File stage and write them, with an ORAOCI stage. You may need an intermediate Transformer stage to generate any other column you want to insert at t...

Are you running with NLS enabled or disabled (or not installed at all)?

If it turns out, as others have suggested, that the T30FILE table was full, then you may need to increase the T30FILE configuration parameter.

Search the forum for uvconfig and uvregen to assist with this.

!GET.PATHNAME and !MAKE.PATHNAME were written in the mid-1980s, before UNC pathnames had ever been heard of! I'm not surprised that they are not properly handled; it was a major surprise at VMARK when drive letters had to be accommodated! Indeed, you will see heavy reliance on the fact that Windows ...

... or get your boss to stump up to send you to the class following II Live!

Is the server on Windows XP? (I assume XP Pro - I don't think it will even install on XP Home.) What exact version of DataStage?

There are several issues with 7.5x2 on this platform.

It may also be the case that your Repository tables need to be re-indexed.

The latest Newsletter (Oct 2005) expands on the ideas in this thread in an item titled Good Habits and Bad Habits.