IQX Quick Menu

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

CREATE FUNCTION "pears"."NotificationAttachments"( IN "pTemplateID" CHAR(50),IN "pRecipientType" CHAR(20),IN "pPersonID" CHAR(20),IN "pVacancyID" CHAR(20),IN "pCompanyID" CHAR(20),IN "pDivisionID" CHAR(20),IN "pSubjectType" CHAR(20) DEFAULT NULL,IN "pSubjectIDs" CHAR(100) DEFAULT NULL ) 
RETURNS CHAR(255)
BEGIN
  -- Return comma separated list of file pathnames or documents of the form RecordType: Document name with optional wild cards
  -- e.g. Company: Contract*
END

pears.NotificationAttachments

Original SQL

iqx