SAP SQL Anywhere

Question

I'm trying to output a file to a shared folder, I can make the output but I can't run it on a event/Stored Procedure.

The code snippet that I have to the output is this:

BEGIN 
    select * from table1; output to 'c:\\teste.txt' format text with COLUMN names
END

But when I include this in a event, the sybase gives me this error.

[Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'output' on line 2 SQLCODE: -131 SQLSTATE: 42000 SQL Statement: ALTER EVENT "dba"."Export" HANDLER BEGIN select * from table1; output to 'c:\teste.txt' format text with format text with COLUMN names END

I am using Sybase Central with sql anywhere 12

Answer 1

2

The OUTPUT statement is a client side dbisql[c] statement and is not understood by the database server. Have a look at the UNLOAD statement.

Example:

UNLOAD 
SELECT * from table1
    TO 'c:\\teste.txt'
FORMAT text;

permanent link

answered 13 May '15, 12:10

Mark Culp
24.8k●10●139●296
accept rate: 41%

edited 13 May '15, 12:13

flat view

Answer 2

1	The OUTPUT statement is implemented by dbisql only. For an Event Handler to do something similar, it would need to use an UNLOAD. V12 and higher versions can UNLOAD from a query. permanent link answered 13 May '15, 12:09 Nick Elson S... 7.3k●35●107 accept rate: 32% flat view

SAP SQL Anywhere

Export file using Sybase Event

Follow this question

Related questions