Change SQL decimal delimiter

[#1]

Hello! I am trying to import data into my table using

INPUT INTO

The problem is my decimals is using , as a delimiter, and it expects .. So it won't work!

How can i change this? Search and replace in the input file is not an option!

I am using SQL Anywhere 10

[VolkerBarth]

Erik,

AFAIK formatting numbers is not possible with builtin tools in SA. The main reason is that "formatting" is seen as a client-task and not one for the server. (Though there definitely are reasons to take a different view, methinks.)

There are a few workarounds, cf. the newsgroup sybase.public.sqlanywhere.general.

Just a few threads that might fit:

news://forums.sybase.com:119/[email protected]

news://forums.sybase.com:119/[email protected]

(If those links don't work, you might search for decimal in this newsgroup.)

HTH Volker