SQL/MX Programming Manual for Java

SQLJ Error Messages
HP NonStop SQL/MX Programming Manual for Java—523726-003
D-42
Semantic Analysis (0201-000100—0201-022306)
Recovery. Resubmit with valid syntax for the CALL statement. For details, see the
Statement Clause on page A-5.
0201-012800
Cause. You did not specify a host variable in the INTO clause of a FETCH statement
for column #num.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Resubmit with a host variable for this column in the INTO clause of the
FETCH statement. See Retrieving Rows From a Positioned Iterator on page 3-49.
0201-012900
Cause. The named iterator declaration clause did not include column col, which was
present in the select list of the result set.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Verify that all the columns in the select list of the result set are present in
the iterator declaration clause and resubmit. For details, see Named Iterator on
page 3-51.
0201-013000
Cause. An iterator declaration clause or the INTO clause of a SELECT statement
specified more than one column value, whereas the select list for each specified only
one column value.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Check the iterator declaration clause or the INTO clause of the SELECT
statement, verify that each has the same number of column values as the select list,
and resubmit. For details, see Iterators and Result Sets on page 3-48 or Example—
SELECT INTO Statement on page 3-28 and the SQL/MX Reference Manual.
[0201-012800] No INTO variable for column #num: "col" type
[0201-012900] The result set column col type was not used by
the named cursor.
[0201-013000] Select list has only one element. Column
type
#
num is not available.