DSXchange

This will also give the same result
Ereplace(Fold(InLink.DESC_,3),@FM,',')

Array size is the number of record read and writes at a time in the database. Better to use transaction size=1 which will make sure to commit one record at a time along with array size=1.

Hi , In the oracle database target table among the 10 columns, 2 columns have CLOB data type and in the corresponding staging job I'm using it as a LongVarChar for the respective columns. And just because of 2 CLOB columns in the target job failing. When I change one of the CLOB columns to Varchar i...

So Comparing two nullable columns is a Pitfall? And instead of writing col1=col2 I should write (If(IsNull(col1))then '' else col1)=(If(IsNull(col2))then '' else col2) Is that right? Thanks again for all the help :D :D :D Yes That's correct,here if both columns are NULL will pass through the EQUAL ...

Yes,Those record which having NULL value(wchic u are comparing) will pass through reject link.

we are using Oracle 9i

This post is in wrong Forum,please don't repllyy on this Hi, I read lots of post in this forum related to same topic, but still didn't have any solution. Following log massage I'm getting and after that job getting failed. Any suggestion would be appreciated. Item #: 94 Event ID: 87828 Timestamp: 20...

Hi, I read lots of post in this forum related to same topic, but still didn't have any solution. Following log massage I'm getting and after that job getting failed. Any suggestion would be appreciated. Item #: 94 Event ID: 87828 Timestamp: 2006-08-25 17:53:12 Type: Warning User Name: informix Messa...

Hi, I read lots of post in this forum related to same topic, but still didn't have any solution. Following log massage I'm getting and after that job getting failed. Any suggestion would be appreciated. Item #: 94 Event ID: 87828 Timestamp: 2006-08-25 17:53:12 Type: Warning User Name: informix Messa...

Whether anybody has found a solution to this problem, or whether a bug fix has been issued.
Any help or advice would be greatly appreciated.

Yes ArndW,
still I'm getting same error.

ArndW wrote:How about CAST(o_abc_uid as Integer), what happens when you attempt that? If it doesn't work, what is the error message? ...

I usedCAST function like this.....

SELECT CAST(o_abc_uid as Numeric),column1,column2 FROM tablename

Please let me know, it is the correct way or not!!

ArndW wrote:I don't see a CAST at all in your SELECT; what did you try? ...

Hi ArndW, I used CAST function but it's not working at all.still same error..... [/quote]JobName..ObjectName:Informix data type 'INT8' for column 'a_abc_uid' is not supported in SQL statement: SELECT a_abc_uid,column1,column2 FROM tablename. JobName..ObjectName.DSLink1:DSP.Open GCI $DSP.Open error -...

Hi ArndW, I used CAST function but it's not working at all.still same error..... [/quote]JobName..ObjectName:Informix data type 'INT8' for column 'a_abc_uid' is not supported in SQL statement: SELECT a_abc_uid,column1,column2 FROM tablename. JobName..ObjectName.DSLink1:DSP.Open GCI $DSP.Open error -...

Hi All,
Can Anybody suggest possible solution for this.

Thanks in advance.

singhald wrote:hi

i have tried this ,
but this is also not working it giving same error type message
"Data type BigInt define in that coloumn is not supporting"


plz give me another sol for this

bye