SQL/MX Programming Manual for Java

SQLJ Error Messages
HP NonStop SQL/MX Programming Manual for Java—523726-003
D-32
Semantic Analysis (0201-000100—0201-022306)
Recovery. Declare the iterator variable with a valid iterator type and resubmit. For
details, see Iterators and Result Sets on page 3-48. For the syntax of a FETCH
statement, see the SQL/MX Reference Manual.
0201-008100
Cause. You specified an INTO clause in an SQL statement other than SELECT and
FETCH, which is disallowed.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Correct the INTO clause and resubmit. For information about SQL syntax,
see the SQL/MX Reference Manual.
0201-008200
Cause. The SQLJ translator could not categorize the SQL statement.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Report the entire error message to your service provider.
0201-008300
Cause. The SQL checker could not categorize the SQL statement.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Report the entire error message to your service provider.
0201-008400
Cause. The SQL checker determined that the mode of host variable #num is
UNKNOWN, so SQLJ assumes the IN mode.
Effect. The SQLJ translator fails during semantic analysis.
Recovery. Resubmit with a host variable that has the proper mode associated with it.
For details, see Host Expression on page A-6.
[0201-008100] INTO-lists may only occur in SELECT and FETCH
statements.
[0201-008200] SQL statement could not be categorized.
[0201-008300] SQL checker did not categorize this statement.
[0201-008400] SQL checking did not assign mode for host
variable #
num - assuming IN.