DSXchange

ray.wurlod

Then search an export (DSX) file, or query the DS_JOBOBJECTS table from within the dssh environment. Note that DataStage SQL identifiers are case sensitive.

Code: Select all

SELECT * FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%PSEUDO%';

ray.wurlod

Bound to be, but I'm not at a site where I can look at that. (At another pre-installation site.)

ray.wurlod

The config.ini file does not get deployed. It is used to build a BGA image in which the password IS encrypted.

ray.wurlod

Mine so far have all been on Windows XP. (The same shop only upgraded from IE6 late last year.)

ray.wurlod

Ditto. What output do you require? Perhaps you can solve it via the Filter command in a Sequential File stage - which will read stdout of the Filter command rather than any particular file.

ray.wurlod

So you have proven that the data are being hash partitioned on POL_NB. Are you claiming that there is one value of POL_NB that is found on more than one node? If so, please figure out a way to demonstrate that and get in touch with your official support provider.

ray.wurlod

Would it make any difference if your reference data were partitioned three or more ways, so that any one process had less than 2GB of reference data with which to deal?

ray.wurlod

zaino22 wrote: It is faster with one column extract and performance goes down as we add more columns.

That makes complete sense, since elapsed time will be directly proportional to total volume of data needing to be processed.

ray.wurlod

Possibly an External Source stage will be what you require.

ray.wurlod

Use Quick Find and search for *PSEUDO*

ray.wurlod

Look for similarly-named functions, maybe TimestampSinceFromSeconds(). We often post without access to the software; at the moment I'm in a hotel room.

ray.wurlod

Code: Select all

@DATE - 1

or

Code: Select all

Date() - 1

This gives yesterday's date in DataStage internal format. To convert to human-readable format use Oconv() function. For example

Code: Select all

Oconv(@DATE - 1, "D-YMD[4,2,2]")

ray.wurlod

Compare all the properties in the two ODBC Connector stages, looking for ANY differences.

ray.wurlod

The syntax of tr command is no different called from DataStage than what you would use in UNIX. How were you planning to call it? Perhaps an External Filter stage?

ray.wurlod

I still prefer explicit DSGetParam() calls, believing that the code is more self-documenting using that approach.

Search found 53125 matches