pears.GetBrand

CREATE FUNCTION "pears"."GetBrand"( IN "persid" CHAR(20),IN "vacid" CHAR(20),IN "ClientOrTemp" CHAR(1),IN "Use" CHAR(20) ) 
RETURNS CHAR(2)
BEGIN
  DECLARE "RVal" CHAR(2);
  IF "Use" = 'NOTIFY' THEN
    -- ClientOrTemp C - client T - temp
  END IF;
  -- return visibleID of brand
  RETURN "RVal"
END