Page 1 of 2
why does Datastage not support Datatype INT8(serial8)
Posted: Mon Sep 26, 2005 3:43 pm
by singhald
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
Posted: Mon Sep 26, 2005 4:03 pm
by ketfos
Hi,
Try mapping it as Data type BIGINT
Ketfos
Posted: Mon Sep 26, 2005 4:54 pm
by singhald
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
Posted: Mon Jun 26, 2006 1:22 am
by prasoon
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
Posted: Mon Jun 26, 2006 2:10 am
by ArndW
In your SELECT use the CAST function.
Posted: Mon Jun 26, 2006 3:31 am
by prasoon
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]
Posted: Mon Jun 26, 2006 3:32 am
by prasoon
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!!
Posted: Mon Jun 26, 2006 3:50 am
by ArndW
I don't see a CAST at all in your SELECT; what did you try?
Posted: Mon Jun 26, 2006 4:17 am
by prasoon
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? ...
Posted: Mon Jun 26, 2006 4:34 am
by ArndW
How about CAST(o_abc_uid as Integer), what happens when you attempt that? If it doesn't work, what is the error message?
Posted: Mon Jun 26, 2006 5:26 am
by prasoon
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? ...
Posted: Mon Jun 26, 2006 6:20 am
by ray.wurlod
How about
Code: Select all
SELECT o_abc_uid + 0 FROM tablename...
Hopefully the arithmetic will perform a legal implicit CAST.
Posted: Mon Jun 26, 2006 6:33 am
by ArndW
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?
Posted: Mon Jun 26, 2006 6:34 am
by chulett
Shouldn't the answer also involve changing the datatype in the source stage to something supported - like Integer?
Posted: Mon Jun 26, 2006 7:01 am
by DSguru2B
I think this is the source thats creating the problem. What about odbc stage. Can you use the odbc stage to send a select?