Hello! I am trying to import data into my table using
The problem is my decimals is using
How can i change this? Search and replace in the input file is not an option!
I am using SQL Anywhere 10
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:
(If those links don't work, you might search for decimal in this newsgroup.)
answered 27 Jan '10, 15:32
Probably you can pull the date in a staging (temporary) Table. You could read the Field in as a string value.
In as second step you can the push it into the correct destination.
answered 28 Jan '10, 11:44