0 - 5 of 5 tags for #Datatype

Hi I have below piece of code 


I have a design question with respect to varchars.

Has anyone gotten this to work?  Apparently Oracle Transparent Gateway is trying to convert a character column defined as varchar(10000) -- only the first 999 characters are populatedm, but trim doesn't help -- OTG converts it to LONG.  The select / join gets an error -- illegal use of LONG datatype. 

Hello All,
I have few questions,

I have a some data which I need to store in Teradata as E-notation. Values can be between 1.17549E-38 to 3.40282E+38.
It would be great if best suitable data type and loading method can be advised.
Kawish -