cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Is there a way to change the 'Default field Separator' for the import/Export in Sybase 17 in CMD? The defualt separator is ';' and I want to change it to ',' using a batch file, rather than DBISQL->Tools->Options->Import/Export. Thanks in advance for any help

0 Likes
View Entire Topic
VolkerBarth
Contributor

Ah, I think I misunderstood your question. There is the DBISQL option "isql_field_separator" which you can set via SET OPTION to the desired value, such as:

SET OPTION isql_field_separator=',';

or change it to the default by

SET OPTION isql_field_separator=;