DSXchange

Congratulations Ray!!!!! And thank you for all your help!!!!

Hi, We are trying to read records from an Oracle database that contain dates with negative years (as in BC) using Oracle connector. We get the following run time error: Source_Table,0: Can not convert to framework type timestamp (CC_PXAccessor::setCalendar, file CC_PXAccessor.cpp, line 4,409) Is the...

Thank you Ray. Works fine.

Hi, I am writing a generic job that will accept SQL statement as one of its parameters. The SQL extracts data from a source table. The job then loads the extracted data into the target. Oracle --> Xform --> Oracle No columns are defined - I'm using 'Runtime column propagation'. The job works fine un...

Hi

I have experienced similar behaviour - when default warnings limit is used the exception handler gets invoked as expected. However, when the warning limits are set to 'No Limit' then the exception handler does not get invoked.

I am working with 8.5.

Hi Everybody, Please consider the following scenario. A DataStage job creates an Oracle session to perform whatever tasks it is designed to perform. The same job completes successfully. The Oracle session created by this job becomes inactive and precisely 2 hours later is closed, i.e. no longer appe...

We have encountered the dreaded mutex errors. I have searched the forum for suggestions and found some comments about changing the values of SPINTRIES and SPINSLEEP parameters. After stoping DS, changing the values of these parameters to 50 and 5000 respectively, regenerating and restarting DS, I fo...

Does anyone know how to set up QualityStage / DataStage so that QS will be hosted on one physical server while DS will be hosted on another ? We are getting the following message, although both DS and QS are up and running (and working OK): Failed to open QSRT connection: check qsrtmngr is running, ...

Great. Thank you very much for your help. :D

That's right. The product_key in product_lookup is a subset of the product_key in item_master, hence there are multiple records in item_master for each record in product_lookup.

The two tables 'live' in separate database instance (and separate physical hosts).

The master table holds approx 70M item records. My lookup table has about 1M product records. Using the product records in the lookup table, I expect to extract approx 3-4M item records from the master table. I hope this helps.

Thank you, but I do not have an ODBC connectivity between DS and the Oracle servers.

I need to retrieve multiple rows from an Oracle master database using records stored in another (lookup) Oracle database. Essentially, each record in the lookup table will have multiple corresponding rows in the master table. All rows retrieved from the master table need to be then stored in another...