ALLBASE/SQL Message Manual (36216-90213)

38 Chapter2
ALLBASE/SQL Warning Messages
CAUSE Result length of string concatenation exceeds the
maximum.
ACTION No action needed.
2050 MESSAGE LONG column data exceeds defined length.
Truncated. (DBWARN 2050)
CAUSE The actual long column data is longer than the defined
length. The long column data was truncated.
ACTION No action is necessary.
2051 MESSAGE LONG column data exceeds output file size.
Truncated. (DBWARN 2051)
CAUSE You tried to append to a file a long column whose length
plus the current file size exceeded the file limit. The long
column data was truncated.
ACTION No action necessary.
2052 MESSAGE Sort length of UNION may exceed maximum
allowed ! bytes.
(DBWARN 2052)
CAUSE The UNION command specifies a number of columns
whose total sort tuple length exceeds the maximum
allowable and contains a VARCHAR column.
ACTION No action is necessary as long as the length of the
VARCHAR data does not cause the maximum sort tuple
length to be exceeded. The sort tuple length is determined
using the actual data length in the VARCHAR column. If
the maximum sort tuple length is exceeded, an error will
occur when the sorting is performed.
2053 MESSAGE Sort length of ORDER BY/GROUP
BY/DISTINCT/UNION
may exceed maximum allowed ! bytes. (DBWARN
2053)
CAUSE The ORDER BY, GROUP BY, DISTINCT, or UNION
clause of the SELECT statement specifies a number of
columns whose total sort tuple length exceeds the
maximum allowable and contains a VARCHAR column.
ACTION No action is necessary as long as the length of the
VARCHAR data does not cause the maximum sort tuple
length to be exceeded. The sort tuple length is determined
using the actual data length in the VARCHAR column. If
the maximum sort tuple length is exceeded, an error will
occur when the sorting is performed. You can calculate the
maximum sort tuple length from the formula given in
Appendix A of the ALLBASE/SQL Database
Administration Guide.