Re: Stored procedure + output to
>=20
> I'm trying to write a simple stored procedure with the "OUTPUT to =
filename"
> statement but I keep on getting syntax errors. The syntax manual =
suggests=20
> that I should be able to use OUTPUT to but how.
>=20
> Here's an example of what I'm trying to do
>=20
> CREATE PROCEDURE GET_BAL
> OUTPUT TO /home/dmc
> SELECT BALANCES FROM BTR_BALANCES;> END PROCEDURE
>=20
> I know I could do the same by selecting into a temp table and doing an =
unload
> but I'd still like to know if OUTPUT to works in stored procedures
>=20
>=20
> david mc
>=20
Dave,
Check "CREATE PROCEDURE" in the Syntax manual. Output is one the SQL =
statements
that can't be used in stored procs.
Cheers,
Richard.
----------------------------------------------------------------- =20
| _ =AF\\ | Richard Thomas |
| \\ 0_ | r.thomas@csl.gov.uk |
| \\ / | |
| oo/ | "20 Regal and a four-pack, |
| / \\ | I guess I'm set for the night" |
| \\_/ | - "TV Tan" The Wildhearts |
-----------------------------------------------------------------