|
Home > Archive > SQL Anywhere database replication > January 2006 > coma separator as a decimal separator
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
coma separator as a decimal separator
|
|
| Adam Polech 2006-01-26, 4:56 pm |
| hi all
i have text file
aa 1,000
bb 2,000
....
I try to use command
LOAD INTO TABLE ...
but validation error is appeared: item 1,00 does not pass deciaml(8,3)
How to set in sqlanywhere database coma separator as a decimal separator?
In SET OPTION command I can not find any appropriate option.
Thank you in advance.
Adam
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2006-01-26, 4:56 pm |
| Please do not cross post. The general newsgroup was the problem forum for
this question.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Adam Polech" <a.polech@wapro.pl> wrote in message
news:43d7d20c@forums
-1-dub...
> hi all
> i have text file
>
> aa 1,000
> bb 2,000
> ...
>
> I try to use command
> LOAD INTO TABLE ...
>
> but validation error is appeared: item 1,00 does not pass deciaml(8,3)
>
> How to set in sqlanywhere database coma separator as a decimal separator?
>
> In SET OPTION command I can not find any appropriate option.
> Thank you in advance.
>
> Adam
>
>
|
|
|
|
|