pears.GetBrand

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

Original SQL

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