[august97]

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!

[trvishi]

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.

[august97]

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