BINARY

32,760 bytes

1 byte

CHARACTER

32,760 bytes

1 byte

DATE

'9999-12-31'

'0001-01-01'

DECIMAL

10&sub3.&sub1.-1

-(10&sub3.&sub1.-1)

Positive

DOUBLE

PRECISION

Approximately 7.2E+75

Approximately 5.4E-79

Negative

DOUBLE

PRECISION

Approximately -5.4E-79

Approximately -7.2E+75

Positive FLOAT

Approximately 7.2E+75

Approximately 5.4E-79

Negative FLOAT

Approximately -5.4E-79

Approximately -7.2E+75

GRAPHIC

16,380 double-byte characters

1 double-byte character

INTEGER

2,147,483,647

-2,147,483,648

LONGINT

9,223,372,036,854,775,807

-9,223,372,036,854,775,808

NUMERIC

10&sub3.&sub1.-1

-(10&sub3.&sub1.-1)

Positive REAL

Approximately 7.2E+75

Approximately 5.4E-79

Negative REAL

Approximately -5.4E-79

Approximately -7.2E+75

SMALLINT

32,767

-32,768

TIME

'23:59:59'

'00:00:00'

TIMESTAMP

'9999-12-31.23.59.59.999999'

'0001-01-01.00.00.00.000000'

UNSIGNED DECIMAL

10&sub3.&sub1.-1

0

UNSIGNED NUMERIC

10&sub3.&sub1.-1

0

VARCHAR

32,758 bytes

1 byte

VARGRAPHIC

16,379 double-byte characters

1 double-byte character

Note: A TIME value of 24.00.00 is accepted and treated as 00.00.00.

Note: The largest possible data type size is theoretical. The aggregate column size of a table cannot exceed the page size less bytes reserved for control information.

For more information, see the CA IDMS Database Administration Guide.