pears.PersonUnavailabilityAlert

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

Original 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
}