> Explicit cursor can be declared as:
>
> DECLARE
> ...
> curname CURSOR [(argname type [, ...])]
> IS <select_stmt>;
In esql you would have FOR instead of IS.
DECLARE curname CURSOR ... FOR ....
Thus the question, where is the syntax from ?
There seems to be a standard for "the" SQL stored procedure language:
"Persistent Stored Module definition of the ANSI SQL99 standard" (quote from DB/2)
Anybody know this ?
Andreas