D.2 Maximum and minimum values related to database

1

Character string data length (definition length)

CHAR

1

32,000

Bytes

2

VARCHAR

1

64,000

Bytes

3

Numeric data length

INTEGER

8

Bytes

4

SMALLINT

4

Bytes

5

DOUBLE PRECISION

8

Bytes

6

Numeric data value range

INTEGER

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

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

--

7

SMALLINT

-2,147,483,648

2,147,483,647

8

Precision of fixed-point data

DECIMAL

1

38

Digits

9

Scaling of fixed-point data

DECIMAL

0

38

Digits

10

Mantissa of floating-point numeric data

DOUBLE PRECISION

17

Digits

11

Exponent of floating-point numeric data

DOUBLE PRECISION

3

Digits

12

Date data value range

DATE

DATE'0001-01-01'

DATE'12/31/9999'

--

13

Time data value range

TIME

TIME'00:00:00.000000000000'

TIME'11:59:59 PM.999999999999'

--

14

Time stamp data value range

TIMESTAMP

TIMESTAMP'0001-01-01 00:00:00.000000000000'

TIMESTAMP'12/31/9999 11:59:59 PM.999999999999'

--

15

Time data fractional seconds precision

TIME

0

12

Digits

16

Fractional seconds precision of time stamp data

TIMESTAMP

0

12

Digits

17

Binary data length (defined length)

BINARY

1

32,000

Bytes

18

VARBINARY

1

32,000

Bytes

19

Range of values that can be specified for labeled duration (YEAR(S))

-9,998

9,998

--

20

Range of values that can be specified for labeled duration (MONTH(S))

-119,987

119,987

--

21

Range of values that can be specified for labeled duration (DAY(S))

-3,652,058

3,652,058

--

22

Range of values that can be specified for a labeled duration (HOUR(S))

-87,649,415

87,649,415

--

23

Range of values that can be specified for a labeled duration (MINUTE(S))

-5,258,964,959

5,258,964,959

--

24

Range of values that can be specified for a labeled duration (SECOND(S))

-315,537,897,599

315,537,897,599

--

25

Range of values that can be specified for a labeled duration (MILLISECOND(S))

-315,537,897,599,999

315,537,897,599,999

--

26

Range of values that can be specified for a labeled duration (MICROSECOND(S))

-315,537,897,599,999,999

315,537,897,599,999,999

--

27

Range of values that can be specified for a labeled duration (NANOSECOND(S))

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

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

--

28

Range of values that can be specified for a labeled duration (PICOSECOND(S))

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

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

--

29

Number of columns in a table

1

1,000

Columns

30

Number of indexes for a table

0

32

Indexes

31

Number of foreign keys in a table

0

255

Keys

32

Number of foreign keys that reference a primary key

0

255

Keys

33

Number of columns in a constraint

1

16

Columns

34

Number of B-tree indexed columns

1

16

Columns

35

Number of range indexed columns

1

Columns

36

Number of text indexed columns

1

Columns

37

Length of a CHARACTER type column for which a range index is defined

1

32

Bytes

38

Percentage of unused area in table pages

0

99

Percent

39

Percentage of unused area in index pages

0

99

Percent

40

Identifier length (authorization identifier, schema identifier, table identifier, index identifier, column name, correlation name, constraint name)

1

100

Bytes

41

SQL text length

1

16,000,000^#1

Bytes

42

Number of tables in an SQL statement

1

2,048

Tables

43

Number of set operations

When all are UNION

0

1,023

Operations

44

When EXCEPT or INTERSECT is included

0

63

Operations

45

Number of times FULL OUTER JOIN is specified in an SQL statement

0

63

Times

46

Number of subquery and table value constructor specifications

1

1,024

Times

47

Number of sort keys

0

64

Keys

48

Number of grouping columns

0

64

Columns

49

Number of joined tables

1

64

Tables

50

Number of row value constructor specifications inside table value constructor

1

30,000

Tables

51

Number of row value constructor element specifications inside row value constructor

1

1,000

Subqueries

52

Number of selection expressions

Number of scalar subqueries

1

1

Subqueries

53

Number of table subqueries specified in the IN predicate

1

1

Subqueries

54

Number of table subqueries specified in the EXISTS predicate

1

1,000

Subqueries

55

Number of table subqueries in a derived table

1

1,000

Subqueries

56

Number of INSERT through SELECT statements

1

1,000

Statements

57

All other

1

1,000

Expressions

58

Number of inserted columns

1

1,000

Columns

59

Number of updated columns

1

1,000

Columns

60

Number of dynamic parameters

0

1,000

Parameters

61

Number of value expressions in an IN predicate

1

30,000

Expressions

62

Maximum number of rows

0

18,446,744,073,709,551,615

Rows

63

Number of scalar operations and set functions in a value expression

0

500

Operations or functions

64

Number of scalar operations and set functions in a value expression after it is expanded

0

10,000

Operations and functions

65

Number of nesting levels in a scalar function, window function, and CASE expression

0

15

Levels

66

Number of nesting levels in a subquery

0

32

Levels

67

Number of value expressions specified in the window partition clause of a window function

0

16

Expressions

68

Number of entities of identification numbers for the RANDOMCURSOR scalar functions in the SQL statement

0

1,000

Entities

69

Number of entities of identification numbers for the RANDOMROW scalar functions in the SQL statement

0

1,000

Entities

70

Maximum row length of work table

--

262,076^#2

Bytes

71

Range of values specifiable as the maximum number of recursions of recursive queries

0

32,767

--

72

Number of DISTINCT set functions specified as set functions with different aggregated arguments in a query specification

0

64

Functions

73

Total data length of dynamic parameters in SQL statements

0

32,000,000

Bytes

74

Range of view levels of viewed tables

1

33

--