SQL/MX Programming Manual for Java

SQLJ Error Messages
HP NonStop SQL/MX Programming Manual for Java—523726-003
D-33
Semantic Analysis (0201-000100—0201-022306)
0201-008401
Cause. The SQL checker determined that the mode of the host variable name at
position #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-008500
Cause. The SQL checker determined that the mode of the host variable #num in the
stored procedure 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 Calling Stored Procedures in Java on page 3-59 and Host Expression
on page A-6.
0201-008501
Cause. The SQL checker determined that the mode of the host variable name at
position
#num in the stored procedure 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 Calling Stored Procedures in Java
on page 3-59 and Host Expression
on page A-6.
0201-008600
Cause. You did not specify an iterator variable on the left-hand side (LHS) of an
assignment clause, or you did not specify a host variable in the INTO clause of a
SELECT statement.
[0201-008401] SQL checking did not assign mode for host
variable
name (at position #num) - assuming IN.
[0201-008500] SQL checking did not assign mode for host
variable #
num.
[0201-008501] SQL checking did not assign mode for host
variable
name (at position #num).
[0201-008600] Value returned by SQL query is not assigned to
a variable.