why does Datastage not support Datatype INT8(serial8)

singhald · Post by **singhald** » Mon Sep 26, 2005 3:43 pm

Hi all
I am suffering with this problem.
Getting database repository interface error stating that
Datastage does not support Datatype INT8(serial8)

The informix database it looks for a field with a
datatype Serial8 which is sequential autogenerated number.

Why does datastage doesnot support this datatype?
how do we configure datastage server to make it underatnd
this datatype as well?

Deepak

ketfos · Post by **ketfos** » Mon Sep 26, 2005 4:03 pm

Hi,
Try mapping it as Data type BIGINT

Ketfos

singhald · Post by **singhald** » Mon Sep 26, 2005 4:54 pm

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

prasoon · Post by **prasoon** » Mon Jun 26, 2006 1:22 am

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

ArndW · Post by **ArndW** » Mon Jun 26, 2006 2:10 am

In your SELECT use the CAST function.

prasoon · Post by **prasoon** » Mon Jun 26, 2006 3:31 am

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 -2.

While in the table definition a_abc_uid define as Serial8
Even I used TRUNC function but it's not working.
Please help me out!!
[/b]

prasoon · Post by **prasoon** » Mon Jun 26, 2006 3:32 am

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 -2.[quote]

While in the table definition a_abc_uid define as Serial8
Even I used TRUNC function but it's not working.
Please help me out!!

ArndW · Post by **ArndW** » Mon Jun 26, 2006 3:50 am

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

prasoon · Post by **prasoon** » Mon Jun 26, 2006 4:17 am

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? ...

ArndW · Post by **ArndW** » Mon Jun 26, 2006 4:34 am

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

prasoon · Post by **prasoon** » Mon Jun 26, 2006 5:26 am

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? ...

ray.wurlod · Post by **ray.wurlod** » Mon Jun 26, 2006 6:20 am

How about

Code: Select all

SELECT o_abc_uid + 0 FROM tablename...

Hopefully the arithmetic will perform a legal implicit CAST.

ArndW · Post by **ArndW** » Mon Jun 26, 2006 6:33 am

Odd, the message reads

Informix data type 'INT8' for column 'a_abc_uid' is not supported in SQL statement

. That looks like a pure DML error. Can you issue this SQL in your command line?

chulett · Post by **chulett** » Mon Jun 26, 2006 6:34 am

Shouldn't the answer also involve changing the datatype in the source stage to something supported - like Integer?

DSguru2B · Post by **DSguru2B** » Mon Jun 26, 2006 7:01 am

I think this is the source thats creating the problem. What about odbc stage. Can you use the odbc stage to send a select?