All Forums Tools
Greyghost 51 posts Joined 07/09
23 Jul 2009
MLoad data handling question

Hello,Can MLoad handle data that is in Scientific notation? example : 8.56055E10If so, how would you could for such a value?Thanks!Paul

Jimm 298 posts Joined 09/07
24 Jul 2009

You can use pretty much any SQL functions in Mload, except things like aggregates or Olap.If your input field comes in as char in the format you specified, just load it as you would any other data type.So:.Field FloatValue * Char(?) ;Insert Into ???(FloatValue, ....)Values (:FloatValue, ......);

You must sign in to leave a comment.