Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
What is the use of autonumberhash128? Can any one explain me with some example.
By the way what is mean by "returns a unique integer value for each distinct hash value" ? Does it mean that it will return unique integer value for Region, Year and Month separately ? Or together it will generate unique value. Please explain the same with example and output as given example is not good enough to understand.
Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
autonumberhash128 ( Region, Year, Month )
Look at the examplem attached.
autonumberhash128(Region,year,Nonth)
It Generate Indexing based on whatever parameter you set as expression.
Expression should be distinct hash value.
Hi Santhosh,
Many thanks for your help. Seeing the document I feel it generates 1 key value for all the expression value combined together. I was just thinking that it will generate key value for each expression field. I got confused as it was not showing any value in the assigned variable as shown below.
SET PKexp=autonumberhash128(stkcode,stkname);
Document attached by you helped me to understand easily.
Hi Sunil,
Thanks for the explanation.