dbTalk Databases Forums  

BCP numeric data in scientific notation

sybase.public.ase.general sybase.public.ase.general


Discuss BCP numeric data in scientific notation in the sybase.public.ase.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Levi Bakker
 
Posts: n/a

Default BCP numeric data in scientific notation - 12-28-2010 , 03:03 PM






I have a process which writes a file to be bcp'd in. When I run the
bcp command I am using the character format (-c option), and I am
wondering about the behaviour when I encounter numeric values
represented in scientific notation.

I have noticed that for a column that is defined as "numeric(21,4)" I
can manually insert a value that is represented in scientific
notation, however in the bcp, I get an overflow error.

Is there any way that I can make the bcp command behave the same way
an insert statement would, when encountering scientific notation?

Reply With Quote
  #2  
Old   
doemeli
 
Posts: n/a

Default Re: BCP numeric data in scientific notation - 12-30-2010 , 04:05 AM






which version of ASE and BCP you are using ?
and how does your bcp file looks like ?

make sure your whole string should not be bigger than 21.
for example:

value --> 123456789123456789123.1234 --> not working
value --> 12345678912345678.1234 --> working

have you tried to increase the length of your numeric field?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.