HP 3000 Manuals HP 3000 Manuals
ALLBASE/SQL Warning Messages (Cont.)
2082 MESSAGE LABEL ! defined but not used. (DBWARN 2082)
CAUSE A procedure statement label is not referenced in
any GOTO statement in the procedure.
ACTION If this warning is accompanied by DBERR 2237, check
your spelling. Otherwise, the superfluous label
may be removed.
----------------------------------------------------------------------------
2083 MESSAGE Multiple rows returned in procedure. (DBWARN
2083)
CAUSE A non-cursor SELECT in a procedure returned
multiple rows. Only the first row of values was
returned in the local variables or parameters.
ACTION Use a cursor in procedures for any query that will
return more than one row of data.
----------------------------------------------------------------------------
2084 MESSAGE Procedure returns multiple row result set(s).
(DBWARN 2084)
CAUSE A procedure that returns multiple row result sets
was executed directly, without using a procedure
cursor.
or
A procedure that returns multiple row result sets
was specified in a CREATE RULE statement.
ACTION If retrieval of the result sets is not required by
the application, no action is required. If
retrieval is required, you must use a procedure
cursor.
or
No action is required.
----------------------------------------------------------------------------
[REV BEG]
2085 MESSAGE Section !.! (!) being revalidated due to obsolete
execution code. (DBWARN 2085)
CAUSE Obsolete execution code is causing the specified
section to be revalidated.
ACTION No action is required.
[REV END]
----------------------------------------------------------------------------
[REV BEG]
2087 MESSAGE View !.! has been dropped. (DBWARN 2087)
CAUSE The specified view has been dropped.
ACTION No action is required if the view is no longer
required.
[REV END]
----------------------------------------------------------------------------
2090 MESSAGE RAISE ERROR text truncated, length ! exceeds
maximum allowed (!). (DBWARN 2090)
CAUSE The text given to the RAISE ERROR statement
exceeded the maximum allowed length.
ACTION No action is necessary; however, the extra text is
not returned.
----------------------------------------------------------------------------
2091 MESSAGE Rule !.! fired on ! statement. (DBWARN 2091)
CAUSE The named rule fired while PRINTRULES was SET ON
due to execution of a statement of the given type
(INSERT, UPDATE, or DELETE).
ACTION No action is necessary.
----------------------------------------------------------------------------
2092 MESSAGE Rules already disabled. (DBWARN 2092)
CAUSE DISABLE RULES statement was in effect when this
DISABLE RULES statement was issued.
ACTION No action is necessary.
----------------------------------------------------------------------------
2093 MESSAGE Rules already enabled. (DBWARN 2093)
CAUSE ENABLE RULES statement was in effect when this
ENABLE RULES statement was issued.
ACTION No action is necessary.
----------------------------------------------------------------------------
2094 MESSAGE PRINTRULES already ON. (DBWARN 2094)
CAUSE SET PRINTRULES ON statement was in effect when this
SET PRINTRULES ON statement was issued.
ACTION No action is necessary.
----------------------------------------------------------------------------
2095 MESSAGE PRINTRULES already OFF. (DBWARN 2095)
CAUSE SET PRINTRULES OFF statement was in effect when
this SET PRINTRULES OFF statement was issued.
ACTION No action is necessary.
----------------------------------------------------------------------------
2096 MESSAGE ! on DBEFileSet ! already granted for !. (DBWARN
2096)
CAUSE The SECTIONSPACE/TABLESPACE authority already
granted to the user.
ACTION Delete the command.
----------------------------------------------------------------------------
2097 MESSAGE Default ! on DBEFileSet ! already set for !.
(DBWARN 2097)
CAUSE The default SECTIONSPACE/TABLESPACE authority
already set to the user.
ACTION Delete the command.
----------------------------------------------------------------------------
2098 MESSAGE ! on DBEFileSet ! is not granted for !. Default
DBEFileSet ! used. (DBWARN 2098)
CAUSE You do not have authority to store a table or
section in the specified DBEFileSet. The table or
section was added to the default DBEFileSet
instead.
ACTION No action is necessary. However, if it is not
desirable to have the table or section in the
default DBEFileSet, then the table or section can
be dropped and recreated in another DBEFileSet for
which you do have authority to store the table or
section.
----------------------------------------------------------------------------
[REV BEG]
2344 MESSAGE User ! already has INSTALL AS ! authority.
(DBWARN 2344)
CAUSE You granted INSTALL AS authority to a user who
already has the authority.
ACTION No action required.
[REV END]
----------------------------------------------------------------------------
[REV BEG]
2345 MESSAGE User ! already has general INSTALL authority.
(DBWARN 2345)
CAUSE You granted INSTALL authority to a user who already
has the authority.
ACTION No action required.
[REV END]
----------------------------------------------------------------------------
[REV BEG]
2531 MESSAGE Cursor, associated with the aborted query has
been closed. (DBWARN 2531)
CAUSE The cursor has been closed.
ACTION No action required for the closed cursor. Check
the aborted query.
[REV END]
----------------------------------------------------------------------------
2880 MESSAGE ! on DBEFileSet ! is not granted for !. Default
DBEFileSet used. (DBWARN 2880)
CAUSE The authority is not previously granted to the
user.
ACTION Grant the authority to the user.
----------------------------------------------------------------------------
3230 MESSAGE SQLCore could not use the plan as specified.
(DBWARN 3230)
CAUSE The plan you specified is not applicable to the
query.
ACTION Use GENPLAN command to verify the plan produced by
SQLCore and reset SETOPT statement if it is
necessary.
----------------------------------------------------------------------------
3231 MESSAGE The join order specified in SETOPT does not match
with the prefix join order of outer join query.
(DBWARN 3231)
CAUSE The plan you specified is not applicable to the
query.
ACTION Use GENPLAN command to verify the plan produced by
SQLCore and reset SETOPT statement if it is
necessary.
----------------------------------------------------------------------------
3232 MESSAGE Section (!) could not be found on Module !.!.
(DBWARN 3232)
CAUSE The section you specified was not found in the
Module.
ACTION Check your source file to get the correct section
number.
----------------------------------------------------------------------------
3233 MESSAGE Section (!) could not be found on Procedure !.!.
(DBWARN 3233)
CAUSE The section you specified was not found in the
Procedure.
ACTION Check your source file to get the correct section
number.
----------------------------------------------------------------------------
5000 MESSAGE ! (DBWARN 5000)
CAUSE Message number 5000 is provided for passing the
argument of a procedure's PRINT statement back to
the procedure caller.
ACTION Take whatever action is recommended by the
procedure writer.
----------------------------------------------------------------------------
8001 MESSAGE Unable to load all local response options.
(DBWARN 8001)
CAUSE One or more of the local response options was
missing from the message catalog or response
contained invalid data.
ACTION Contact your system administrator.
----------------------------------------------------------------------------
8002 MESSAGE Local response options are not unique. (DBWARN
8002)
CAUSE The local response options in the message catalog
are not unique.
ACTION Contact your system administrator.
----------------------------------------------------------------------------
8003 MESSAGE Unable to upshift multi-byte native language
string. (DBWARN 8003)
CAUSE SQLUtil was unable to upshift a character string,
probably because the string contains one or more
invalid bytes.
ACTION Issue your command again, specifying valid input.
----------------------------------------------------------------------------
8004 MESSAGE Unable to trim trailing blanks from multi-byte
native language string. (DBWARN 8004)
CAUSE SQLUtil was unable to trim trailing blanks from a
character string, probably because the string
contains one or more invalid bytes.
ACTION Issue your command again, specifying valid input.
----------------------------------------------------------------------------
8005 MESSAGE Unable to truncate multi-byte native language
string. (DBWARN 8005)
CAUSE SQLUtil was unable to truncate a character string,
probably because the string contains one or more
invalid bytes.
ACTION Issue your command again, specifying valid input.
----------------------------------------------------------------------------
8006 MESSAGE Cannot obtain user's language id. Assuming !.
(DBWARN 8006)
CAUSE Your NLUSERLANG job control word is set to a
language that is not configured, or the support
files for your language are missing.
ACTION Contact your system administrator or set again with
valid language.
----------------------------------------------------------------------------
8007 MESSAGE Local message catalog is not available. Set to !
message catalog. (DBWARN 8007)
CAUSE The message catalog file corresponding to your
language cannot be accessed, probably because it
does not exist.
ACTION Contact your system administrator.
----------------------------------------------------------------------------
8248 MESSAGE Maximum Log files exceeded, last log name
ignored. (DBWARN 8248)
CAUSE You entered more than 34 log file names when
entering the log file list for the WRAPDBE command.
ACTION Check list to see what log files can be dropped
from the list. The list must contain 34 or fewer
entries.
----------------------------------------------------------------------------
10600 MESSAGE No ending single quote: Single quote inserted.
(DBWARN 10600)
CAUSE One of your statements does not include an ending
single quote.
ACTION No action is necessary. The preprocessor inserted
the required ending single quote.
----------------------------------------------------------------------------
10601 MESSAGE No ending double quote: Double quote inserted.
(DBWARN 10601)
CAUSE An ending double quote was missing in one of your
statements.
ACTION No action is necessary. The preprocessor inserted
the required ending double quote.
----------------------------------------------------------------------------
10603 MESSAGE Cannot obtain user's language. Default language
! assumed. (DBWARN 10603)
CAUSE The job control word NLUSERLANG is set to an
unrecognized language.
ACTION Reset NLUSERLANG to a supported language.
----------------------------------------------------------------------------
10604 MESSAGE Source line longer than allowed. Source line
truncated. (DBWARN 10604)
CAUSE A source line is longer than supported.
ACTION Consult the application programming guide for
maximum allowed source line length.
----------------------------------------------------------------------------