db2 V8µÄÓйØSQL limits

The following tables describe certain SQL
limits. Adhering to the most restrictive case can help the programmer
design application programs that are easily portable.
Table 7. Identifier Length Limits
Description
Limit in Bytes
Longest authorization
name (can only be single-byte characters)
30
Longest
constraint name
18
Longest correlation name
128
Longest condition name
64
Longest
cursor name
18
Longest unqualified column name (nickname)
128
Longest data source index name
128
Longest
data source name
128
Longest data source table name (remote-table-name
)
128
Longest
external program name
8
Longest host identifiera
255
Longest identifier of a data source user (remote-authorization-name
)
30
Longest label name
64
Longest method name
18
Longest parameter nameb
128
Longest
password to access a data source
32
Longest savepoint name
128
Longest schema namec
30
Longest server
(database alias) name
8
Longest SQL variable name
64
Longest
statement name
18
Longest transform. group name
18
Longest unqualified column name
30
Longest
unqualified package name
8
Longest unqualified user-defined type,
user-defined function, user-defined method, buffer pool, table space,
database partition group, trigger, index, or index specification name
18
Longest unqualified table name, view name, stored procedure
name, sequence name, nickname, or alias
128
Longest
wrapper name
128
Notes:
a
Individual
host language compilers may have a more restrictive limit on variable
names.
b
Parameter names in an SQL procedure are
limited to 64 bytes.
c
The schema name for a
user-defined type is limited to 8 bytes.
Table 8. Numeric Limits
Description
Limit
Smallest INTEGER value
-2 147 483 648
Largest INTEGER value
+2 147 483 647
Smallest BIGINT value
-9 223 372 036 854 775 808
Largest BIGINT value
+9 223 372 036 85