Re: Read/write textfiles using Transact SQL in Sybase

sgaikwad@xxxxxxxxxxxx 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.
.

Relevant Pages

  • Read/write textfiles using Transact SQL in Sybase
    ... As per our project requirement, we need the following issues to be ... Can we read or write a text file using Transact-SQL in Sybase ... Prev by Date: ...
    (comp.databases.sybase)
  • Sybase/TransactSQL calculations
    ... Below are the results of AxBxCxD on 2 records 9609 and 9610 using ... Transact-SQL. ... As you can see for record 9609 the Excel result matches ... the Sybase result. ...
    (comp.databases.sybase)
  • Re: Sybase/TransactSQL calculations
    ... Transact-SQL. ... As you can see for record 9609 the Excel result matches ... the Sybase result. ... the results differ for record 9610. ...
    (comp.databases.sybase)
  • Re: [OT] Weve always know that Solaris is junk....
    ... What technical Merit? ... Not in regards to the company that had to stay ... Sybase was in dire financial strait and had to dump VMS and 11 other ... SUN was second to VMS. ...
    (comp.os.vms)
  • Re: Billing System
    ... db support w2k and sybase. ... Subject: Billing System ...
    (freebsd-isp)