====== pears.GetBrand ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code 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
</code>