How to convert Table data to Flat file in Sybase

[biraja]

We have an requirement for convertion of Sybase Table data to Flat files ? Is there any feaure in Sybase 10.2 like Oracle has feature to convert table data to flat files through Stored procedures ?
Thanks
Biraja

 

[BCP]

Use bcp utility

 

[ppg111]

Birja,
As you mentioned how one can convert oracle table to flat files using oracle stroed procedures?...
Or is there any other way round....

rgds,
Pravin G>

 

[walkerci]

Biraja,

You could also use an ISQL script, if you only need a character stream output.

Or you could create an ODBC DSN and use MS Access, Excel, etc, to extract the data, if the data volumes are not to big.

Hope this helps,

Charles

 

[toring]

Another option is to utilize external file system access (ASE12.5). Then you can create a proxy table in the server who actually points to a file and write to it through standard SQL-statments (through a stored procedure if you wants to).