Omron NX701-1620 - Page 256

Appendix A
A-68
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
 Sample Programming
- Change the variable Warning to TRUE when the Spool usage of the DB Connection named MyDatabase1 has exceeded 80%.
Check the completion of the DB_GetConnectionStatus instruction.
DB_GetConnectionStatus_instance.Done
OperatingEnd
DB_GetConnection
Status_instance.Error
Accept the trigger.
Trigger
Operating
RS_instance
OperatingEnd
Set
Reset1
RS
Q1
Get the status of the DB Connection.
Operating
DB_GetConnectionStatus_instance
Execute
DBConnectionName
DB_GetConnectionStatus
Done
Busy
Error
ErrorID
ConnectionStatus
MyStatus
‘MyDatabase1’
When the instruction is normally completed, change the value of the variable Warning to TRUE if the Spool usage has exceeded 80%.
Operating
DB_GetConnectionStatus_instance.Done
Warning
S
GetConnectionStatus_OK
S
DINT#80
MyStatus.SpoolUsageRate
EN
In1
In2
<
When the instruction is terminated due to an error, change the variable Warning to FALSE.
Operating
DB_GetConnectionStatus_instance.Error
// Error handler
GetServiceStatus_OK := FALSE;