why does Datastage not support Datatype INT8(serial8)
Moderators: chulett, rschirm, roy
why does Datastage not support Datatype INT8(serial8)
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
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
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.
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]
Regards,
Prasoon
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!!
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!!
Regards,
Prasoon
Prasoon
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How about
Hopefully the arithmetic will perform a legal implicit CAST.
Code: Select all
SELECT o_abc_uid + 0 FROM tablename...
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.