DBSTATE

8.0.4, PLBCMP GUI or PLBLinux Only

The DBSTATE instruction determines the status of a DBEXECUTE instruction. The instruction uses the following format:

Where:

label

Optional. A Program Execution Label.

db

Required. A DBFILE or DBSTATEMENT variable defining the database associated with the connection.

Flags Affected: LESS, ZERO

Note the following:

1. The ZERO flag is set if the database has data available for retrieval.

2. The LESS flag is set if the query is currently executing at the database.

See Also: Example Code, SQL Instructions