OUTPUT TO in Stored Procedure

[former_SQLA_member1694895]

Hi

I am trying to write a Stored Procedure in ASA9 with an OUTPUT TO statement. The reason I want to use OUTPUT TO instead of UNLOAD is I am wanting to export the file as HTML.

Is this possible?

[VolkerBarth]

FWIW, this question is a common one - in addition to Mark's answer, you will find more samples in this forum when searching for the "output" tag...:)

[MarkCulp]

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:

• use xp_write_file
• use UNLOAD statement

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:

• directory access proxy servers
• write_client_file built-in procedure

HTH