SE_table_locate

Locates table of addresses.

Usage syntax

LONG SE_table_locate(
SE_CONNECTION connection,
SE_LOCATORINFO locator,
const CHAR *input_table,
const CHAR *where_clause,
LONG num_input_columns,
const CHAR **input_columns,
LONG num_key_columns,
const CHAR **key_columns,
LONG num_columns_to_copy,
const CHAR **columns_to_copy,
const CHAR *output_table,
const CHAR *config_keyword);

Parameters
handle Connection handle
locator The SE_LOCATORINFO handle of the locator to be used for locating the table.
input_table The name of the input table (table of addresses)
where_clause The selection condition to be applied for the records in the input table
num_input_columns The number of the input columns
input_columns An array of the input column names (columns in the input table to be used as locator inputs).
num_key_columns The number of the key columns
key_columns An array of the key column names. Values of these columns will be copied over to the output feature class and will be used to relate output records to the input records
num_columns_to_copy The number of the columns in the input table to be copied over to the output table
columns_to_copy An array of the names for columns to be copied over to the output feature class. These columns usually meant some custom information from the input table to be preserved in the output feature class
output_table The name of the output table (feature class)
config_keyword A configuration keyword entry from the dbtune table. Each keyword corresponds to a set of DBMS specific tuning parameters. Please refer the ArcSDE Configuration and Tuning guide for more information on setting up the dbtune parameters.
Description

This function creates an output layer as specified by output_table parameter, reads records selected using the where_clause from the input_table and processes them using the specified locator. The output table will have three sets of columns: locator output columns, key columns and the copied columns. Both key columns (specified by num_input_columns and key_columns parameters) and copied columns (specified by num_columns_to_copy and columns_to_copy parameters) are copied from the input table. Key columns have a special role of relating records from the output table to the corresponding input records. The number of input columns should match the number of locator inputs (see SE_locator_describe_inputs).

Returns

SE_SUCCESS
SE_INVALID_POINTER

SE_INVALID_PARAM_VALUE

SE_INVALID_LOCATOR_OBJECT_TYPE

SE_SSA_FUNCTION_ERROR

SE_DB_IO_ERROR

SE_INVALID_CONNECTION

SE_NET_FAILURE

SE_NO_PERMISSIONS

SE_TABLE_NOEXIST

SE_OUT_OF_CLMEM

SE_INVALID_LAYER_KEYWORD

SE_INVALID_LAYER_NAME

SE_SDE_NOT_STARTED