User's Guide

Part V. The SQL Anywhere Programming Interfaces

Chapter 38. The WSQL HLI Interface

Syntax

     PREPARE statement-name FROM statement

     statement-name:    identifier, or host variable

     statement:    string or host variable

Purpose

To prepare and name a SQL statement.

See also

DECLARE, DROP, OPEN, EXECUTE.

Description

This command prepares a statement to be executed or used for a cursor. Any statement previously prepared with the same name is overwritten.

To free resources associated with a prepared statement, use the DROP command.

This command is functionally similar to the Embedded SQL command PREPARE. See "PREPARE statement".