|
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 |
|
|
|
|
|
|
|
Home | Mainframe Wiki | Downloads | Programs | JCLs | Mainframe Forum