pears.TempHolidayCalcItem
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE FUNCTION "pears"."TempHolidayCalcItem"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ IN "ValString" long VARCHAR,IN "Stat" INTEGER ) RETURNS CHAR(200) BEGIN RETURN "regexp_substr"('"'+"Valstring","string"('(?<="',"Stat",'=)[^"]*')) END