Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to convert number to varchar2 in the talend and eliminate scientific value in the DB

Hi All, 

i am facikng a small issue with the Data like the source is having a data type as Number and the data lenght is more than 120. now i want to insert the same data in to target. can u suggest any solution.

Labels (3)
1 Reply
Anonymous
Not applicable
Author

hello,

long: The long data type is a 64-bit two's complement integer. The signed long has a minimum value of -263 and a maximum value of 263-1. In Java SE 8 and later, you can use the long data type to represent an unsigned 64-bit long, which has a minimum value of 0 and a maximum value of 264-1. Use this data type when you need a range of values wider than those provided by int. The Long class also contains methods like compare Unsigneddivide Unsigned etc to support arithmetic operations for unsigned long.

 

Thanks,

 

Warm Regards,
Manish 

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved