www.mimer.com/developer

PREPARE

---

Prepares an SQL statement contained in a host string variable for execution.

Usage

Embedded.

Description

The SQL statement contained in the host variable is prepared for execution. This function is equivalent to pre-processing and compiling an embedded SQL statement, but is performed at run-time. The (internal) output form of the statement is identified by the statement-name parameter.

See ALLOCATE CURSOR for a description of extended statements.

The following SQL statements can be used with the PREPARE statement:

• Connect Statements

  Enter

  Leave

• Data Definition Statements

  CREATE

  ALTER

  DROP

  COMMENT

• Access Control Statements

  GRANT

  REVOKE

• Transaction Control Statements

  START

  COMMIT

  ROLLBACK

  SET SESSION

  SET TRANSACTION

• Data Manipulation Statements

  INSERT

  DELETE

  DELETE CURRENT

  UPDATE

  UPDATE CURRENT

  SELECT

  SET

  CALL

• System Administration Statements

  SET DATABASE

  SET DATABANK

  SET SHADOW

Restrictions

None.

Notes

The source form of the SQL statement to be prepared is not preceded by the identifier "EXEC SQL" or terminated by the language-specific delimiter. The source statement may contain question marks as parameter markers to represent variables to be used when the prepared statement is executed. See the Mimer SQL Programmer's Manual for more details.

Standard Compliance

Standard	Compliance	Comments
X/Open-95 SQL92	YES	Fully compliant.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se