DSXchange

Thanks Ray. We will update the lib.
-Kumar

Craig,

Our DataStage is 64 bit installation on AIX. Do you see still see we need to use 32 bit oracle.

Craig,
Our installation is 64 bit, IBM setup those settings as 64 bit for Oracle too.

Thanks
Kiran

Thanks Craig, #ORACLE ORACLE_HOME=/opt/oracle/OraHome_1; export ORACLE_HOME PATH=$PATH:$APT_ORCHHOME/bin:$ORACLE_HOME/bin; export PATH ORACLE_SID=CLFY; export ORACLE_SID LIBPATH=$LIBPATH:$INSTHOME/sqllib/lib:$ORACLE_HOME/lib:$DB2DIR/lib64; export LIBPATH We have multiple oracle databases other than ...

Hi
VMora22.so file is not available in /branded_odbc/lib folder. VMor823.so is shown in demo/ example for oracle.

About the 32 bit / 64-bit change can any one give me more insight.

Thanks
Kumar

Thanks Ray, I searched the forum I didn't see any thing similar. The dsenv has LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:$ASBHOME/apps/jre/bin:$ASBHOM E/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/ap...

Hi Please see this error message while creating data source for IA, I tested this DSN to connect to Orale using ODBC from ALALYZERPROJECT which is working fine. I checked the 2 services are running LoggingAgentSocketImpl and AgentImpl. ODBC function {0} reported: SQLSTATE = IM003: Native Error Code ...

Thanks for your response, These is no bad file created and I tried with preserve blanks, still it aborted. I just tried with 10 rows as input. DataStage log: Oracle_Enterprise_4,0: SQL*Loader-350: Syntax error at line 121. Oracle_Enterprise_4,0: Expecting ")", found end of file. Control fi...

Thanks Ray,
I did cat on that file in unix (AIX). The DataStage job aborts too.

Hi The job aborts while using Oracle Load, the design is DB2 Enterprise-> Xfm -> Ora. This job is successful while using Upsert but slow with 450 rows/sec, only fails when using Load method in target Oracle, I have 135 columns with 6 million rows the same job is successful for ~116 columns when usin...

" FTP Stage------>Sequential File FTP_Enterprise_0: uri : ftp://HOST/PATH/filename.txt is not valid remote file. But i have a file in the above specified remote path. " It depends on relative or absolute path, if the user name is abc and the path will find the filename try to navigate to t...

Hi , I have a requirement to pull the file from remote server out side network and place it on datastage server. Once after getting the file i need to remove that file on the remote server , so that the next day also there will be only one file with name file* . Then this file should be used to loa...

I was looking to solve same kind of situation.... I need more specific information on the (write a routine) is that a UNIX or DS routine... Plz tell me more about that routine.. that will is helpful.. My question is to get the receipts mailids from a flat file to notification activity. ENV:7.5.1 in ...

Can you post the SQL you are using? This code works fine in SQL DB, when I made updated with ? for DS, it shows ERROR, any quick changes needed! SQLSTATE=S1009, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value Code: IF (SELECT ISDATE(MAX(TERM_DT)) FROM TABLE_A ...

Hi I searched all the threads :shock: , I still need some more ideas to fix this one, HAsh-> Trans --> ODBC I need to update ( date fields ) in the existing record (SQL Server) search for which ever is latest one and then Insert new one. Error Log: DSD.BCIPut call to SQLExecute failed. SQL statement...