Writing the Command File
The command file (seteod.cmd), batch file (seteod.bat), or shell script (seteod.sh) must contain the following line:
dbutility process datasourcename
where datasourcename is the name of the datasource you want to process.
In addition to specifying the name of the datasource to process, the command file or batch file can indicate when the DATABridge Client is to stop processing updates.
Note: This guide provides guidelines for specifying these operations in a Windows command or batch file only. Use similar commands for the UNIX shell script.
In the following example, a site’s end-of-day processing is finished. An operator or WFL scheduler invokes the Notify utility on the host. In this case, the command file calls isql to do the following:
Sample Command File
The following is a sample Windows command file that uses the optional specifications:
isql -U user -P passwd -d BANKDB -Q "update DATASOURCES set stop_afn=%1 where data_source='BANKDB'"
dbutility switchaudit BANKDB
dbutility process BANKDB