DSXchange

I got this error one time. Maybe this particular column job_lvl datatype in the DataStage is different from what is in the Table is the Database. For. Eg In the Datastage I had a Prod_id Char(5) and in the Oracle Table it was only Char(4). I had changed it to char(5) manually in the DS thinking I ha...

Thanks Sainath and Palmeal
I added that to the PATH and it worked..
I appreciate your help.

Hi, Datastage Server is in a Linux box. I connect to the server using PUTTY and then tried to run a job with the command dsjob . I am getting the error: "bash: dsjob: command not found". Is there a path that I need to set up. I went to the Project folder where the project resides and then ...

Thanks for all your input..I was able to establish ODBC connectivity successfully..

Hi, DataStage is installed on a Linux Server. Oracle is in another Unix Box. Oracle 9i Client is installed in that Linux server. From a local machine that connects to this server, I am designing a simple job using ODBC stage. For this I followed the steps in order 1) Created a systen DSN in the loca...

Hi, I am trying to use ODBC in my Server job. For this, I created a driver( in System DSN) to establish connection in my m/c using Control Panel/administrativeTools/Datasources. I am not able to seethis Data Source Name in Ascential DS Designer Server job. It is showing the System DSNs on the server...