I need to hash a column in Teradata. I have the follwing code in SAS and i would like the output to be equal:
COLUMN_HASH = upcase(put(sha256(strip(COLUMN)), hex64.));
But i cannot use SAS to insert the records to teradata, it would need to be done from a teradata table to another.
I would like to know if something similar to these answers exist in teradata because i haven't found something similar.
Thanks.