DSXchange

I had this issue under a reinstall of 8.1 and a new install of 8.5. Both on Windows Server 2003 using the IBM ODBC connection not DataDirect. In both cases uninstalling and reinstalling the DB2 client resolved the issue.

Define the input column as VARCHAR and DataStage will not convert it to Universe's internal format.

I'm using a DRS stage to read a timestamp column from Oracle 8i. By default the generated SQL uses TO_CHAR with the format "YYYY-MM-DD HH24:MI:SS". To get the milliseconds I end up changing the type of these columns to VarChar and overriding the derivation with TO_CHAR(<col>, 'YYYY-MM-DD H...

I appologize if this has been asked before. I searched and found less than definitive answers.

Do hash files go away under 8.1 Server Edition of DataStage?

Thank you.

Does DataStage 8.1 run under 64b window? Is anyone running it?

I searched the forums and only found dated responses to this question.

Thank you.

Dave.

BINGO.

Yes, I was using "Insert new rows only". Changing it to "Insert Rows without clearing" did the trick.

Thank you.

Also, array size is 1. I can't get them to reject to a file. That was the original problem.

I am using a DRS stage to insert into MSSQL table via an ODBC connection. When a duplicate is encountered I expect the "reject" link from the transform feeding the DRS stage to trigger if the insert fails but it does not. In fact the job log does not even show an error. If I replace the DR...

Go out to IBM and download the Universe documentation. This will help you learn to write a program in Universe Basic that will parse the data from the underlying Universe files. I'm an old Pick programmer so it was not too difficult for me.