SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
6-50
Recovery. Modify and resubmit the statement.
SQL 4235
Where seq-pseudo-col is NEXTVAL or CURRVAL.
Cause. You attempted to compile a query that contains CURRVAL or NEXTVAL in an
aggregate function, HAVING clause, CASE Expression or procedure parameter list.
Effect. The statement fails to execute.
Recovery. Modify and resubmit the statement.
SQL 4301
Where routine-name is the routine name.
Cause. You have used a routine that returns a result set in the trigger action.
Effect. The operation fails and the trigger is not created.
Recovery. Use the routines, which do not return result sets in the trigger action.
SQL 4302
Cause. In the SQL/MX statement being compiled, a stored procedure invocation
contains an incorrect number of parameters.
Effect. The SQL/MX statement is not compiled.
Recovery. Correct the SQL/MX statement and retry the compilation.
4234 seq-pseudo-col cannot be used in aggregate function,
union, where, having clause, case expression or procedure
parameter list.
4301 Use of routine routine-name was not valid - return of
result sets is not allowed within a trigger
4302 Procedure procedure-name expects value1 parameters but
was called with value2 parameters.