Ansicht
Dokumentation

Quantity limitations in SQL array operations
Tip-No.: 1171 ( INFO1171 )

Short text

Quantity limitations in SQL array operations
Tip-No.: 1171

Symptom

Type "IN intable" array operations create a run-time error if
"intable" has more than 255 entries.

Cause

The underlying data base systems have limitations regarding the array
functionality and the total complexity and length of SQL statements.
Therefore, you cannot simply process any statement you wish, as
a corresponding decision such as dividing into several statements
(sort?) or interval search with selection (distribution of key words,
table size?) cannot be performed automatically without possibly
provoking massive performance problems (full table scans|).
The decision about the procedure must therefore be made explicitly
within the application that has to manage the corresponding internal
tables.

Solution

The internal table must not contain more than 255 entries.