DSXchange

Hi Deepak,

First , you have to handle failure of routine also in sequencer and another thing may be that you are returning the number through routine.while you are using the routine in sequencer.it is like before/after stage routine so in that case your answer for routine must be 1 or -1 or 0.

Hi Gurus, I am able to create the DSN in windows and use it. When i am trying to create the DSN and use it , I am getting the below error. DSR.MetaGeta(GET.TABLES)(SQLConnect('Ora','dwd6')): BCI Error: SQLSTATE=HY000,CODE=7505,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol drive...

Hi,

I am able to connect through sqlplus But cannot connect through DSN in Datastage.

Hi,

I have checked from tnsnames.ora file and also nothing is there in Unix to check the connection.And port number i have taken is 1521 which is the port for oracle.

Hi , I am trying to create DSN on unix,but facing the problem.I have created the 'ora' DSN but it is giving warning and not able to connect to database. First i have created the DSN in .odbc.ini in DSEngine [Ora] Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMora19.so Description=DataDirect Orac...

In my case, 'Oracle wire Protocol' is the DSN name.In the administration guide it is given that for adding entry in uvodbc.config file we have to give just DSN name in format <dsn-name> and then DBMSTYPE = ODBC to differentiate from universe connection.In my case I am changing the uvodbc.config file...

Hi, While Importing the meta data fro the newly created DSN.I am facing the error DSR.MetaGeta(GET.TABLES)(SQLConnect('Oracle Wire Protocol','dwd6')): BCI Error: SQLSTATE=HY000,CODE=7505,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name a...

Hi,

I am new to datastage.I have checked odbc.ini and Uvodbc.config and tried to change but it is just showing dsn name only in case of importing table but could not connect to database.Please give the proper details to configure dsn with example,how you have configured it.