DBSTATEMENT

9.0, PLBCMP GUI or PLBLinux Only

The DBSTATEMENT instruction defines a working space in a user application that processes a SQL statement using a pre-existing database connection (DBFILE). The instruction uses the following format:

Where:

label

Optional. A Program Execution Label.

%

Optional. Denotes the item as being GLOBAL.

*

Optional. Denotes the item or file as being COMMON.

^

Optional. Denotes the item as being a POINTER.

Flags Affected: none

Note the following:

1. The DBOPEN instruction associates the DBSTATEMENT with the DBFILE that must have been previously connected using a DBCONNECT instruction.

2. This instruction reserves memory in the User Data Area.

3. This instruction may be placed in common or the Global Data Area.

4. This instruction may be defined as a pointer to another DBSTATEMENT instruction.

See Also: Example Code, SQL Instructions