ALLBASE/SQL Message Manual (36216-90213)

170 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
in Pascal or C programs, check the value you specified for
data types in the dynamic format nodes of SQLDA.
2423 MESSAGE Number of Selects in command exceeds maximum
!. (DBERR 2423)
CAUSE The maximum number of Selects in a command has been
exceeded.
ACTION Issue the command again, specifying the maximum
number or fewer.
2424 MESSAGE SelectList counts are not equal in UNION
command. (DBERR 2424)
CAUSE The number of columns in the individual select lists in the
UNION command are not the same.
ACTION Issue the command again with an equal number of
columns in the select lists.
2425 MESSAGE UNION operation disallowed within a Nested
Query. (DBERR 2425)
CAUSE You tried to include a UNION operation in a nested query.
ACTION UNION of two nested queries is allowed but UNION
cannot be within a nested query.
2426 MESSAGE Tuple size exceeds maximum for UNION command
! bytes. (DBERR 2426)
CAUSE Your select list size is greater than the maximum
currently allowed for a UNION command.
ACTION Re-issue the command with a valid tuple size.
2428 MESSAGE Sort length of UNION exceeds maximum allowed
! bytes. (DBERR 2428)
CAUSE The UNION command specifies a number of columns
whose total sort tuple length exceeds the maximum
allowable.
ACTION Issue the command again, specifying no more than the
maximum sort tuple length. Refer to the
ALLBASE/SQL
Reference Manual
for additional information on the
SELECT statement.
2429 MESSAGE Sort length of ORDER BY/GROUP
BY/DISTINCT/UNION exceeds maximum
allowed ! bytes. (DBERR 2429)
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.
ACTION Issue the command again, specifying no more than the