why does Datastage not support Datatype INT8(serial8)

[ArndW]

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.

[singhald]

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

[DSguru2B]

Forget the meta plugin for now. Does DS 6.0 DRS stage support Informix. If it does, create an odbc connection to your database and try to use the DRS stage. See whether you get an error with that.

[rhale]

How about

Code: Select all

SELECT o_abc_uid + 0 FROM tablename...

Hopefully the arithmetic will perform a legal implicit CAST.

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.
Is there any other way other than casting?

[ray.wurlod]

So cast as BigInt rather than Integer. BigInt is an eight-byte signed integer.

[ray.wurlod]

So cast as BigInt rather than Integer. BigInt is an eight-byte signed integer.