Home | Mainframe Wiki | Free Downloads | Sample Programs | More References | Mainframe Forum

IBMMainframes.com

Quick References for IBM Mainframe Programming

DB2 SQL PROGRAMMING LIMITS

DB2 PROGRAMMING LIMITS IN Z/OS:

  

MAXIMUM SIZE OF A SQL QUERY

2 MB

MAXIMUM NO OF COLUMNS IN AN INDEX

64

MAXIMUM NO OF VOLUME IDS IN STORAGE GROUP

133

MAXIMUM NO OF SUBQUERIES

224

MAXIMUM NO OF TABLES IN FROM CLAUSE

225

MAXIMUM NO OF BASE TABLES IN SELECT/UPDATE/INSERT CLAUSE

255

MAXIMUM NO OF COLUMNS IN A TABLE/VIEW

750

MAXIMUM NO OF ELEMENTS IN SELECT

750

MAXIMUM NO OF PREDICATES IN WHERE OR HAVING

750

MAXIMUM NO OF ROWS ALTERABLE BY INSERT/MERGE

32767

MAXIMUM SIZE OF DBRM 

131 KB

MAXIMUM SIZE OF A TABLE

128 TB

MAXIMUM NO OF DATABASES

65217

MAX LENGTH OF CHAR

255 B

MAX LENGTH OF BINARY

255 B

MAX LENGTH OF GRAPHIC

217 DBCS

MAX LENGTH OF VARCHAR

32704 B

MAX LENGTH OF VARBINARY

32704 B

MAX LENGTH OF VARGRAPHIC

16352 DBCS

MAX LENGTH OF CLOB

2GB

MAX LENGTH OF BLOG

2GB

LENGTH OF DATABASE NAME, PLAN, PACKAGE, STOGROUP & TABLE SPACE NAME

8 B

LENGTH OF NAME OF COLUMN

30 B

LENGTH OF NAME OF TABLE, ALIAS, COLLECTION, INDEX, VIEW, TRIGGER & SYNONYM

128 B

SMALLINT RANGE 

+/-32,767

INTEGER RANGE

+/-2147483647

FLOAT RANGE

+/- 7.2*1075

DECIMAL RANGE

(1-1031) to (1031-1)

DATE RANGE

0001-01-01 to 9999-12-31

TIME RANGE

00.00.00 to 24.00.00

 

 

 

Copyright 2003-2016 IBMMAINFRAMES.com

Home | Mainframe Wiki | Downloads | Programs | JCLs | Info | References | Mainframe Forum