DBEXECUTE

9.0, PLBCMP GUI or PLBLinux Only

The DBEXECUTE instruction executes a database query that has been built using the DBSEND 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.

parameters

Optional. A list of parameters.

Flags Affected: none

Note the following:

1. This instruction initiates the query and returns control to the PL/B program as soon as the query has been sent to the database engine. The DBSTATE instruction must determine when the DBEXECUTE has completed processing.

2. The statement that is executed is actually an SQL statement. The SQL statement is built using one or more DBSEND instructions.

3. Linux queries must contain a single SQL statement and should not be semicolon terminated.

4. Parameters can be a Character String Variable or a Numeric Variable. These parameters are used for any parameters specified in a SQL statement. A maximum of 99 parameters are allowed (9.7C). Any parameter variables beyond 99 are ignored. See the DBPREPARE instruction for information of parameter usage.

See Also: Example Code, DBBREAK, SQL Instructions