DSXchange

Isn't that you setup the ODBC DSN on the client machine which would be on Windows?
Or how did you setup your DSN?

As the error message suggests - Did you check the host name and port number in your DSN setup?
Did you click on the Test Connection button on the ODBC DSN setup tab and verified you could establish a connection?

Think you could not have a single hashstage with the same hash file for read and write. It would not compile. We have some couple of jobs that we have just to create a empty hashfile. SourceDB --- > xfm ---> HashStage where the output from the sourcedb is set to return no rows.. like where 1 = 2.

I have used the same tables as lookup using OCI stages, before I insert or update. Started the design with hashfile lookups and later changed to DB lookups. Have I gone down the wrong path?.

Please provide what you have tried and not working.
As far as I know you should be able to write and read from a hashfile in a job. Mebbe you could turn on caching WRITE IMMEDIATE while you write to the hashfile and use 'Disable, Lock for update' in preload option while you read.

On the tabular display of your output link in transformer, you would find a header called constraints. Double click on it to open the expression editor for constraints and enter lookup_ID.NOTFOUND, where lookup_ID is your lookup input link. When you have opened your transformer stage constraints edi...

Hi Tasneem,

Did you load the column metadata from oracle table definitions? If you haven't, load the columns definitions and check the data by clicking on view data.
IHTH.

This post and this from Ray :D should help you.

You could slightly modify Arnd's solution with Iconv(1900+ DateString[1,3]:".01.01","D4YMD" to suit yours

Can you check whether the user id with which you are logging into unix from the DataStage client has read permission on tnsnames.ora file?

Don't think its anything with the plugin... Got to do with the ODBC oracle driver you have setup for DS. Lookup the manual for the driver you have installed and whether it supports the datatypes and the length or precision you are trying to select.

What are the field types of X,Y and Z? Check if your driver supports these datatypes.

SQL server is more lenient when you want to insert a date than other DBs(Oracle, DB2). If you pass the data in as a varchar in the format that matches the date format of the field, SQL server would do the cast for you internally. No need to append the time part. Inserting a date shouldn't be such a ...

my job is doing 2 updates to same table different fileds with 2 links and one connection and 1 odbc stage when Array size1=10 and transactionsize1=20 Array size2=1 and transactionsize2=1 it thrwos error odbc coud not position table Array size1=10 and transactionsize1=20 Array size2=20 and transacti...

Are you trying to insert the selected CLOB value into another Oracle table downstream? Possibly the OCI_HANDLE_ERROR could occur because of the pointer to the LOBLocator exists in the session or OCI env where you did a select and becomes invalid when moved to another session. If thats the case may b...

SQLSTATE=23000, DBMS.CODE=273 [DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column. SQLSTATE=37000, DBMS.CODE=8180 [DataStage][SQL Client][...