SE_stream_prepare_sql

Prepares an SQL statement for execution

Usage syntax

LONG SE_stream_prepare_sql
(SE_STREAM stream,
const CHAR *sql_stmt);

Parameters
stream The stream handle
sql_stmt The SQL statement
Description

SE_stream_prepare_sql takes an SQL string or query and passes it to the ArcSDE server so that the DBMS can prepare the request for execution. Preparation of the SQL string or query includes the DBMS parsing of the statement. SE_stream_prepare_sql accepts any SQL statement supported by the underlying DBMS.

You must prepare an SQL statement with the SE_stream_prepare_sql function before SE_stream_execute can execute a statement on the DBMS.

Returns

SE_SUCCESS
SE_ATTR_CONV_ERROR

SE_CONNECTION_IN_USE

SE_CONNECTION_LOCKED

SE_DB_IO_ERROR

SE_FUNCTION_EXISTS

SE_FUNCTION_NO_EXISTS

SE_INVALID_SQL

SE_INVALID_PARAM_VALUE

SE_INVALID_POINTER

SE_NET_FAILURE

SE_NOT_A_SELECT_STATEMENT

SE_OUT_OF_CLMEM

SE_OUT_OF_SVMEM

SE_SDE_NOT_STARTED

SE_STREAM_IN_PROGRESS