Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    2

    Question Unanswered: Command Shell in Sybase

    Is there an equivalent to MSSQL - xp_cmdshell in Sybase?
    I want to use a trigger to copy a flag file when a table is updated, this will be used by a scheduling tool to bcp out the table.


    Mike

  2. #2
    Join Date
    May 2006
    Posts
    2

    Update

    The xp_cmdshell command is not installed, in fact no xp procs are installed.

    I am looking at other options.
    Mike

  3. #3
    Join Date
    Jun 2006
    Posts
    16
    you can create a open server which can do your bcp. and send command to the open server with RPC command.

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Unlike MS SQL there aren't any WMI scripts available on Sybase, but XP is certainly available by default.

Posting Permissions

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