Sybase to SELECT INTO CSV with fields containing comma

Asked Sep 01 '15 at 06:06

Active Sep 01 '15 at 07:06

Viewed 501 times

In MySql we can programmically export table into CSV via the following command:

SELECT * INTO OUTFILE 'C:/test.csv' FIELDS TERMINATED BY ',' FROM MyTable;

However is there a Sybase ASE equivalent to export table programmically into CSV? Also, that data may contain commas as well. Is there a command in Sybase to handle commas in data?

If there isn't I think I can only use ResultSet and loop and append. And in ResultSet I can explicitly handle the commas myself.

In order for Sybase ASE to export data to CSV, SQLAnywhere is required. I think I will just use ResultSet. Since the rows for the table is less than 100 at anytime, I think it won't take a performance blow.

edited Sep 01 '15 at 07:06

asked Sep 01 '15 at 06:06

user2670633

1

Possible duplicate of http://stackoverflow.com/questions/769621/dealing-with-commas-in-a-csv-file – Jozef Chocholacek Sep 01 '15 at 06:12
Ok thanks Jozef Chocholacek I will look at that thread. – user2670633 Sep 01 '15 at 06:21

Sybase to SELECT INTO CSV with fields containing comma

0 Answers0