HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Error Messages (Continued)
1007 MESSAGE DBEnvironment name is too long. (DBERR 1007)
CAUSE A DBEnvironment name is restricted to operating
system file naming conventions.
ACTION Refer to the MPE/iX General User's Reference Manual
for file naming conventions.
----------------------------------------------------------------------------
1008 MESSAGE Query too large. (DBERR 1008)
CAUSE The internal buffer space has been exceeded.
ACTION Break the query into smaller units and issue the
command again.
----------------------------------------------------------------------------
1009 MESSAGE Double-quoted string too long. (DBERR 1009)
CAUSE The string enclosed in double quotes was too long.
ACTION Issue the command again, specifying an object name
containing less than or equal to 20 bytes.
----------------------------------------------------------------------------
1010 MESSAGE Duplicate DBEFile0 clause defined. (DBERR 1010)
CAUSE You specified the DBEFile0 clause twice in the
START DBE NEW statement.
ACTION Issue the START DBE NEW statement again, specifying
the DBEFile0 only once. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
START DBE NEW statement.
----------------------------------------------------------------------------
1011 MESSAGE Duplicate LOG DBEFile clause defined. (DBERR
1011)
CAUSE You specified the LOG DBEFILE clause twice in the
START DBE NEW or START DBE NEWLOG statement.
ACTION Issue the command again, specifying the LOG DBEFILE
only once. Refer to the ALLBASE/SQL Reference
Manual for additional information on the START DBE
NEW and START DBE NEWLOG statements.
----------------------------------------------------------------------------
1012 MESSAGE Duplicate TRANSACTION clause defined. (DBERR
1012)
CAUSE You specified the transaction clause twice in the
START DBE NEW, START DBE, START DBE NEWLOG, or
START DBE RECOVER command.
ACTION Issue the command again, specifying the transaction
clause only once. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
specific command.
----------------------------------------------------------------------------
1013 MESSAGE Duplicate BUFFER clause defined. (DBERR 1013)
CAUSE You specified the BUFFER clause twice in the START
DBE NEW, START DBE, START DBE NEWLOG, or START DBE
RECOVER command.
ACTION Issue the command again, specifying the BUFFER
clause only once. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
specific command.
----------------------------------------------------------------------------
1014 MESSAGE Statement is not supported yet. (DBERR 1014)
CAUSE The statement you specified is not supported by
ALLBASE/SQL.
ACTION Refer to the ISQL Reference Manual for ALLBASE/SQL
and IMAGE/SQL and the ALLBASE/SQL Reference Manual
for descriptions of available commands.
----------------------------------------------------------------------------
1015 MESSAGE Invalid file name. (DBERR 1015)
CAUSE The file name you specified in the CREATE DBEFILE
or START DBE statement is too long.
ACTION Refer to the MPE/iX General User's Reference Manual
for file naming conventions.
----------------------------------------------------------------------------
1016 MESSAGE Owner id too long. (DBERR 1016)
CAUSE The owner name you specified in the command(s)
exceeds the 20-character maximum allowed for basic
names.
ACTION Issue the command again, specifying a valid owner
name. Refer to the ALLBASE/SQL Reference Manual
for naming conventions.
----------------------------------------------------------------------------
1017 MESSAGE Column number for ORDER BY must be greater than
0. (DBERR 1017)
CAUSE The column number in the ORDER BY clause was less
than or equal zero. The SELECT statement was
aborted.
ACTION Issue the SELECT statement again, specifying a
column number greater than zero.
----------------------------------------------------------------------------
1018 MESSAGE Aggregate functions not allowed in the WHERE
clause. (DBERR 1018)
CAUSE You specified an aggregate function in the WHERE
clause of the query.
ACTION Move the boolean expression using the aggregate
from the WHERE clause to the HAVING clause. Refer
to the ALLBASE/SQL Reference Manual for additional
information on aggregates.
----------------------------------------------------------------------------
1019 MESSAGE Parameters not supported yet. (DBERR 1019)
CAUSE You included a clause which is not valid for the
specified command.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the specified command.
----------------------------------------------------------------------------
1020 MESSAGE Statement not allowed in PREPARE statement.
(DBERR 1020)
CAUSE You included a statement in the PREPARE statement
which is not valid.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the PREPARE statement.
----------------------------------------------------------------------------
1021 MESSAGE Semantic error. (DBERR 1021)
CAUSE You included a clause which is not valid for the
specified statement.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the statement.
----------------------------------------------------------------------------
1022 MESSAGE Constant number is out of representable range.
(DBERR 1022)
CAUSE The constant you gave in an INSERT statement or as
part of an expression is too large.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on data data types.
----------------------------------------------------------------------------
1023 MESSAGE Duplicate tables in the FROM list. (DBERR 1023)
CAUSE You specified the same table twice in the FROM
clause of the statement. The statement was not
executed.
ACTION Issue the SELECT statement again, specifying each
table only once. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
SELECT statement.
----------------------------------------------------------------------------
1024 MESSAGE Table in expression not in FROM list. (DBERR
1024)
CAUSE You used a column from a table in an expression,
but you did not include the table in the FROM
clause.
ACTION Issue the SELECT statement again adding the
specified table to the FROM list or remove the
expression referencing the table before executing
the command again. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
SELECT statement.
----------------------------------------------------------------------------
1025 MESSAGE Number of columns does not match number of
values. (DBERR 1025)
CAUSE The number of columns you specified in an INSERT
statement does not match the number of values in
the VALUES clause.
ACTION Issue the INSERT statement again, specifying the
same value in the VALUES clause and the number of
columns specified. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
INSERT statement.
----------------------------------------------------------------------------
1026 MESSAGE Numeric value too long. (DBERR 1026)
CAUSE You attempted to enter a TID field greater than 80
digits long.
ACTION Shorten any TID field greater than 80 digits and
reissue the statement.
----------------------------------------------------------------------------
1027 MESSAGE Float precision specified not in valid range.
(DBERR 1027)
CAUSE You specified a precision outside the range 1 - 53
in a column defined to be of type FLOAT(precision).
ACTION Check your syntax and reissue the command with a
legal precision value.
----------------------------------------------------------------------------
1028 MESSAGE UPDATE not allowed with ORDER BY. (DBERR 1028)
CAUSE You specified both an UPDATE clause and an ORDER BY
clause in the DECLARE CURSOR statement.
ACTION Modify the command specifying either an UPDATE
clause or an ORDER BY clause, but not both. Refer
to the ALLBASE/SQL Reference Manual for additional
information on the DECLARE CURSOR statement.
----------------------------------------------------------------------------
1030 MESSAGE Host variables not allowed in CREATE VIEW.
(DBERR 1030)
CAUSE You specified a host variable in the SELECT
statement of the VIEW command.
ACTION Remove the host variable from the command. Refer
to the ALLBASE/SQL Reference Manual for additional
information on the CREATE VIEW command and to the
appropriate ALLBASE/SQL application programming
guide for additional information on host variables.
----------------------------------------------------------------------------
1031 MESSAGE Host variables not allowed in the command to be
PREPAREd. (DBERR 1031)
CAUSE You specified a host variable in the PREPARE
statement.
ACTION Remove the host variable and issue the command
again. Refer the ALLBASE/SQL Reference Manual for
additional information on the PREPARE statement and
to the appropriate ALLBASE/SQL application
programming guide for additional information on
host variables.
----------------------------------------------------------------------------
1032 MESSAGE Aggregate function can not be nested. (DBERR
1032)
CAUSE The aggregate function you specified in the SELECT
statement contained an aggregate function.
ACTION Issue the command again without nesting aggregate
functions. Refer to the ALLBASE/SQL Reference
Manual for additional information on the SELECT
statement.
----------------------------------------------------------------------------
1038 MESSAGE Two log and file names needed if DUAL LOG.
(DBERR 1038)
CAUSE You specified only one log name and/or file name in
the START DBE NEW or you specified a START DBE
NEWLOG statement and DUAL LOG in the LOG clause.
ACTION Issue the command again, specifying two log and
file names. Refer to the ALLBASE/SQL Reference
Manual for additional information on the START DBE
NEW and START DBE NEWLOG statements.
----------------------------------------------------------------------------
1039 MESSAGE Number of columns must match number of host
variables or dynamic parameters. (DBERR 1039)
CAUSE The number of host variables did not match the
number of columns or dynamic parameters in the
INSERT statement.
ACTION Revise your program to modify the host variable
declarations and/or the INSERT statement references
to host variables. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
INSERT statement.
----------------------------------------------------------------------------
1040 MESSAGE User id is too long. (DBERR 1040)
CAUSE The length of the DBEUserID you specified was not
within the range of 1 through 20 bytes.
ACTION Issue the command again, specifying a valid
DBEUserID.
----------------------------------------------------------------------------
1041 MESSAGE Duplicate type of authority specified. (DBERR
1041)
CAUSE You specified the same type of authority twice in
either the GRANT or REVOKE statement.
ACTION Issue the command again, specifying each type of
authority only once.
----------------------------------------------------------------------------
1042 MESSAGE Duplicate columns specified. (DBERR 1042)
CAUSE The same column was specified twice in the UPDATE
option of either the GRANT or REVOKE statement.
ACTION Issue the command again, specifying each column
only once.
----------------------------------------------------------------------------
1043 MESSAGE Column names required. (DBERR 1043)
CAUSE You did not specify column names in the CREATE VIEW
statement.
ACTION Issue the command again, specifying the column
names in parentheses. Refer to the ALLBASE/SQL
Reference Manual for additional information on the
CREATE VIEW statement.
----------------------------------------------------------------------------
1044 MESSAGE Scale must not be larger than precision. (DBERR
1044)
CAUSE The number of decimal places (scale) was greater
than the the number of digits (precision) specified
in the CREATE TABLE statement.
ACTION Issue the command again, specifying the scale as
less than or equal to precision.
----------------------------------------------------------------------------
1045 MESSAGE DUAL LOG specified multiple times. (DBERR 1045)
CAUSE The DUAL LOG option was specified more than once in
the START DBE NEW or START DBE NEWLOG statement.
ACTION Issue the command again, specifying DUAL LOG only
once. Refer to the ALLBASE/SQL Reference Manual
for additional information.
----------------------------------------------------------------------------