Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    7

    Unanswered: Spool equivalent in Sybase

    Hi,

    I want to redirct output of my query into a csv file. Is there any spool equivalent in Sybase to do that? I am using ISQL client on windows machine.

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Quote Originally Posted by hamidvirani
    Hi,

    I want to redirct output of my query into a csv file. Is there any spool equivalent in Sybase to do that? I am using ISQL client on windows machine.

    Thanks.
    Hmm. Dont think theres any spool equivalent. What you could do is.

    Create a file with the sql, say my.sql

    Run the following

    isql -Uuser -Sserver -Ppassword -imy.sql -oresults.csv

    Also, if its shell you can do something like this in shell,

    isql -Uuser -Sserver -Ppassword << END
    yoursql
    go
    END

Posting Permissions

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