pears.CacheWarm [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.CacheWarm ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
CREATE EVENT "pears"."CacheWarm" TYPE "DatabaseStart"  ENABLE 
HANDLER
begin
  if "PROPERTY"('IsService') = 'Yes' then
    message "string"('IQX Cache Warming Started at ',current timestamp) to console;
    unload select * from "pears"."AccordEmployee" into file 'nul';
    unload select * from "pears"."Company" into file 'nul';
    unload select * from "pears"."CompanyAccount" into file 'nul';
    unload select * from "pears"."ContactEvent" into file 'nul';
    unload select * from "pears"."Department" into file 'nul';
    unload select * from "pears"."Diary" into file 'nul';
    unload select * from "pears"."Dictionary" into file 'nul';
    unload select * from "pears"."Employment" into file 'nul';
    unload select * from "pears"."IQacDocument" into file 'nul';
    unload select * from "pears"."IQacJournal" into file 'nul';
    unload select * from "pears"."Pay_Employee" into file 'nul';
    unload select * from "pears"."Person" into file 'nul';
    unload select * from "pears"."Phone" into file 'nul';
    unload select * from "pears"."PhoneType" into file 'nul';
    unload select * from "pears"."Placement" into file 'nul';
    unload select * from "pears"."Progress" into file 'nul';
    unload select * from "pears"."Search" into file 'nul';
    unload select * from "pears"."Staff" into file 'nul';
    unload select * from "pears"."Tag" into file 'nul';
    unload select * from "pears"."TagChoice" into file 'nul';
    unload select * from "pears"."TagValue" into file 'nul';
    unload select * from "pears"."TempDesk" into file 'nul';
    unload select * from "pears"."TempJobRate" into file 'nul';
    unload select * from "pears"."TempJobRateMaster" into file 'nul';
    unload select * from "pears"."TempJobType" into file 'nul';
    unload select * from "pears"."TempPayBand" into file 'nul';
    unload select * from "pears"."TempPoolMember" into file 'nul';
    unload select * from "pears"."TempShift" into file 'nul';
    unload select * from "pears"."TempShiftPlan" into file 'nul';
    unload select * from "pears"."TempProvTimeSheet" into file 'nul';
    unload select * from "pears"."TempProvTimesheetLine" into file 'nul';
    unload select * from "pears"."TempProvTimesheetShift" into file 'nul';
    unload select * from "pears"."TempTimeSheet" into file 'nul';
    unload select * from "pears"."TempTimesheetLine" into file 'nul';
    unload select * from "pears"."Vacancy" into file 'nul';
    unload select * from "pears"."VacancyRole" into file 'nul';
    unload select * from "pears"."VacancyRoleAllocation" into file 'nul';
    unload select * from "pears"."WPKAssignedRole" into file 'nul';
    unload select * from "pears"."WPKChangeTracker" into file 'nul';
    unload select * from "pears"."WPKForm" into file 'nul';
    unload select * from "pears"."WPKGlobalSwitch" into file 'nul';
    unload select * from "pears"."WPKGlobalSwitchGroup" into file 'nul';
    unload select * from "pears"."WPKGlobalSwitchSetting" into file 'nul';
    unload select * from "pears"."WPKImage" into file 'nul';
    unload select * from "pears"."WPKLayout" into file 'nul';
    unload select * from "pears"."WPKLayoutView" into file 'nul';
    unload select * from "pears"."WPKPickList" into file 'nul';
    unload select * from "pears"."WPKPickListChoice" into file 'nul';
    unload select * from "pears"."WPKPickList" into file 'nul';
    unload select * from "pears"."WPKRole" into file 'nul';
    unload select * from "pears"."WPKView" into file 'nul';
    unload select * from "pears"."WPKViewItem" into file 'nul';
    message "string"('IQX Cache Warming Completed at ',current timestamp) to console
  end if
end
</code>