DB2-SQL PROGRAMMING LIMITS

 

    

NO OF TABLES IN FROM CLAUSE

MAXIMUM SIZE OF A SQL QUERY

MAXIMUM NO OF COLUMNS

MAXIMUM NO OF VOLUMES IN STORAGE GROUP

MAXIMUM SIZE OF DBRM      

MAXIMUM NO OF COLUMNS IN AN INDEX

MAXIMUM NO OF SUBQUERIES

MAXIMUM NO OF ELEMENTS IN SELECT

MAXIMUM NO OF PREDICATES IN WHERE OR HAVING

LARGEST TABLE SIZE

MAXIMUM NO OF DATABASES

LENGTH OF TABLE NAME, COLLECTION, INDEX, COLUMN & SYNONYM

LENGTH OF DATABASE NAME, PLAN, PACKAGE, STOGROUP & TRIGGER NAME

SMALLINT RANGE 

INTEGER RANGE

FLOAT RANGE

DECIMAL RANGE

DATE RANGE

TIME RANGE

                                   

15

32 KB

750

133

131 KB

15

14

750

750

16 TB

65279

18 B

8 B

+/-32,767

+/-2147483647

+/- 7.2*10(75)

1 - 10(31)

0001-01-01 to 9999-12-31

00.00.00 to 24.00.00

 

    

   One today, is worth two tomorrow