| Product: | DBConnectivity Products for IBM Db2 for i (HiT ODBC/400, HiT OLEDB/400, Ritmo/i, HiT JDBC/400) |
| Version: | All |
| ID: | 1011 |
| Summary: | SQL0490 - "Numeric value 61504 not valid" on creating stored procedure with SET RESULT SETS 0 |
When trying to create a stored procedure, the following errors may occur:
SQL0490 - "Numeric value 61504 not valid"
GENERAL or GENERAL WITH NULLS missing at the end of the statement
If you include "SET RESULT SETS 0" in your call to create the stored procedure, remove it and replace it with GENERAL. It seems that the value 0 in SET RESULT SET is an invalid value.
The query should look as follows:
create procedure A044103.callit ( IN PARAM1 CHAR(30), INOUT PARAM2 CHAR(1))
EXTERNAL NAME A044103.CHGPWDVB LANGUAGE COBOL GENERAL
Alternatively, try to run the query using "interactive SQL" in a terminal session.