HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Error Messages (Cont.)
[REV BEG]
2530 MESSAGE Query was aborted externally. (DBERR 2530)
CAUSE The query was aborted by an external process.
ACTION Resume the query at an appropriate time.
[REV END]
----------------------------------------------------------------------------
2600 MESSAGE Integer overflow on operation !. (DBERR 2600)
CAUSE The result of an integer arithmetic operation
within an expression was too big for the hardware
to accommodate.
ACTION Try to modify your expression so that divisions
occur before multiplications or break the
expression into multiple expressions.
----------------------------------------------------------------------------
2601 MESSAGE Integer divide by zero. (DBERR 2601)
CAUSE The result of an arithmetic operation within an
expression caused an integer value to be divided by
zero.
ACTION Look at your data to find where this error occurred
and make any necessary changes to your expression.
----------------------------------------------------------------------------
2602 MESSAGE Extended precision overflow on operation !.
(DBERR 2602)
CAUSE The result of a float arithmetic operation within
an expression was too big for the hardware to
accommodate.
ACTION Try to modify your expression so that divisions
occur before multiplications or break the
expression into multiple expressions.
----------------------------------------------------------------------------
2603 MESSAGE Extended precision underflow on operation !.
(DBERR 2603)
CAUSE The result of a float arithmetic operation within
an expression was too small for the hardware to
accommodate.
ACTION Try to modify your expression so that
multiplications occur before divisions or break the
expression into multiple expressions.
----------------------------------------------------------------------------
2604 MESSAGE Extended precision divide by zero. (DBERR 2604)
CAUSE The result of an arithmetic operation within an
expression caused an extended precision value to be
divided by zero.
ACTION Look at your data to find where this error occurred
and make any necessary changes.
----------------------------------------------------------------------------
2605 MESSAGE Packed decimal overflow on operation !. (DBERR
2605)
CAUSE The result of an intermediate decimal operation was
too big for the hardware to accommodate.
ACTION Try to modify your expression so that divisions
occur before multiplications or break the
expression into multiple expressions.
----------------------------------------------------------------------------
2606 MESSAGE Invalid decimal digit in operation !. (DBERR
2606)
CAUSE The decimal number you included through the host
variable in a COBOL program was not valid.
ACTION Correct the decimal so that it is within the range
of 0 through 9 and contains either a + or - sign.
----------------------------------------------------------------------------
2607 MESSAGE Packed decimal divide by zero. (DBERR 2607)
CAUSE The result of an arithmetic operation within an
expression caused a packed decimal value to be
divided by zero.
ACTION Look at your data to find where this error occurred
and make any necessary changes.
----------------------------------------------------------------------------
2609 MESSAGE Incompatible data types ! and ! in expression.
(DBERR 2609)
CAUSE You attempted to mix numeric and character data
types in an expression in the select list, the
WHERE clause, or the SET clause.
ACTION Issue the command again, specifying either numeric
or character data only.
----------------------------------------------------------------------------
2610 MESSAGE Operator ! invalid for data type !. (DBERR 2610)
CAUSE You attempted to perform an arithmetic operation on
char or varchar data, or attempted the LIKE
predicate on numeric data.
ACTION Issue the command again using only appropriate
operators on data types.
----------------------------------------------------------------------------
2615 MESSAGE Datetime value contains a field greater than
valid range allowed. (DBERR 2615)
CAUSE You tried to insert a datetime value which was not
valid.
ACTION Verify that all fields of all datetime literals are
within the valid range.
----------------------------------------------------------------------------
2616 MESSAGE Datetime value contains a field less than valid
range allowed. (DBERR 2616)
CAUSE You tried to insert a datetime value which was not
valid.
ACTION Verify that all fields of all datetime literals are
within the valid range.
----------------------------------------------------------------------------
2617 MESSAGE Datetime data value does not match default format
specification. (DBERR 2617)
CAUSE You tried to insert a datetime value which did not
meet the default specification criteria of
"YYYY-MM-DD HH:MI:SS.FFF."
ACTION Verify that all fields of all datetime literals
match the default format specification.
----------------------------------------------------------------------------
2618 MESSAGE ALLBASE/SQL internal error in datetime conversion
routine. (DBERR 2618)
CAUSE ALLBASE/SQL internal software problem.
ACTION Contact your HP Service Representative or Response
Center.
----------------------------------------------------------------------------
2619 MESSAGE Invalid date entered, February 29th invalid for
non-leap year. (DBERR 2619)
CAUSE You tried to insert a datetime value which was not
valid.
ACTION Enter the correct date.
----------------------------------------------------------------------------
2620 MESSAGE Result of DATE/TIME arithmetic exceeds maximum
value allowed. (DBERR 2620)
CAUSE The arithmetic produced a value greater than the
maximum allowed.
ACTION Verify that the requested arithmetic should produce
a result which exceeds maximum values specified.
----------------------------------------------------------------------------
2621 MESSAGE Result of DATE/TIME arithmetic less than minimum
value allowed. (DBERR 2621)
CAUSE The arithmetic produced a value less than the
minimum allowed.
ACTION Verify that the requested arithmetic should produce
a result which is less than the minimum values
specified.
----------------------------------------------------------------------------
2622 MESSAGE Size of datetime literal less than valid default
size. (DBERR 2622)
CAUSE You tried to insert a datetime value of incorrect
length.
ACTION Verify that all datetime literals in the query are
of the correct size.
----------------------------------------------------------------------------
2623 MESSAGE Date value contains a field greater than valid
range allowed. (DBERR 2623)
CAUSE You tried to insert a date value which was not
valid.
ACTION Verify that all fields of all date literals are
within the valid range.
----------------------------------------------------------------------------
2624 MESSAGE Date value contains a field less than valid range
allowed. (DBERR 2624)
CAUSE You tried to insert a date value which was not
valid.
ACTION Verify that all fields of all date literals are
within the valid range.
----------------------------------------------------------------------------
2625 MESSAGE Date data value does not match default format
specification. (DBERR 2625)
CAUSE You tried to insert a date value which did not meet
the default specification criteria.
ACTION Verify that all datetime literals in the query are
specified in the default specification
"YYYY-MM-DD."
----------------------------------------------------------------------------
2626 MESSAGE Size of date literal less than valid default
size. (DBERR 2626)
CAUSE You tried to insert a date value of incorrect
length.
ACTION Verify that all date literals in the query are of
the correct size.
----------------------------------------------------------------------------
2627 MESSAGE Time value contains a field greater than valid
range allowed. (DBERR 2627)
CAUSE You tried to insert a time value which was not
valid.
ACTION Verify that all fields of all time literals are
within the valid range.
----------------------------------------------------------------------------
2628 MESSAGE Time value contains a field less than valid range
allowed. (DBERR 2628)
CAUSE You tried to insert a time value which was not
valid.
ACTION Verify that all fields of all time literals are
within the valid range.
----------------------------------------------------------------------------
2629 MESSAGE Time data value does not match default format
specification. (DBERR 2629)
CAUSE You tried to insert a time value which did not meet
the default specification "HH:MI:SS."
ACTION Verify that all time literals match the default
format specification.
----------------------------------------------------------------------------
2630 MESSAGE Size of time literal less than valid default
size. (DBERR 2630)
CAUSE You tried to insert a time value of incorrect
length.
ACTION Verify that all time literals in the query are of
the correct size.
----------------------------------------------------------------------------
2631 MESSAGE Interval value contains a field greater than
valid range allowed. (DBERR 2631)
CAUSE You tried to insert an interval value which was not
valid.
ACTION Verify that all fields of all interval literals are
within the valid range.
----------------------------------------------------------------------------
2632 MESSAGE Interval value contains a field less than valid
range allowed. (DBERR 2632)
CAUSE You tried to insert an interval value which was not
valid.
ACTION Verify that all fields of all interval literals are
within the valid range.
----------------------------------------------------------------------------
2633 MESSAGE Interval data value does not match default format
specification. (DBERR 2633)
CAUSE You tried to insert an interval value which did not
meet the default specification criteria.
ACTION Verify that all interval literals in the query are
specified in the default specification "DDDDDDD
HH:MI:SS.FFF" where "DDDDDDD" can be 1 to 7 digits.
----------------------------------------------------------------------------
2634 MESSAGE Size of interval literal less than valid default
size. (DBERR 2634)
CAUSE You tried to insert an interval value of incorrect
length.
ACTION Verify that all interval literals in the query are
of the correct size.
----------------------------------------------------------------------------
2635 MESSAGE Real precision overflow on operation !. (DBERR
2635)
CAUSE The result of a real arithmetic operation within an
expression was too big for the hardware to
accommodate.
ACTION Try to modify your expression to convert the real
values in it to floats or to have a target host
variable of type FLOAT.
----------------------------------------------------------------------------
2636 MESSAGE Real precision underflow on operation !. (DBERR
2636)
CAUSE The result of a real arithmetic operation within an
expression was too small for the hardware to
accommodate.
ACTION Try to modify your expression to convert the real
values in it to floats or to have a target host
variable of type FLOAT.
----------------------------------------------------------------------------
2637 MESSAGE Format specification exceeds maximum length (!
bytes). (DBERR 2637)
CAUSE You specified a date/time format length which
exceeds the maximum length of 72 bytes.
ACTION Issue the command again with the length less than
72 bytes.
----------------------------------------------------------------------------
2638 MESSAGE End of format specification detected before
parsing end of datetime literal. (DBERR 2638)
CAUSE Datetime literal does not match format
specification given. Extra characters exist in
datetime literal after parsing end of format
specification.
ACTION Ensure the compatibility between the format
specification and datetime literal specified in the
datetime input function.
----------------------------------------------------------------------------