DSXchange

great - thanks for the clarification

Hi,

I am using Datastage version 7.5.1, with an Oracle 10g database. Oracle 10g uses connection pooling. Can this feature be used from DataStage?

If so - how?

Hi there, I'm having trouble accessing DataStage remotely. I have remote-accessed it regularly, but suddenly started experiencing a problem. I'm able to access the network fine, but the DataStage application wont open. The error message that comes back is: "Failed to connect to host: rchapp005....

Hi,

I have this sequencer which kicks off several jobs. I need a routine (let's call it SendWarning()) to be called if the said sequencer runs for more than 7 minutes. Any suggestion as how this could be done?

Resolved - Ray was right!

Hi there,

I'm having trouble saving an auto-purge change. I make the change, but when i go to save (by clicking "OK"), i get the following error message:

Unable to return an attached Job.
Cannot open file RT_LOG

what does this mean?

Here's the output. I hope I type out the right section ... 00159: $INCLUDE DSINCLUDE DSD_STAGE.H 00159 00000 : 058 dimcom STAGECOM.PIN 1024 => 1 00159 00008 : 058 dimcom STAGECOM.NUM.ROWS 1024 => 1 00159 00010 : 058 dimcom STAGECOM.ARR 8192 => 1 00160: $INCLUDE DSINCLUDE DSD_BCI.H ... anyway how can...

The output was:

"RT_BP869" is not a file name.

Anyway I have this intuition that this error was caused by the server running out of memory and swap space. It was trying to write 15-18 million rows to a bulk loader.

Hi, One of the my job aborted and the there was only one warning message: Abnormal termination of stage <Jobname>..Transform detected and here's the From previous run message generated when I reset the job: From previous run DataStage Job 892 Phantom 7929 kgefec: fatal error Abnormal termination of ...

Thanks for the help guys, it was a wrong aggregation being performed on the key.

Closing request.

thanks for reply,

There are no warnings/errors

The hash file is a lookup of itself. It works fine with a smaller set (even using records from the larger set), but when the whole 500,000 is pushed though, the lookup fails to match up any of the records.

How would the trim be of benefit?

thanks for the reply. I should have pointed out that the hash file is a lookup of itself (after an aggregation stage); so there are no issues with the key matching up. It works well when i Cull the amount of records down but it seems like the sheer amount of records causes the lookup to fail. So wit...

Hello, I have a question regarding a possible limitation in hashed files. We have a job that performs a lookup on a hashed file that was tested to function ok with small amounts of data. The same lookup failed to return any values when the hashed file contained 500,000 records. The Debug mode showed...

Hi,

I have noticed records are not stored in a sorted order in a hash file.

Is it possible to have the records sorted... or at least maintain ordering inside the hash file?

thanks,

SPA_BI

Currently we use DataStage server Edition 7.5 and we do a lot of batch processing. We would like to move from batch processing to near real time processing. We would also like to make the processes event driven and possibly make use of XML and web services. Could my current DataStage version cope wi...