DBCLEAR

8.0.4, PLBCMP GUI or PLBLinux Only

The DBCLEAR instruction clears any previous DBSEND data. 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: none

Note the following:

1. Any previous DBSEND data is lost.

2. If a DBFILE operation causes a DBFAIL TRAP or EXCEPTSET event, the DBCLEAR instruction should be executed to clear the query that caused the error.

See Also: Example Code, SQL Instructions