Page 1 of 1
How to convert a Integer datatype to int datatype.
Posted: Fri Sep 29, 2006 2:20 pm
by laxmi_etl
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
Posted: Fri Sep 29, 2006 2:46 pm
by samsuf2002
that doesnt make any difference i beleive .
Posted: Fri Sep 29, 2006 3:15 pm
by meena
Hi
No need of doing any conversion, int stands for integer.
Posted: Fri Sep 29, 2006 4:07 pm
by ray.wurlod
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.
Posted: Fri Sep 29, 2006 5:42 pm
by laxmi_etl
This works great..
Thanks for your help.