ALLBASE/SQL Message Manual (36216-90213)

186 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
ACTION Make sure the source character string contains an
appropriate representation of a numeric value with no
extraneous characters added.
2657 MESSAGE CAST target data type too small. (DBERR 2657)
CAUSE The size in bytes of the specified target data type is too
small to hold the value being converted.
ACTION Specify a larger target data type.
2658 MESSAGE Numeric/Binary conversion must be of equal
length. (DBERR 2658)
CAUSE In converting numeric data types to BINARY, the size in
bytes of the source and target must be equal. If the target
is a VARBINARY, the maximum size of the target must be
equal or exceed the source size invalid character based on
the target data type specified. This error will be reported if
this is not true.
ACTION When converting to BINARY, make sure that the specified
size of the BINARY matches the size of the source. If
converting to VARBINARY, make sure that the specified
size of the VARBINARY is at least the size of the source.
When converting from BINARY or VARBINARY to a
numeric type, string concatenation (||) or the
SUBSTRING function can be used to make the source the
correct size for the target.
2659 MESSAGE Date/Binary conversion must be of equal
length. (DBERR 2659)
CAUSE In converting Date/Time data types to BINARY, the size in
bytes of the source and target must be equal. If the target
is a VARBINARY, the maximum size of the target must be
equal or exceed the source size invalid character based on
the target data type specified. This error will be reported if
this is not true.
ACTION When converting to BINARY, make sure that the specified
size of the BINARY matches the size of the source (16
bytes). If converting to VARBINARY, make sure that the
specified size of the VARBINARY is at least the size of the
source. When converting from BINARY or VARBINARY to
a Date/Time type, the source should be 16 bytes.
2660 MESSAGE TID/Binary conversion must be of equal
length. (DBERR 2660)
CAUSE In converting TID data types to BINARY, the size in bytes
of the source and target must be equal. If the target is a
VARBINARY, the maximum size of the target must be
equal or exceed the source size invalid character based on
the target data type specified. This error will be reported if