SysSetup - Data update job after DB sync

on

 Data update job

  1. [
  2.     SysSetupTable(tablestr(TableName)),
  3.     SysSetupConfig(true, 300)
  4. ]
  5. class CPSysSetupTableName implements SysSetup
  6. {
  7.     public void loadData()
  8.     {
  9.         DataArea dataArea;
  10.     
  11.         while select id from dataArea 
  12.             where dataArea.isVirtual == NoYes::No
  13.                 && dataArea.id != 'DAT'
  14.         {
  15.             changecompany(dataArea.id)
  16.             {
  17.                 ttsbegin;
  18.                 //Some data update logic
  19.                 ttscommit;
  20.             }
  21.         }
  22.     }
  23. }

Testing

To check that data update job runs correct on dev environment we can create temporary runnable class 
  1. internal final class RunnableClass1
  2. {
  3.     public static void main(Args _args)
  4.     {
  5.         CPSysSetupTableName sysSetup = new CPSysSetupTableName();

  7.         sysSetup.loadData();
  8.     }
  9. }
To run runnable class from user interface
/?mi=SysClassRunner&cls=RunnableClass1