Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    13

    Unanswered: Using xp_write_file in Sybase 12.5.4

    I am using Sybase 12.5.4 on Windows 2003 Server.
    Are xp_write_file and xp_read_file Extended stored procedures available on 12.5.4.

    I tried to use these in stored procedure, it gave me following error,

    'Function xp_write_file not found,....'

    I tried running query
    sp_help xp_write_file in subsystemprocs. It shows 'Object does not exist in this database'.

    In Syabse Central, Extended Stored Procedures section doesn't list these things.

    Is it possible to use these in 12.5.4 or Extended Stored Procedure needs to be written for file handling?

    Can anybody help me? Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Those functions are in ASA I think, which is a totally different product than ASE. Try to read up on xp_cmd_shell. Maybe you could achieve it through that.

    But again, xp procedures are still not that great with ASE. So, you are better off writing any file read/writes from an app using say for eg., c, java, perl etc.

  3. #3
    Join Date
    Nov 2007
    Posts
    13

    Using xp_write_file in Sybase 12.5.4

    Thanks for reply!
    You mean, writing extended stored procedure for reading & writing files would be better than using xp_cmdshell.

Posting Permissions

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