How to convert a Integer datatype to int datatype.

laxmi_etl · Post by **laxmi_etl** » Fri Sep 29, 2006 2:20 pm

I am reading the oracle database for the number field and its recognizing as Integer datatype. My target data type is "int" and how do i convert that datatype??

Thanks

samsuf2002 · Post by **samsuf2002** » Fri Sep 29, 2006 2:46 pm

that doesnt make any difference i beleive .

meena · Post by **meena** » Fri Sep 29, 2006 3:15 pm

Hi
No need of doing any conversion, int stands for integer.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 29, 2006 4:07 pm

Integer is four-byte integer in SQL terminology. int32 is four-byte integer in C terminology. SmallInt maps to int16 and TinyInt maps to int8.

Open any table definition in the Repository and select the Layout tab; there are three option buttons there where you can view exactly the same table definition as if it were (a) an SQL definition, (b) an Orchestrate record schema or (c) a COBOL file definition.

laxmi_etl · Post by **laxmi_etl** » Fri Sep 29, 2006 5:42 pm

This works great..

Thanks for your help.