Hello,

As per our project requirement, we need the following issues to be
solved using Transact-SQL in Sybase:
1. Can we read or write a text file using Transact-SQL in Sybase
database?if yes, need the syntax of the same.
2. How do we run a Batch File (Command File) using Transact-SQL in
Sybase database?

It will be very appreciated for your responses asap. We are in very
urgent schedule.

Thanks in advance..

Regards,
Sowmya

sgaikwad@hcltmass.com wrote:
> Hello,
>
> As per our project requirement, we need the following issues to be
> solved using Transact-SQL in Sybase:
> 1. Can we read or write a text file using Transact-SQL in Sybase
> database?if yes, need the syntax of the same.

Many ways to skin this cat. Prolly best to bcp it into a table and then
deal with it.

> 2. How do we run a Batch File (Command File) using Transact-SQL in
> Sybase database?

Check out xp_cmdshell

> It will be very appreciated for your responses asap. We are in very
> urgent schedule.
>
> Thanks in advance..
>
> Regards,
> Sowmya

Good luck, Frank.

Asuming you mean ASE when you say "Sybase database"...

1) Files can be written on the server host machine using xp_cmdshell
to CAT strings to a file. You can also use the external file system
(XFS) feature, which allows ASE to view files as tables. This is an
extra-cost license on 12.5.x but is included with 15.0.

http://sybooks.sybase.com/onlinebook...ystem+a ccess

2) xp_cmdshell