home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.robelle3000.ai 2014
/
2014.06.ftp.robelle3000.ai.tar
/
ftp.robelle3000.ai
/
faq
/
s4.txt
< prev
next >
Wrap
Text File
|
1995-10-11
|
988b
|
31 lines
Suprtool as a Database Integrity Tool.
Financial transactions are often processed in batches. Between jobs aborting,
program bugs, and less-than-careful data fixes by MIS staff, these batches can
get out-of-balance. Using the Total command can quickly verify that all
transactions net to zero.
Do the debits equal the credits?
:run suprtool.pub.robelle
>base fms.gl,5,reader
>get d-transactions
>output $null
>total trans-amt
>xeq
Totals (SUN, JAN 29, 1995, 2:56 PM):
TRANS-AMT 81451+
IN=6, OUT=6. CPU-Sec=1. Wall-Sec=1.
By default the results of the Total command are displayed on the screen
($STDLIST), but can be appended to the output file. To do, this you need to
turn Set Squeeze Off and add a new Total command as follows:
total $file filename,append
Up to 15 fields can be totalled in each pass.
[Taken from the "Ensuring Data Integrity Using Suprtool" tutorial
given at Interex in Toronto.]