ALLBASE/SQL Message Manual (36216-90213)

Chapter 2 43

ALLBASE/SQL Warning Messages

ACTION If this warning is accompanied by DBERR 2237, check

your spelling. Otherwise, the superﬂuous 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 ﬁrst 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

speciﬁed 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.

2085 MESSAGE Section !.! (!) being revalidated due to

obsolete execution code. (DBWARN 2085)

CAUSE Obsolete execution code is causing the speciﬁed section to

be revalidated.

ACTION No action is required.

2087 MESSAGE View !.! has been dropped. (DBWARN 2087)

CAUSE The speciﬁed view has been dropped.

ACTION No action is required if the view is no longer required.

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 ﬁred 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