Paul,
I have implemented more or less the same procedure as Karen describes
with a few differences.
The differences are:
On beforehand I perform some calculations like counting the number of
columns in all tables and the total number of rows in the database
It looks like this:
SET VAR V_SYS_NUM_COLUMNS_ATL BIGINT = 0
SET VAR V_SYS_NUM_ROWS_ATL BIGINT = 0
SET VAR V_TOTAAL BIGINT = 0
--
SELECT SUM(SYS_NUM_COLUMNS) INTO V_SYS_NUM_COLUMNS_ATL INDICATOR
V_IND01S FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table'
SELECT SUM(SYS_NUM_ROWS) INTO V_SYS_NUM_ROWS_ATL INDICATOR V_IND02S
FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table'
--
SET VAR V_TOTAAL = (.V_SYS_NUM_COLUMNS_ATL + .V_SYS_NUM_ROWS_ATL)
Then I perform a reload with setting error messages on.
After the reload I perform the same calculations and compare the outcome
with the apriori calculations
If there is a difference I rollback the database.
Tony
Op 22-04-2021 om 15:46 schreef [email protected]:
Good morning,
I’m running the latest build of R:BASE X.5 Enterprise and I’m trying
to incorporate the AutoCHK command to run in a scheduled task every
night before doing a “Pack in Place”. Anyone have experience with
this? Anyone will to share your code? Thought I’d ask that last one 😊
Thanks,
Paul Buckley
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAJ4mzQXf2gpHhGgkNNfb5kTCgAAAEAAAAPzkRWmLe5JOt01PLYI1e4kBAAAAAA%3D%3D%40buckleyandassoc.com
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAJ4mzQXf2gpHhGgkNNfb5kTCgAAAEAAAAPzkRWmLe5JOt01PLYI1e4kBAAAAAA%3D%3D%40buckleyandassoc.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/ba810e9a-4c66-3004-f1ff-15bac62592a9%40cio-bv.nl.
