DSXchange

The key is finding the differences between the two and it sounds like you have. We've seen odd Oracle issues with 10g on HP-UX Itanium boxes, so I'd probably open a support case to see if this is one of the known issues. What box is the development environment? I was told there's no 9i client avail...

chulett wrote:So... two different posts with the same issue?

viewtopic.php?t=122860

That way leads to madness, or at least schizophrenic discussions.

Sorry about that - but I didn't realize that my colleque had already posted that issue. I will mark this post as solved.

What data type is this "spalte_a" column? And are you saying that when it works from the 7.5.2 server and doesn't work from the 7.5.3 server they are both connecting to the same instance? Using the same version of the Oracle client? The datatype is varchar2(100). Sorry - I've forgot to me...

Hello, I've went through this forum hoping to find any solution or suggestion regarding to our problem - which is a little bit strange from our point of view. It can be described as follows: we are using DataStage Enterprise Edition release 7.5.3 installed on a HUP-UX box (Intel Itanium). On the sam...

DS-EE 7.5.3, Oracle 10g environment, HP-UX on Intel Ithanium We have the following job design: [oracle oci stage] --> [oracle oci stage] We configured UPSERT with user defined statement in order to do an insert only. If source and target are the same dbms (ora 9i) upsert works. If source is differen...

Try making Direct and Parallel options to false and run. Below quote may be of interest for you In Oracle 10g - 9i combination, when you try to load to 9i using 10g sqlldr it finally try to insert/update MESSAGE_NUM column which does not exist in 9i. Please check following thread for further detail...

Hi I am facing problem with Load option while loading from source table(oracle 10g) to target table (oracle9i). I have selected write method as load & truncate. In this situation job got aborted and returned the error sqldr 256. But the same job tried with insert option. The job was successfull...

Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'. do you have the orchoracle softlink in your $DSHOME/../PXEngine/lib or $APT_ORCHOME/lib path I dont know from where and where to I do have to create the softlink If you are using...

That would be the first thing I'd try - a reinstallation of the client. The first install of the DataStage client raised the described exception. Afterwards I deinstalled DataStage and bounced the windows pc. Then I installed DOT NET first and as as next step the client once again. That didn't chan...

Hello, On a windows (Windows 2000) client I have installed Microsoft's DOT NET (release 1.1) and the DataStage client (release 7.5.2). Afterwards I performed a reboot. After the logon several messageboxes - because of missing DLL's - are popping up. All of them are related to DataStage. The Designer...

ray.wurlod wrote:Only by taking the class, I'm afraid.

Maybe, in future, it will be made available through DSXchange Learning Center, but those arrangements are not yet in place.

I wouldn't mind coming to Australia and taking the class
But many thanks anyway for helping with my issue!

Rgds
Jan H.

No. At least nowhere that I've looked. (Well, that's not entirely true - they are documented in my DataStage Administration class - though not, curiously, in IBM's Administering DataStage class.) Any change to get some further information from your documentation :roll: ? Rgds & Thx Jan H.

Yes, I thought it might show internal hashed file errors. The quickest solution with the highest chance of 100% recovery is to do a full project export, delete the corrupted project, re-create it & load in the jobs. If you cannot do this then we can go about looking for the cause, but we've tou...

Yes, I thought it might show internal hashed file errors. The quickest solution with the highest chance of 100% recovery is to do a full project export, delete the corrupted project, re-create it & load in the jobs. If you cannot do this then we can go about looking for the cause, but we've tou...

At the TCL prompt or from the administrator, enter: UVFIXFILE DS_JOBS UVFIXFILE DS_JOBOBJECTS and please post the results. Here are the results: >UVFIXFILE DS_JOBS Beginning TRACE of DS_JOBS. TRACE of DS_JOBS completed. Scanning overflow buffers. Scan complete. 9 group(s) processed. 11 group buffer...