SQL/MX Programming Manual for Java

SQLJ Error Messages
HP NonStop SQL/MX Programming Manual for Java—523726-003
D-34
Semantic Analysis (0201-000100—0201-022306)
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Resubmit with either an iterator or host variable. For details, see the
Assignment Clause on page A-5 or the SQL/MX Reference Manual for the SELECT
INTO statement.
0201-008800
Cause. You tried to retrieve data from an SQL statement that does not return any
values. For example, you assigned a statement other than SELECT to an iterator
variable.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Resubmit with the correct SQL syntax. For details, see Iterators and Result
Sets on page 3-48.
0201-009400
Cause. You tried to call a stored procedure that returns a value. Stored procedures
cannot return values directly to the caller.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Correct the CALL statement and resubmit. For details, see Calling Stored
Procedures in Java on page 3-59.
0201-009700
Cause. The SQLJ translator could not locate a closing parenthesis ()) for the
arguments of a CALL statement. For example:
#sql { CALL samdbcat.sales.monthlyorders (:IN month };
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Resubmit with the correct CALL syntax. See Calling Stored Procedures in
Java on page 3-59.
[0201-008800] SQL statement does not return a value.
[0201-009400] A call to a stored procedure cannot return a
value.
[0201-009700] Missing closing ")" on argument list of stored
procedure/function call.