pears.hashToIqxId

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."hashToIqxId"( 
  IN "source" CHAR(255) ) 
RETURNS CHAR(20)
deterministic
BEGIN
  RETURN "upper"("left"("IQXDBID"+"hash"("source"),20))
END