pears.PersonUnavailabilityAlert

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

Original SQL

CREATE FUNCTION "pears"."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