====== 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