HP 3000 Manuals HP 3000 Manuals
Chapter 3 ALLBASE/SQL Error Messages
ALLBASE/SQL Error Messages
1 MESSAGE Command buffer currently empty. (DBERR 1)
CAUSE You issued a RECALL [CURRENT], CHANGE, or START
command before any commands had been stored in the
command buffer.
ACTION Use the HOLD, RECALL FILE, or RECALL HISTORY
command to put information into the command buffer.
----------------------------------------------------------------------------
2 MESSAGE Problem with large command. Maximum length is !.
(DBERR 2)
CAUSE New string replacement on CHANGE command caused an
overflow of the command buffer
or
the storage file could not be opened when trying to
store the large command.
ACTION Modify the new string so that the length of the
string in the command buffer is less than or equal
to 2048 bytes
or
you may be out of disk space. Contact your system
administrator.
----------------------------------------------------------------------------
3 MESSAGE '!' not found. (DBERR 3)
CAUSE The search pattern you gave in the ISQL CHANGE
command was not found in the command buffer.
ACTION Check your spelling and issue the CHANGE command
again, specifying a valid search pattern.
----------------------------------------------------------------------------
4 MESSAGE The requested editor could not be scheduled.
(DBERR 4)
CAUSE The editor you specified in the EDITOR option of
the SET command does not exist.
ACTION Check your spelling and issue the SET command
again, specifying the correct name for the editor
requested. If you still receive this message,
contact your system administrator.
----------------------------------------------------------------------------
5 MESSAGE Number of copies must be in the range 1..20.
(DBERR 5)
CAUSE The number of copies you specified in the browse
PRINT option must be in the range of 1 to 20.
ACTION Issue the PRINT command again, specifying a value
from 1 through 20.
----------------------------------------------------------------------------
6 MESSAGE Error when using FCOPY. Code = !. Copies
printed is !. (DBERR 6)
CAUSE FCOPY is used by ISQL when the PRINT option is
specified. An error has occurred and an FCOPY
error code has been returned.
ACTION Refer to the FCOPY Reference Manual for meaning and
action.
----------------------------------------------------------------------------
7 MESSAGE Error erasing file '!'. (DBERR 7)
CAUSE You do not have the required permission to delete
the specified file.
ACTION Check your spelling and issue the command again.
If you still receive this message, no action is
necessary; you cannot erase the specified file.
----------------------------------------------------------------------------
8 MESSAGE No help for command '!'. (DBERR 8)
CAUSE The command name you entered does not exist or was
entered incorrectly.
ACTION Issue the HELP command again, specifying a valid
command name. Enter HELP @ to obtain a list of the
ISQL and SQL commands.
----------------------------------------------------------------------------
11 MESSAGE Column name list must be terminated by ')'.
(DBERR 11)
CAUSE The right parenthesis was missing after the last
column name specified in the INPUT command.
ACTION Issue the command again, with column names enclosed
in parentheses.
----------------------------------------------------------------------------
12 MESSAGE Column names must be enclosed in parentheses.
(DBERR 12)
CAUSE The list of column names in the INPUT command was
not surrounded by parentheses.
ACTION Issue the command again, with column names enclosed
in parentheses.
----------------------------------------------------------------------------
13 MESSAGE ! not a column name in table !. (DBERR 13)
CAUSE The column you specified in the LOAD EXTERNAL
command does not exist in the table specified.
ACTION Use the INFO command to check which columns are in
the specified table.
----------------------------------------------------------------------------
14 MESSAGE '!' is not acceptable as a name for a stored
command. (DBERR 14)
CAUSE The name you specified for a command file did not
conform to operating system specifications. The
command was not stored.
ACTION Refer to the MPE/iX General User's Reference Manual
for file naming conventions.
----------------------------------------------------------------------------
15 MESSAGE '!' is not acceptable as a file name. (DBERR 15)
CAUSE The name you specified as a file name did not
conform to operating system specifications.
ACTION Refer to the MPE/iX General User's Reference Manual
for file naming conventions.
----------------------------------------------------------------------------
17 MESSAGE '!' cannot be found. (DBERR 17)
CAUSE The file name you specified does not exist or was
entered incorrectly.
ACTION Check your spelling. Use the MPE/iX LISTF command
to verify the existence of the specified file.
----------------------------------------------------------------------------
18 MESSAGE Error opening file '!'. (DBERR 18)
CAUSE The file you specified is currently being accessed.
ACTION Wait until a later time to access the file.
----------------------------------------------------------------------------
19 MESSAGE Valid options are F[ILE], S[ET], H[ISTORY],
I[NSTALL]. (DBERR 19)
CAUSE The option you specified in the LIST command is not
a valid option.
ACTION Issue the command again, specifying a valid option.
Refer to the ISQL Reference Manual for ALLBASE/SQL
and IMAGE/SQL for additional information on the
LIST command.
----------------------------------------------------------------------------
20 MESSAGE Valid options are F[ILE], C[URRENT], H[ISTORY].
(DBERR 20)
CAUSE The option you entered for the RECALL command is
not a valid option.
ACTION Issue the command again, specifying a valid option.
Refer to the ISQL Reference Manual for ALLBASE/SQL
and IMAGE/SQL for additional information on the
RECALL command.
----------------------------------------------------------------------------
21 MESSAGE Cannot continue with INPUT command. (DBERR 21)
CAUSE Another error caused the INPUT command to be
discontinued. An additional error message will be
returned.
ACTION Refer to the cause and action of the additional
error.
----------------------------------------------------------------------------
27 MESSAGE No column selected from table !. (DBERR 27)
CAUSE You did not specify a column name in the LOAD
command.
ACTION Issue the LOAD command again, specifying a column
name.
----------------------------------------------------------------------------
28 MESSAGE History number must be in the range 1..!. (DBERR
28)
CAUSE The number you specified in the LIST HISTORY or
RECALL HISTORY command was out of the acceptable
range.
ACTION Issue the command again, specifying a number from 1
through 10.
----------------------------------------------------------------------------
29 MESSAGE Valid options are Y[ES] and N[O]. (DBERR 29)
CAUSE The option you entered for the END, LOAD, STORE, or
EXIT command is not a valid option.
ACTION Issue the command again, specifying a valid option.
Refer to the ISQL Reference Manual for ALLBASE/SQL
and IMAGE/SQL for additional information on these
commands.
----------------------------------------------------------------------------
30 MESSAGE Column is beyond end of record in load file on
line #!. (DBERR 30)
CAUSE At least part of one of the specified data fields
you specified was beyond the end of the record in
the load file. The record was ignored and no data
was loaded into the table from the record.
ACTION Check the description given for the load file.
Make sure the starting location for each field is
not beyond the end of the record. Also, check that
the length specified for each field does not cause
part of the field to be beyond the end of the
record. The starting location plus the length
should be equal to or less than the record length.
----------------------------------------------------------------------------
31 MESSAGE Search pattern is beyond end of record on line
#!. (DBERR 31)
CAUSE The starting position of the search pattern you
specified was beyond the end of the record. The
record was ignored and no data was loaded into the
table from the record.
ACTION Verify the starting position of the search pattern
and issue the LOAD command again.
----------------------------------------------------------------------------
32 MESSAGE Valid options are ON and OF[F]. (DBERR 32)
CAUSE The option value you specified for the AUTOCOMMIT,
CONTINUE, or ECHO option of the SET command was not
a valid option.
ACTION Issue the command again, specifying a valid option.
Refer to the ISQL Reference Manual for ALLBASE/SQL
and IMAGE/SQL for additional information on the SET
command.
----------------------------------------------------------------------------
33 MESSAGE Invalid command. (DBERR 33)
CAUSE The command you entered while viewing the results
of a SELECT statement was not valid.
ACTION Valid commands are u[p], d[own], l[eft], r[ight],
t[op], b[ottom], pr[int], e[nd], and p[ause].
----------------------------------------------------------------------------
34 MESSAGE FETCH is not allowed in ISQL. (DBERR 34)
CAUSE You issued a FETCH statement while in ISQL.
ACTION The FETCH statement can only be used in application
programs. Refer to the ALLBASE/SQL Reference
Manual for additional information.
----------------------------------------------------------------------------
35 MESSAGE Error reading from SelectFile. (DBERR 35)
CAUSE One or more users are accessing the same output
file that you specified in the OUTPUT option of the
SET command.
ACTION Change the name of the output file using the OUTPUT
option of the SET command.
----------------------------------------------------------------------------
36 MESSAGE Problem executing such a long command. (DBERR
36)
CAUSE This is an internal error that occurs while
executing an SQL statement whose length is greater
than 1.5 megabytes.
ACTION Record as much information as possible and contact
your HP Service Representative or Response Center.
You can work around this problem by shortening the
length of your command to less than 1.5 megabytes.
----------------------------------------------------------------------------
37 MESSAGE ISQL command too long. (DBERR 37)
CAUSE The number of characters in the ISQL command
exceeded the maximum limit of 2048 bytes.
ACTION Issue the command again, within the valid limits.
----------------------------------------------------------------------------
38 MESSAGE SYSTEM command unsuccessful. Return code is !.
(DBERR 38)
CAUSE The operating system command you issued from ISQL
is valid but cannot be executed.
ACTION Refer to the MPE/iX Error Message Manual, Volume 1
for an explanation of the error code returned.
----------------------------------------------------------------------------
39 MESSAGE File '!' already exists. (DBERR 39)
CAUSE The file name you specified to RENAME a file
already exists.
ACTION If you do not want to overwrite the existing file,
reenter the RENAME command specifying a unique file
name. Otherwise, either use the ERASE command to
remove the existing file or use the RENAME command
to rename the existing file first.
----------------------------------------------------------------------------