I created a sproc with 3 input parameters and one output parameter.
I want to test it in the "Run SQL Scripts" app of Navigator.
I wrote this code:
DECLARE RTNDATE CHAR(10) DEFAULT '';
CALL MANLIB.MANDATCL('ADD','20060101','1',RTNDATE)
SELECT MYVAR;
The problem is the first line, where I declare my output parameter.
When I try to run it, the SQL error is:
DECLARE RTNDATE CHAR(10) DEFAULT ''SQL State: 42601
Vendor Code: -199
Message: [SQL0199] Keyword CHAR not expected. Valid tokens: DYNAMIC
SENSITIVE ASENSITIVE INSENSITIVE. Cause . . . . . : The keyword CHAR
was not expected here. A syntax error was detected at keyword CHAR.
The partial list of valid tokens is DYNAMIC SENSITIVE ASENSITIVE
INSENSITIVE. This list assumes that the statement is correct up to the
unexpected keyword. The error may be earlier in the statement but the
syntax of the statement seems to be valid up to this point. Recovery .
.. . : Examine the SQL statement in the area of the specified keyword.
A colon or SQL delimiter may be missing. SQL requires reserved words
to be delimited when they are used as a name. Correct the SQL statement
and try the request again.
Processing ended because the highlighted statement did not complete
successfully
--
Texeme Construct