Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    2

    Unanswered: Export file using Sybase Event

    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:

    Code:
    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

  2. #2
    Join Date
    May 2015
    Posts
    2

    Export file using Sybase Event

    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •