INTEGER Data Type - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

Represents a signed, binary integer value from -2,147,483,648 to 2,147,483,647.

Syntax



attributes
Appropriate data type attributes, column storage attributes, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.

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.
  • UTS
  • RISC
  • Motorola 68000
  • WE 32000
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);