Reading BIGINT data from teradata

[Sheeba]

tnx Tom. I will definitely look forward for that option.

[jakarman]

Sheeba when you try to convert bigint to SAS numeric you are going to lose precision as numeric in SAS =floating= that is an implied dataconversion with limitations.

When you replace the bigint type with the char-type you are not changing anything as the identifier of a customer is not meant to do calculations.

Trying to do calculating a mean and variance on those identifier numbers is meaningless.

Would you use Sepa banking-accountnumbers you cannot use bigint as that contain characters (in some countries).

This type of smart compression using numbers within technology is coming of the old hollerith age. I am sorry for that.

[Sheeba]

Thanks Jaap. I will try to get familiarized with DS2

[Sheeba]

Hi ,

I have figured another way for reading the bigint column from Teradata. It is possible to cast the column as decimal while making passthrough. Then it is required to merge the temporary table(output of passthrough ) to the original table which requires column addition..

Regards,

Sheeba Swaminathan