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 asked 26 Jan '10, 12:06 Erik Volker Barth |
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:
(If those links don't work, you might search for decimal in this newsgroup.) HTH Volker answered 27 Jan '10, 15:32 Volker Barth |
Erik. 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.
HTH Thomas answered 28 Jan '10, 11:44 Thomas Dueme... |