SAP SQL Anywhere

Question

Guys,

I'm having trouble trying to output the the table to a file:

IF (NumRows > 0 ) THEN
MESSAGE 'We have not had backups for more than 2 hours! Affected volumes are: ';
SELECT * FROM LatestBackup WHERE datediff (minute, ExecTime, getdate()) < 130;
OUTPUT TO '/dir1/dir2/textfile FORMAT TEXT;
END IF;

Such a code returns syntax error. While I'm executing SELECT and OUTPUT only, it works perfectly fine. Any ideas? Can't I use OUTPUT in a batch?

Thank you.

Accepted Answer

5

OUTPUT is a command which can only be used in the tool dbisql, but you can use the UNLOAD command instead.

permanent link

answered 17 Apr '14, 06:27

Martin
9.0k●130●166●257
accept rate: 14%

Yeah. Just found out the UNLOAD statement. Thank you!

(17 Apr '14, 06:28) Maciej

Replies hidden

2

FWIW, as you have used the "output" tag yourself, that tag lists a whole bunch of FAQs and explanations to that topic:

http://sqlanywhere-forum.sap.com/tags/output/

(17 Apr '14, 06:53) Volker Barth

flat view

SAP SQL Anywhere

Output to File

Follow this question

Related questions