The T_APP_TIME table
The T_APP_TIME table is predefined in every user application definition, and can be created in the same way other tables are created. When the application timer is running, table T_APP_TIME contains exactly one record that reflects the current "application" date and time.
Constraints that are defined on T_APP_TIME, and that are successful, have the effect of scheduled updates of the database.
The T_APP_TIME table contains the following columns:
•APP_WEEKDAY (1=Sunday, 7=Saturday)
•APP_YEAR (4 digits, not century based)
•APP_MONTH (1=January, 12=December)
All columns have the NUMBER data type and contain an integer.