I’m not a noob to sql or anything like that. However, for the life of me I can’t seem to get variables declared inside the sql editor.
the last 2 parameters are output parameter.
The issues is that I’m getting a Keyword CHAR not expected… error under the declare.
declare @p1 char(2);
declare @p2 char(3);
etc. and nothing seems to work.
I get the following error:
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0199 - Keyword CHAR not expected. Valid tokens: DYNAMIC SENSITIVE ASENSITIVE INSENSITIVE.
All I want to do is test out my stored proc. Is that too much to ask?