DSXchange

Hi

I am required to read data from different worksheets (tab) in a excel file and write to a table. I tried to develop a DS job but its just reading data from first tab. The data type and number of columns are same in tabs

Could any one let me know how to accomplish this?

Thanks

Hi Everyone, I have a job design as DRS(DB2 database) ---> Copy stage--->DRS( Sqlserver) | Aggregator --->ODBC(audit Source rows) The job is taking around 15 mins to complete in datastage where as the same job is taking 8mins in SSIS. The volume of records is 2million and the rows for transaction is...

We are able to connect now after we created DB2 catalog entry and configured the DB2 client. Issue is resolved. :D

Thanks!

We were able to connect from the Datastage server on windows but we are unable to do so in AIX. But in windows we added DB2 database connection using DB2 configuration assistant and we used the same when we create DSN. Can anyone tell us how to configure DB2 client in AIX? (we are using the DB2 data...

Hi, We are trying to configure DB2 API stage in AIX server. We configured the following variable in the dsenv file. INSTHOME=/dss/db2inst1;export INSTHOME DB2INSTANCE=db2inst1;export DB2INSTANCE DB2DIR=/dss/opt/IBM/db2/V9;export DB2DIR DB2CLIINIPATH=$DSHOME;export DB2CLIINIPATH LIBPATH=$LIBPATH:$INS...

Hi, I migrated the project from 7.5 version on HP Unix machine ( 2-CPU) to version 8.0.1 on AIX machine(1 cpu) and moved all the files to the new server. I didnt copy the hashfiles from old server to new server. what i did was i ran all the jobs where the hashfiles are created in the project directo...

Hi ,

Thanks for your suggestions .The issue got resolved by installing the Informix client software on the datastage server and by setting the sqlhosts and services.

Once again thanks

yes the database has no transaction logging. I even got the same error with informix wire protocol driver and odbc stage on windows machine for version 8.0.1 , for that i got a patch from IBM. Now recently i have installed the version 8 on AIX machine . i dont have much idea on AIX and installtion p...

Hi thanks for you reply. I have installed Informix sdk client 3.0(32-bit) for AIX on the machine. The directory is:dsadm@CommDSdev1/dss/clientsdk. I setup the /etc/hosts file on datastage server to see the Informix machine Internet Address Hostname # Comments 10.1.11.11 uwghp01.uwg.corp uwghp01.uwgr...

Hi, we have a project in Datastage version 7.5.1 on HP Unix box. The source and target database is Informix. The informix database resides on the same HPUnix box. Informix Cli stage has been used in the jobs. Recently i have installed IBM websphere datastage version 8.0.1 on AIX box. My job is to mi...

Hi , Can you give an idea of putting the relavant commands in .profile. I dont have an idea what commands to put in .profile.iam not able to figure it out where the issue is .. Iam copying the dsenv script and .profile -- dsadm@uwghp01:/dss/Ascential/DataStage/DSEngine$ vi dsenv "dsenv" 80...

Hi, We have datastage version 7.5.1 on HP Unix box. And we are planning to install IBM Information server 8.0.1 ( got licence for only websphere datastage) on AIX box. Client wants to migrate the project from 7.5.1 on HP unix box to version 8.0.1 on AIX machine. I have searched the forum with the ke...

Thanks .

Hi, We are doing a fresh installation of IBM Information server 8.0.1 on AIX machine. As we donot have datastage admin over here they asked me to install the software . Do we need to install C++ compiler before installing the suite?? As the datastage is server edition is it mandatory to install c++ ...

Hi, Thanks chulett for your reply. Yes it worked . But when i tried to execute the same command after closing that session and opening a new telnet session iam getting the same error. Could you let me know what should be done to work the commands in bin directory even after opening a new session . o...