DBPREPARE

9.0, PLBCMP GUI or PLBLinux Only

 

The DBPREPARE instruction sends the current SQL statement to the remote database for faster access. The instruction uses the following format:

 

 

[label]

DBPREPARE

{db}

 

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. The prepared SQL statement can request parameters during execution through the use of the question mark (?) character. Any (?) characters specified in a SQL statement are replaced by a parameter variable specified in the USING list of a DBEXECUTE instruction. A maximum of 99 parameters or (?) parameter characters are supported. (9.7C)

  2. An SQL statement must be created using DBSEND before a DBPREPARE can be executed.

 

 

See Also: Example Code, SQL Instructions

 


PL/B Language Reference DBOPEN DBRESULT