I am trying to write a Stored Procedure in ASA9 with an
Is this possible?
asked 17 Nov '16, 12:05
The OUTPUT statement is a dbisql[c] statement and is not known by the server, and therefore you cannot use it in a stored procedure. There are two alternatives that you can use in a stored procedure:
Check out the documentation for more details - the links that I have provided are for SQLA 17 but the same will work on v9 (except for UNLOAD TO CLIENT FILE - this feature does not exist in v9).
In more recent versions you can also use: