DSXchange

Hi Can anyone please help me with the following queries: My o/s is solaris 2.8 For DS6: 1) does the OCI8 plugin work with oracle 8.1.7 databases? 2) Is there an OCI9 plugin for oracle 9i (oracle 9 release2)? 3) Would jobs developed on ver 4 using the oci 8 plugin to connect to oracle 8.1.7 databases...

Thanks Craig

We'll check that out

Nigel

Hi, I'm currently getting this error after I installed the OCI Buulk loader plug-in.: oraocibl.so: symbol nauzaoss: referenced symbol not found Any ideas? I've checked the Oracle sites and most info relates to a problem with oracle libraries and paths. The standard OCI plug works and has been for ag...

Thanks Ray and Kevin, I will certainly make that request ( some hope hey!) I managed to install metastage and found the "where-used" and "depends on" in the imapct analysis. This certainly does help. My client uses PVCS as their strategic version control tool. They required some ...

Hi, Does anyone know how to write some sort of routine to identify all dependant components of a datastage job/control job. We need to basically prompt for a Job name and then return all controlled jobs(if a batch job is entered), and every routine and transform that is used in the job. For batch jo...

Hi, Ray, you're great. I've always managed to find answers to most of my queries by searching the archives. Almost everytime a solution would be posted by you. Your help has proved invaluable and is so refreshing to find someone willing to transfer their skills Thanx Nigel[:D][:D][:D][:D][:D][:D][:D...

Hi Looks like all the info you require is stored in the RT_STATUSxx file for the job where xx is the job number. This file contains several types of entries, the valid types for your requirement being: JOB => which gives you job stats of start time and end time STAGE => number of rows processed on e...

Hi We are currently undergoing a scoping exercise for a forthcoming upgrade from DS 4.02 to DS.6.0xx Our site config is as follows: 1. Three DataStage Servers (all on Ver 4.02) running on 3 different versions of Solaris (2.6, 2.7. and 2.8) 2. Oracle Databases accessed also vary in versions - this re...

Hi Guys, What about write some code that does the following: Creates a file pointer entry in the VOC with a type "F", data location of the directory name, dictionary pointing to the same path as the dictionary of the "&UFD&" file. This will make datastage see the direcory...

You could also log into DS administrator and at the command area issue the following command: "COUNT hashfilename".
This is using the native DS/UniVerse retrieve commands

Regards

Nigel

Nigel

Hi,

Could I also please get the link to download the "CompileAll" utility

Regards

nigel

Nigel

Hi, I encountered the same error. In my case, the error occured on a lookup table. Staging the data to a hash table and then reading from the hash table solved my problem. I've raised this with Oracle and am still awaiting a solution. The DBAs tried everything to resolve this including dropping and ...

Hi, I've never encountered that problem sofar. You should reference the parameter in your constraint without the "#" prefix and suffix. eg. Field(PARAM,",",1) instead of Field(#PARAM#,",",1) where PARAM is your parameter. Hope this helps and that I've understood your pr...

Hi Bala It depends on what was done prior to your problem. If you had just installed/imported a large amount of jobs into your project via DataStage Manager, then it is best to do project cleanup prior to and after importing components. This is just a precautionary measure, and seems to work for me....

Hi Just thought I'd post this problem we've just resolved. In DS Designer, while entering a parameter with a type "pathname" and then double-clicking the default box, An error was returned "Cannot open directory /, directory appears to be empty". This problem occures on Solaris. ...