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
How to convert a Integer datatype to int datatype.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.