Parameters for the amda Utility

The parameters for the amda utility define the test for the delta alert.

amda -d database -t table -r @RecID -c columns [-u username] [‑p password] [-o operator]

Parameters

Option	Description
-d	DSN of the virtual database created using QDMG
-t	Name of table to query
-r	Placeholder parameter ‘@RecID’ for the record ID of the required row in the queried table
-c	Name of one or more columns to test, comma-separated with no spaces
-u	User name if database security is enabled
-p	Password if database security is enabled
-o	Boolean operator ‘or’ (default) or ‘and’ when querying more than one column
-h	Help

For example, the following entry as a RunProgram alert action tests audit records for events marking changes in either the column for amount owed or the column for amount paid in the Billing table in Demodata.

amda -d DemodataV -t Billing -r @RecID -c Amount_Owed,Amount_Paid

This same delta alert is used under Delta Alert Example.