DSXchange

I got this issue solved.. Since it is a HP UX Itanium server all the libraries should be 64 bit.. Hence the environment variable for Oracle_Home should have lib instead of lib32. But still when I tried importing the meta data definition through ORAOCI9 plug in,all the Oracle instances in the TNSName...

Please find the contents of the dsenv file, # PLATFORM SPECIFIC SECTION set +u if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` export DSHOME fi if [ -z "$DSHOME" ] then DSHOME=/dsstg/Ascential/DataStage/DSEngine; export DSHOME fi if [ -z &quo...

when I try to import the meta data definitions through Plug in meta data definitions,I'm getting the following error,"Unable to Initialize Plug in".I installed Oracle client on DataStage server after installing the datastage sever.But,I'm not sure if that's an issue..

I have installed DataStage version 7.5.1A on hp-itanium unix server.
Oracle 10g doesn't create any problems with Datastage version 7.5.1A on Windows..Its working fine on Windows based server...

yes,I did restart the server after updating the dsenv file. I have created the environment variable for Oracle,after the following piece of code in the dsenv file, LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/IA64W/hotspot:$DSH OME/java/jre/lib/I...

I have created the following environment variable in the dsenv file. ORACLE_HOME=/oracle/product/10.1.0 ORAHOME=/oracle/product/10.1.0 LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32;export LD_LIBRARY_PATH PATH=$PATH:$ORACLE_HOME:$ORACLE_HOME/bin;export PATH ORACLE_SID=o...

Hi, I have installed DataStage on unix server.I created new environment variables for connecting to Oracle database in the dsenv file. But I'm not able to connect to Oracle from datastage.It gives me an error, Unable to initialize plug in,when I tried to import the meta data definition through ORAOC...

Hi,

Does Datastage have capabilities to pull data present in a directory server(LDAP) and populate it to a table in Oracle?
Can anyone help me out?

Regards,
Vimali

Hi, I'm facing the following issue while installing DS server for HP-UX. INSTALL.SH;1[22]: /dsstg/software/Ascential.media/HPIA64/SERVER.;1: Cannot find or open the file. ERROR: cannot unpack libdslic.so I have logged in as a root user. I'm not able to proceed with the installation..Can anyone help ...

Hi, I have a job which populates the data from a flat file(tab limited text file) to an Oracle table.The flat file has duplicate records.the oracle table to which the data has to be populated,has unique constraints on some of the columns,the combination of which should be unique.Since,the table has ...

Hi,

I'm getting the following error,when I'm executing a job.
Error : Attempting to Cleanup after ABORT raised in hash file stage.Because of this error no records are read from the hash file.Can anyone help me out in fixing this issue?

Thanks,
Vimali.

Hi, I'm trying to extract the error messages from the log file of a job to a sequential file.I'm using the DSGetLinkInfo function available in datastage.The syntax of which is DSGetLinkInfo(DSJ.ME,'Oracle_OCI_8','DSLink9',DSJ.LINKLASTERR),where Oracle_OCI_8 is the stage name,DSLink9 is the link name...

I didn't delete the oracle plug in..I uninstalled the Oracle 9i software which was installed previously on the DS Server,and installed Oracle 10g software.Is the problem due to this?

Hi, I tried populating a table from a text file.I get the following error, ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found. We had Oracle 9i client installed on the DS Server.but we uninstalled Oracle 9i and we installed Oracle 10g on the DS Server...

Thanks Ray, so if my DataStage Server is Unix then there should be a dedicated machine which will be my DataStage Server and I can install DataStage Client on different desktops right other than server right..


Thanks,
Vimali.