ALLBASE/SQL Message Manual (36216-90213)
Chapter 2 37
ALLBASE/SQL Warning Messages
CAUSE A host variable character string was shorter than a
character column in the select list.
ACTION Check the string returned to see if it needs to be longer in
order to capture all necessary information from the
column. If so, modify the declaration of the datatype.
2041 MESSAGE NULL values eliminated from the argument of
an aggregate function. (DBWARN 2041)
CAUSE A NULL value occurred in a column where an aggregate
(SUM, AVG, MAX, MIN, COUNT) was evaluated, but was
dropped from the computation.
ACTION Determine whether the information wasneededfor correct
computation. If it was, set the NULL column to the needed
value. To prevent future lapses, change the column to be
NOT NULL if possible.
2042 MESSAGE ADD_MONTHS result adjusted to last day of
month. (DBWARN 2042)
CAUSE Result of ADD_MONTHS function was an invalid date,
which resulted in the day being adjusted to the last day of
the month.
ACTION No action required.
2043 MESSAGE Binary literal truncation during insert on
column !.
(DBWARN 2043)
CAUSE The binary input is longer than the column definition.
ACTION No action is necessary; however, the extra data is lost.
2044 MESSAGE DEFAULT USER is specified, corresponding
column length
should be at least 20 characters long.
(DBWARN 2044)
CAUSE You entered a column length less than 20 bytes.
ACTION No action necessary.
2045 MESSAGE DEFAULT 'literal' truncated, length ! exceeds
column
length !. (DBWARN 2045)
CAUSE You specified a default constant length which is longer
than the column length defined when the table was
created.
ACTION Define a default value whose length will not exceed the
corresponding column length.
2046 MESSAGE String concatenation result is truncated.
(DBWARN 2046)