SE_stream_insert_table

Identifies columns to populate when inserting data into a DBMS table

Usage syntax

LONG SE_stream_insert_table
(SE_STREAM stream,
const CHAR *table,
SHORT num_columns,
const CHAR **columns);

Parameters
stream The stream handle
table The name of the table to insert rows into
num_columns The number of attribute columns to use when inserting data
columns The array of column names to use when inserting data
Description

SE_stream_insert_table inserts data into spatial and nonspatial tables. The function identifies which columns to update when inserting new records into a DBMS table and must be called before ArcSDE inserts new data into a DBMS table. When SE_stream_execute is called for each new row, the table columns defined in SE_stream_insert_table are inserted in nonbuffered mode.

Returns

SE_SUCCESS
SE_ATT_NOEXIST

SE_CONNECTION_IN_USE

SE_CONNECTION_LOCKED

SE_DB_IO_ERROR

SE_FAILURE

SE_INVALID_PARAM_VALUE

SE_INVALID_STREAM

SE_INVALID_POINTER

SE_NET_FAILURE

SE_OUT_OF_CLMEM

SE_OUT_OF_SVMEM

SE_SDE_NOT_STARTED

SE_STREAM_IN_PROGRESS

SE_TABLE_NOEXIST

Notes

∙  After calling SE_stream_insert_table to identify which of the columns to insert, the application must set an explicit value for each named column with either SE_stream_bind_input_column or one of the SE_stream_set_* functions. Each named column must have a value (which is NULL by default) before the application calls SE_stream_execute.