====== pears.PersonUnavailabilityAlert ======
<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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."PersonUnavailabilityAlert" IS 
{create function PersonUnavailabilityAlert 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in pid char(20),in PorT char(1),in dfrom date,in dto date)
returns char(200)
begin
  declare ua char(100);
  declare al char(100);
  select personunavailability(pid,port,dfrom,dto) into ua;
  select trim(isnull(alert,'')) into al from person where personid = pid;
  if ua <> '' and al <> '' then
    set ua=ua+' / '
  end if;
  return(ua+al)
end
}
</code>