Represents a signed, binary integer value from -2,147,483,648 to 2,147,483,647.
Syntax
{ INTEGER | INT } [ attributes [...] ]
- attributes
- Appropriate data type attributes, column storage attributes, or column constraint attributes.
Storage
INTEGER values are stored as four bytes with the least significant byte first.
External Representation of INTEGER
The following table lists the client representations for the Teradata INTEGER data type.
Determining the application definitions and client data types is the responsibility of the application programmer.
| Client CPU Architecture | Client Representation |
|---|---|
| IBM mainframe | Four byte 32-bit signed 2’s complement binary number, most significant byte first. |
|
Four byte 32-bit signed 2’s complement binary number, most significant byte first. |
| Intel | Two byte 16-bit signed 2’s complement binary number, least significant byte first. |
Format
For information on the default display format, see Data Type Default Formats.
Example: INTEGER Data Type
In the following table definition, column TelNo is an INTEGER data type:
CREATE TABLE Contact (Id CHAR(9) ,LastName CHAR(26) ,TelNo INTEGER);