The RESET command adjusts the last modification date/time stamp for tables and views.
When copying table and view information with the UNLOAD command, the output automatically generates RESET commands after the table/view definition, to reset the date/time stamp and retain the original value.
tblview
Specifies a table or view.
value
Specifies the date/time stamp for tables or views.
Examples
The below resets the last modification date and time stamp for the LicenseInformation table.
RESET LicenseInformation LAST_MOD TO '12/15/2022 12:00'
The below resets the last modification date and time stamp for the SalesDataByCompany view.
RESET SalesDataByCompany LAST_MOD TO '01/01/2022 08:00'
