ALLBASE/SQL Error Messages (Continued) [ ALLBASE/SQL Message Manual ] MPE/iX 5.5 Documentation
ALLBASE/SQL Message Manual
ALLBASE/SQL Error Messages (Continued)
1081 MESSAGE Duplicate MAXPARTITIONS clause defined. (DBERR
1081)
CAUSE The keyword MAXPARTITIONS appears more than once in
the START DBE NEW or START DBE NEWLOG clause.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1082 MESSAGE AUDIT LOG specified multiple times. (DBERR 1082)
CAUSE You specified the AUDIT LOG clause more than once
in the START DBE NEW or START DBE NEWLOG statement.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1083 MESSAGE ARCHIVE LOG specified multiple times. (DBERR
1083)
CAUSE You specified the ARCHIVE LOG clause more than once
in the START DBE NEWLOG statement.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1084 MESSAGE Duplicate AUDIT NAME clause defined. (DBERR
1084)
CAUSE You specified the AUDIT NAME clause appears more
than once in the START DBE NEW or START DBE NEWLOG
syntax.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1085 MESSAGE AUDIT NAME too long. (DBERR 1085)
CAUSE You specified an AUDIT NAME longer than 8 bytes.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1086 MESSAGE INCREMENT size specified not in valid range.
(DBERR 1086)
CAUSE The INCREMENT size for DBEFile expansion cannot be
zero.
ACTION Make sure the INCREMENT size is within the valid
range.
----------------------------------------------------------------------------
1088 MESSAGE Duplicate AUDIT ELEMENT specified. (DBERR 1088)
CAUSE You specified an AUDIT ELEMENT more than once in
the AUDIT ELEMENTS clause of the START DBE NEW or
START DBE NEWLOG statement.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1089 MESSAGE Duplicate COMMENT PARTITION clause defined.
(DBERR 1089)
CAUSE You have more than one COMMENT PARTITION clause in
the START DBE NEW or START DBE NEWLOG statement.
ACTION Check the specified START DBE statement.
----------------------------------------------------------------------------
1090 MESSAGE Dynamic Parameters cannot be used as both the
first and the second operands in a BETWEEN
predicate. (DBERR 1090)
CAUSE You specified dynamic parameters as both the first
and the second operands in a BETWEEN predicate.
ACTION Modify your statement to not contain dynamic
parameters as both the first and second operands of
the BETWEEN predicate.
----------------------------------------------------------------------------
1091 MESSAGE TID function cannot be used as the argument of
the aggregate function. (DBERR 1091)
CAUSE You cannot use the TID function as the argument of
an aggregate function.
ACTION Check and modify the command.
----------------------------------------------------------------------------
1092 MESSAGE Duplicate constraint type specified. (DBERR
1092)
CAUSE You specified the same constraint type more than
once in a SET CONSTRAINTS statement.
ACTION Remove the duplicate constraint type(s) and reissue
the statement.
----------------------------------------------------------------------------
1093 MESSAGE Default timeout value out of valid range. (DBERR
1093)
CAUSE The default timeout value you specified is invalid.
ACTION Verify that the default timeout value is within the
valid range.
----------------------------------------------------------------------------
1094 MESSAGE Maximum timeout value out of valid range. (DBERR
1094)
CAUSE The maximum timeout value you specified is invalid.
ACTION Verify that the maximum timeout value is within the
valid range.
----------------------------------------------------------------------------
1095 MESSAGE Default timeout value exceeds maximum timeout
limit. (DBERR 1095)
CAUSE The default timeout value is greater than the
maximum timeout limit.
ACTION Set the default timeout to a value less than or
equal to the maximum timeout limit
or
set the maximum timeout limit to a value greater
than or equal to the default timeout value.
----------------------------------------------------------------------------
1096 MESSAGE DEFAULT TIMEOUT specified multiple times. (DBERR
1096)
CAUSE You specified the DEFAULT TIMEOUT clause more than
once in either the START DBE, START DBE NEW, or
STARTDBE NEWLOG statement.
ACTION Issue the statement again, specifying the DEFAULT
TIMEOUT clause only once.
----------------------------------------------------------------------------
1097 MESSAGE MAXIMUM TIMEOUT specified multiple times. (DBERR
1097).
CAUSE You specified the MAXIMUM TIMEOUT clause more than
once in either the START DBE, START DBE NEW, or
STARTDBE NEWLOG statement.
ACTION Issue the statement again, specifying the MAXIMUM
TIMEOUT clause only once.
----------------------------------------------------------------------------
1098 MESSAGE User timeout value out of valid range. (DBERR
1098)
CAUSE The specified user timeout is invalid.
ACTION Verify that the user timeout value is within the
valid range.
----------------------------------------------------------------------------
1099 MESSAGE GENPLAN accepts SELECT, UPDATE, and DELETE
statements only. (DBERR 1099)
CAUSE A SELECT, UPDATE, or DELETE statement is expected.
ACTION Issue GENPLAN for a statement of one of the above
types.
----------------------------------------------------------------------------
1100 MESSAGE VariableName in WHERE clause has not been defined
in the WITH clause of GENPLAN. (DBERR 1100)
CAUSE A VariableName in the WHERE clause of the statement
contained in GENPLAN has not been defined in the
WITH clause of the GENPLAN statement.
ACTION Add the VariableName with the appropriate data type
to the WITH clause of the GENPLAN statement.
----------------------------------------------------------------------------
1101 MESSAGE A language, default, or column constraint clause
is not allowed in the WITH clause of GENPLAN.
(DBERR 1101)
CAUSE A language, default, or column constraint clause
was found in the WITH clause of GENPLAN.
ACTION Remove the language, default, or column clause from
the WITH clause of GENPLAN.
----------------------------------------------------------------------------
1102 MESSAGE SQL Linearizer internal NLS error. (DBERR 1102)
CAUSE Internal error.
ACTION Record as much information as possible and contact
your HP Service Representative or Response Center.
----------------------------------------------------------------------------
1103 MESSAGE Duplicate VariableName found in the WITH clause
of GENPLAN. (DBERR 1103)
CAUSE The WITH clause of GENPLAN has a duplicate
VariableName.
ACTION Rename or remove the duplicate VariableName from
the WITH clause of GENPLAN.
----------------------------------------------------------------------------
1104 MESSAGE Duplicate RUN BLOCK clause defined. (DBERR 1104)
CAUSE You specified the RUN BLOCK clause twice in the
START DBE or START DBE NEW statement.
ACTION Issue the command again specifying the RUN BLOCK
clause once.
----------------------------------------------------------------------------
1105 MESSAGE USER not permitted in table CHECK constraint.
(DBERR 1105)
CAUSE You specified a CHECK constraint with USER.
ACTION Remove the use of USER in the CHECK constraint and
reissue the statement.
----------------------------------------------------------------------------
1106 MESSAGE CURRENT_DATE not permitted in table CHECK
constraint. (DBERR 1106)
CAUSE You specified a CHECK constraint with CURRENT_DATE.
ACTION Remove the use of CURRENT_DATE in the CHECK
constraint and reissue the statement.
----------------------------------------------------------------------------
1107 MESSAGE CURRENT_TIME not permitted in table CHECK
constraint. (DBERR 1107)
CAUSE You specified a CHECK constraint with CURRENT_TIME.
ACTION Remove the use of CURRENT_TIME in the CHECK
constraint and reissue the statement.
----------------------------------------------------------------------------
1108 MESSAGE CURRENT_DATETIME not permitted in table CHECK
constraint. (DBERR 1108)
CAUSE You specified a CHECK constraint with
CURRENT_DATETIME.
ACTION Remove the use of CURRENT_DATETIME in the CHECK
constraint and reissue the statement.
----------------------------------------------------------------------------
1109 MESSAGE ! PARTITION value must be non-zero. (DBERR 1109)
CAUSE You specified a DEFAULT, MAXPARTITIONS, or COMMENT
partition value of zero in the START DBE NEW or
START DBE NEWLOG statement.
ACTION Check the specified START DBE statement and replace
the zero in the named partition value with a
non-zero value.
----------------------------------------------------------------------------
[REV BEG]
1110 MESSAGE The label (!) is not an integer. (DBERR 1110)
CAUSE For PASCAL and FORTRAN 77 applications, labels must
be integers. A label was found that was not an
integer.
ACTION Change the label to an integer.
[REV END]
----------------------------------------------------------------------------
[REV BEG]
1111 MESSAGE The label (!) is not an identifier name. (DBERR
1111)
CAUSE For C and COBOL applications, labels must be
identifier names which start with non-numeric
characters. A label was found that started with a
numeric character.
ACTION Change the label to start with a non-numeric
character.
[REV END]
----------------------------------------------------------------------------
1120 MESSAGE Statement not allowed in stored procedure. (DBERR
1120)
CAUSE The current statement is not permitted within a
procedure.
ACTION Issue the CREATE PROCEDURE statement again,
omitting the illegal statement. Refer to the
description of the CREATE PROCEDURE statement in
the "SQL Statements" chapter of the ALLBASE/SQL
Reference Manual for a list of statements that are
not allowed in procedures.
----------------------------------------------------------------------------
1121 MESSAGE Local variable declarations must be at the
beginning of a stored procedure. (DBERR 1121)
CAUSE The DECLARE statement was not at the beginning of
the procedure.
ACTION Define local variables with DECLARE statements at
the beginning of the procedure.
----------------------------------------------------------------------------
1122 MESSAGE Return Status in the RETURN statement must be an
integer value. (DBERR 1122)
CAUSE The status value in the RETURN statement is not an
integer value.
ACTION Use an integer value for the ReturnStatus in the
RETURN statement.
----------------------------------------------------------------------------
1123 MESSAGE Indicator variables are not allowed with
parameters or local variables used in a stored
procedure statement. (DBERR 1123)
CAUSE You attempted to include an indicator variable with
a parameter declaration or with a local variable in
the CREATE PROCEDURE statement.
ACTION Rewrite your CREATE PROCEDURE statement,
eliminating indicator variables.
----------------------------------------------------------------------------
MPE/iX 5.5 Documentation