conversion from bigint to string

kavuri · Post by **kavuri** » Thu Jul 26, 2007 1:30 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 26, 2007 2:20 pm

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

kavuri · Post by **kavuri** » Thu Jul 26, 2007 2:56 pm

Hi Ray,
Is there any inbuilt function in datastage directly we can use to convert bigint into string.

Thanks
Kavuri

ArndW · Post by **ArndW** » Thu Jul 26, 2007 9:01 pm

That is a conversion that will happen implicitly in PX jobs, but you can also explicitly convert using the DecimalToString() function,.