Hi experts,
here I am getting some information in bigint format. If I convert that into string, then
(i) will it fit in that ?
(ii)do I lose any data?
(ii) Is the data contained in the string will be in readable format or not?
My second question is what is the highest number which can be inserted in a bigint?
Thanks in advance
Kavuri
conversion from bigint to string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1 (i) OK provided your string is large enough
1 (ii) No provided your string is large enough
1 (iii) Yes
2 BigInt is 64-bit integer. 2^64 is 18,446,744,073,709,551,616 - that is, 20 digits.
The largest uint64 is 18,446,744,073,709,551,615; the smallest int64 is -18,446,744,073,709,551,616
1 (ii) No provided your string is large enough
1 (iii) Yes
2 BigInt is 64-bit integer. 2^64 is 18,446,744,073,709,551,616 - that is, 20 digits.
The largest uint64 is 18,446,744,073,709,551,615; the smallest int64 is -18,446,744,073,709,551,616
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
That is a conversion that will happen implicitly in PX jobs, but you can also explicitly convert using the DecimalToString() function,.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>