why does Datastage not support Datatype INT8(serial8)
Moderators: chulett, rschirm, roy
Can you cast this as varchar(32) and define it as varchar(32) in the datastage column definition? I don't have access to Informix here. I am still surprised at your error message, since that is generated in SQL and not in datastage it doesn't make sense in this context.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi DSguru2B
We cannot use this ODBC stage because we are using informix stage this is plugin. we have use meta plugin. i know datastage6.0 doesnot support serial8 infmromix datatype. we have tried all the option , like we took integer, numeric , typecasting , but did'nt sucessed. please provide some resolution on this if you faced this type of prblem in past.
Singhal
We cannot use this ODBC stage because we are using informix stage this is plugin. we have use meta plugin. i know datastage6.0 doesnot support serial8 infmromix datatype. we have tried all the option , like we took integer, numeric , typecasting , but did'nt sucessed. please provide some resolution on this if you faced this type of prblem in past.
Singhal
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Casting of Serial8 to interger
If we cast serial8 to integer, it works fine. But the problem is the integer datatype stores whole numbers that range from -2,147,483,647 to 2,147,483,647, for 9 or 10 digits of precision. The largest SERIAL8 value that you can assign is 9,223,372,036,854,775,807. So, When you reach a value greater than 2 billion (which is quite possible), the code breaks up.ray.wurlod wrote:How aboutHopefully the arithmetic will perform a legal implicit CAST.Code: Select all
SELECT o_abc_uid + 0 FROM tablename...
Is there any other way other than casting?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: