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"."DocumentPackAttachName"( IN "docpackid" CHAR(20),IN "doctypeid" CHAR(20),IN "persid" CHAR(20),IN "vacid" CHAR(20),IN "planid" CHAR(20),IN "shiftid" CHAR(20),IN "placid" CHAR(20) ) 
RETURNS long VARCHAR
BEGIN
  -- persid, docpackid, doctypeid and vacid always populated
  DECLARE "rv" long VARCHAR;
  SELECT "description" INTO "rv" FROM "documenttype" WHERE "documenttypeid" = "doctypeid";
  RETURN("rv")
END

pears.DocumentPackAttachName

Original SQL

iqx