MLoad data handling question

Tools & Utilities
Teradata Employee

MLoad data handling question

Hello,

Can MLoad handle data that is in Scientific notation? example : 8.56055E10

If so, how would you could for such a value?

Thanks!

Paul
1 REPLY
Enthusiast

Re: MLoad data handling question

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
, ......)
;