schema objects api comparison


Home \| Concepts \| API \| Samples

API > API Comparison

Schema Objects API Comparison

Table Management Functions (+/-)

C	Java	Description
	SeTable
SE_table_free_lock	freeLock()	Frees the locks on a table.
SE_table_free_locks	NA	Frees an array of SE_TABLE_LOCK objects.
SE_table_get_locks	getLocks()	Returns a list of locks on a table.
SE_table_lock	lock()	Locks a table.
SE_table_add_rowlocks	addRowLocks()	Adds an array of locks to the lock table.
SE_table_get_rowlocks	getRowLocks()	Return locks for a registered table as arrays of row_id and user_name.
SE_table_get_rowlocks_by_user	getRowLocksByUser()	Given user name, return locks for a registetered table as an array of row_id.
SE_table_free_rowlocks_list	NA	Free row_id and user_name arrays from SE_table_get_rowlocks_by_user or SE_table_get_rowlocks.
SE_table_remove_rowlocks	removeRowLocks()	Removes an array of locks from the lock table.
SE_table_add_column	addColumn()	Adds a new column to a table.
SE_table_alter_column	alterColumn()	Alters settings for a column; what can be changed depends on the DBMS.
SE_table_add_locator	Not Implemented()	Adds a locator to a table.
SE_table_add_rowlocks	addRowLocks()	Adds row locks to a table.
SE_table_calculate_stats	calculateStats()	Generates statistics for a table.
SE_table_create	create()	Creates a DBMS table.
SE_table_create_index	createIndex()	Creates a DBMS index.
SE_table_create_indexes	createIndexes()	Creates DBMS indexes.
SE_table_rebuild_index	rebuildIndex()	Rebuilds DBMS indexes.
SE_table_create_mw_view	createMultiVersionView()	Creates a multiversion table view.
SE_table_create_view	createView()	Creates a table view.
SE_table_delete	delete()	Drops a DBMS table.
SE_table_delete_constraint	deleteConstraint()	Deletes the named constraint from the specified table.
SE_table_delete_index	deleteIndex()	Drops a DBMS index.
SE_table_delete_mv_view	deleteMultiVersionView()	Deletes a multiversion table view.
SE_table_delete_locator	Not Implemented()	Deletes a locator from a table.
SE_table_describe	describe()	Returns the column definitions of a DBMS table.
SE_table_describe_indexes	describeIndexes()	Returns the index definitions of a DBMS table.
SE_table_drop_column	dropColumn()	Deletes a column from a table.
SE_table_free_descriptions	NA	Frees column description resources allocated by SE_table_describe.
SE_table_free_index_descriptions	NA	Frees index descriptions allocated by SE_table_describe_indexes.
SE_table_free_list	NA	Frees an array of table names allocated from SE_table_list.
SE_table_free_lock	freeLock()	Frees the locks on a table.
SE_table_free_locks	NA	Frees an array of locks.
SE_table_free_rowlocks_list	NA	Frees an array of rowlock IDs.
SE_table_free_stats	NA	Releases the memory used by an SE_STATS structure.
SE_table_get_locator	Not Implemented()	Returns the locator IDs for a table.
SE_table_get_locks	getLocks()	Returns a list of locks on a table.
SE_table_get_permissions	getPermissions()	Returns the permissions for a given table.
SE_table_get_rowlocks	getRowLocks()	Returns the row locks on a table.
SE_table_get_rowlocks_by_user	getRowLocksByUser()	Returns the row locks on a table set by a user.
SE_table_grant_access	grantAccess()	Grants a user access to a given table.
SE_table_lock	lock()	Locks a table.
SE_table_make_qualified_name	SeTable constructors, getQualifiedName()	Constructs a qualified name for a specific RDBMS.
SE_table_metadata_add	addMetaData()	Adds meta-data to a table.
SE_table_metadata_alter	alterMetaData()	Changes the meta-data associated with a table.
SE_table_metadata_delete	deleteMetaData()	Removes meta-data from a table.
SE_table_metadata_delete_where	deleteMetaDataByWhere()	Removes meta-data from a table using a where clause.
SE_table_metadata_free_info_list	NA	Frees a list of meta-data.
SE_table_metadata_get_info_list	getMetaDataInfoList()	Returns a list of meta-data from a table.
SE_table_parse_qualified_name	SeTable constructors, getDatabase(), getOwner(), getName()	Parses a qualified name for a DBMS.
SE_table_rematch()	rematch()	Rematches result of SE_table_locate
SE_table_remove_rowlocks	removeRowLocks()	Removes row locks from a table.
SE_table_rename	rename()	Changes the name of a table.
SE_table_revoke_access	revokeAccess()	Removes a user's access to a given table.
SE_table_truncate	truncate()	Deletes the data from a table but keeps the table definition.
SE_table_update_dbms_stats	updateDBMSStats()	Updates the DBMS statistics for a given table.
	SeConnection
SE_table_list	getTables(), getList()	Generates a list of tables with the given permissions.
	SeLocator
SE_table_locate	locateTable()	Locates table of addresses
	SeRegistration
SE_registration_alter	alter()	Changes a registration entry.
SE_registration_create	create()	Creates a new registration entry.
SE_registration_delete	delete()	Deletes a registration entry.
SE_registration_free_info_list	NA	Releases memory allocated for a list of registrations.
SE_registration_get_difference_list	getDifferenceList()	Retrieves an array of SE_REGINFO structures for all accessible versions.
SE_registration_get_info	getInfo()	Retrieves a registration definition.
SE_registration_get_info_by_id	SeRegistration constructor 2	Retrieves a registration entry by ID.
SE_reginfo_allow_rowlocks	allowRowLocks()	Returns TRUE if rowlocking is enabled.
SE_reginfo_create	SeRegistration constructors	Creates a new SE_REGINFO object.
SE_reginfo_duplicate	clone()	Copies a SE_REGINFO entry.
SE_reginfo_free	NA	Releases memory allocated for an SE_REGINFO structure.
SE_reginfo_get_access	getAccess()	Retrieves the privilege bitmask for a registered table.
SE_reginfo_get_creation_keyword	getCreationKeyword()	Retrieves the registered table's configuration keyword.
SE_reginfo_get_description	getDescription()	Retrieves the registered table's description.
SE_reginfo_get_id	getId()	Retrieves the ID of a registered table.
SE_reginfo_get_mv_view	getMvViewName()	Retrieves the multiversion view of a registered table.
SE_reginfo_get_minimum_id	getMininumId()	Retrieves the minimum ID allowed for the registered table.
SE_reginfo_get_reg_date	getRegistrationDate()	Retrieves the registration date of a table.
SE_reginfo_get_rowid_allocation	getRowIdAllocation()	Retrieves the SDE-maintained rowed allocation method
SE_reginfo_get_rowid_column	getRowIdColumnName()	Retrieves the row ID column name for a registered table.
SE_reginfo_get_table_name	getTableName()	Retrieves the table name for a registered table.
SE_reginfo_has_layer	hasLayer()	Returns TRUE if the registered table has a spatial column.
SE_reginfo_has_locator	hasLocator()	Returns TRUE if the registered table has a locator.
SE_reginfo_has_xml	hasxml()	Returns TRUE if the registered table has an xml column.
SE_reginfo_is_hidden	isHidden()	Returns TRUE if the registered table is hidden.
SE_reginfo_is_multiversion	isMultiVersion()	Returns TRUE if the registered table is a multiversioned table.
SE_reginfo_is_view	isView()	Returns TRUE if the registered table is a view.
SE_reginfo_set_creation_keyword	setCreationKeyword()	Sets the registered table's configuration keyword.
SE_reginfo_set_description	setDescription()	Sets the registered table's description.
SE_reginfo_set_hidden	setHidden()	Sets the hidden flag for a registered table.
SE_reginfo_set_locator	setLocator()	Sets the locator flag for a registered table.
SE_reginfo_set_minimum_id	setMinimumId()	Sets the minimum ID allowed for the registered table.
SE_reginfo_set_multiversion	setMultiVersion()	Sets the multiversion flag for a registered table.
SE_reginfo_set_rowlocks	setRowLocks()	Sets row locking to enabled or not enabled on a registered table.
SE_reginfo_set_rowed_allocation	setRowIdAllocation()	Sets how to allocate row Ids.
SE_reginfo_set_rowid_column	setRowIdColumnName()	Sets the row ID column name for a registered table.
SE_reginfo_set_table_name	setTableName()	Sets the table name for a registered table.
SE_reginfo_set_view	setView()	Sets the view flag for a registered table.
	SeConnection
SE_registration_get_info_list	getList(), getRegisteredTables()	Retrieves an array of SE_REGINFO structures for all accessible versions.

Layer Functions (+/-)

Top

C	Java	Description
	SeLayer
SE_layerinfo_create	SeLayer constructors	Creates an SE_LAYERINFO structure.
SE_layerinfo_duplicate	clone()	Copies an SE_LAYERINFO structure.
SE_layerinfo_free	NA	Releases memory allocated for an SE_LAYERINFO structure.
SE_layerinfo_get_access	getAccess()	Retrieves the privileges for the specified layer.
SE_layerinfo_get_array_size	getArraySize()	Retrieves the optimal array size for the specified layer.
SE_layerinfo_get_coordref	getCoordRef()	Retrieves the coordinate reference for the specified layer.
SE_layerinfo_get_creation_date	getCreationDate()	Retrieves the layer creation date.
SE_layerinfo_get_creation_keyword	getCreationKeyword()	Retrieves the configuration keyword.
SE_layerinfo_get_description	getDescription()	Retrieves the layers description.
SE_layerinfo_get_envelope	getExtent()	Retrieves the layers envelope.
SE_layerinfo_get_grid_sizes	getGridSizes()	Retrieves the spatial index grid sizes of the layer.
SE_layerinfo_get_id	getID()	Retrieves the layer ID.
SE_layerinfo_get_minimum_id	getMinID()	Retrieves the minimum feature id value.
SE_layerinfo_get_shape_types	getShapeTypes()	Retrieves the allowed shape types.
SE_layerinfo_get_spatial_column	getSpatialColumn()	Retrieves the table and column name of the layer.
SE_layerinfo_get_storage_type	getStorageType()	Returns the layer's storage type.
SE_layerinfo_has_anno	hasAnno()	Returns TRUE if the layer allows annotations.
SE_layerinfo_has_cad	hasCAD()	Returns TRUE if the layer allows CAD entities.
SE_layerinfo_has_spatial_index	hasSpatialIndex()	Returns TRUE if the layer has a spatial index.
SE_layerinfo_is_in_load_mode	isLoadOnly()	Returns TRUE if the layer is in load-only mode.
SE_layerinfo_is_measured	isMeasured()	Returns TRUE if the layer allows measures.
SE_layerinfo_is_storage_normalized	isStorageNormalized()	Returns TRUE if the layer's storage type is normalized.
SE_layerinfo_is_storage_sdebinary	isStorageSdeBinary()	Returns TRUE if the layer's storage type is the ArcSDE binary format.
SE_layerinfo_is_storage_sql	isStorageSQL()	Returns TRUE if the layer's storage type is SQL or well-known text.
SE_layerinfo_is_storage_wkb	isStorageWKB()	Returns TRUE if the layer's storage type is well-known binary.
SE_layerinfo_is_3D	is3D()	Returns TRUE if the layer allows z-coordinates.
SE_layerinfo_set_anno	setAnno()	Sets whether the layer allows annotations.
SE_layerinfo_set_array_size	setArraySize()	Sets the optimal array size for the specified layer.
SE_layerinfo_set_cad	setCAD()	Sets whether the layer allows CAD entities.
SE_layerinfo_set_coordref	setCoordRef()	Sets the coordinate reference for the specified layer.
SE_layerinfo_set_creation_keyword	setCreationKeyword()	Sets the configuration keyword.
SE_layerinfo_set_description	setDescription()	Sets the layers description.
SE_layerinfo_set_envelope	setExtent()	Sets the layers envelope.
SE_layerinfo_set_grid_sizes	setGridSizes()	Sets the spatial index grid sizes of the layer.
SE_layerinfo_set_load_mode	setLoadMode()	Sets the layer to either load-only or normal I/O mode.
SE_layerinfo_set_measured	setMeasured()	Updates whether the layer allows measures.
SE_layerinfo_set_minimum_id	setMinID()	Sets the minimum feature id value.
SE_layerinfo_set_shape_types	setShapeTypes()	Sets the allowed shape types.
SE_layerinfo_set_spatial_column	setSpatialColumnName()	Sets the spatial column name of the layer.
SE_layerinfo_set_storage_type	setStorageTypes()	Sets the layer's storage type.
SE_layerinfo_set_3D	set3D()	Updates whether the layer allows z-coordinates.
SE_layer_alter	alter()	Changes a layer's characteristics.
SE_layer_calculate_extent	calculateExtent()	Returns the extent of the features in the layer.
SE_layer_create	create()	Spatially enables an existing table.
SE_layer_delete	delete()	Deletes a layer.
SE_layer_free_info_list	NA()	Releases memory allocated for a list of layer structures.
SE_layer_free_lock	freeLock()	Releases the locks placed on a layer.
SE_layer_free_locks	NA	Releases memory allocated for the list of locks returned by SE_layer_get_locks.
SE_layer_get_info	getInfo()	Retrieves information about the specified table and column.
SE_layer_get_info_by_id	SeLayer constructor 2	Retrieves information about the specified layer by ID.
SE_layer_get_locks	getLocks()	Retrieves information on the locks set on a layer.
SE_layer_get_si_statistics	getSpatialIndexStats()	Retrieves information on the spatial index grids.
SE_layer_get_statistics	getStatistics()	Retrieves statistical information on a layer.
SE_layer_grant_access	grantAccess()	Allows layer owner to grant privileges to other users.
SE_layer_lock	lock()	Locks an entire layer.
SE_layer_lock_area	lockArea()	Locks the specified area for a given layer.
SE_layer_modify_lock	modifyLock()	Modifies an already established lock.
SE_layer_revoke_access	revokeAccess()	Allows layer owner to revoke privileges for other users.
SE_layer_shape_attribute_name	getShapeAttributeName()	Returns a column name for a specified shape attribute.
SE_layer_truncate	truncate()	Removes spatial data from a table.
	SeConnection
SE_layer_get_info_list	getList(), getLayers()	Returns an array of SE_LAYERINFO pointers for all layers.

Streams and Queries Functions (+/-)

Top

C	Java	Description
	SeInsert
SE_blob_free	NA	Frees a blob's memory
SE_clob_free	NA	Frees memory held in a SE_CLOB_INFO structure.
SE_nclob_free	NA	Frees memory held in a SE_NCLOB_INFO structure
SE_stream_close	SeInsert.close(), SeStreamOp.close(), SeUpdate.close()	Cancels the current stream operation.
SE_stream_create	NA	Creates a stream between the client and server
SE_stream_execute	SeStreamOp.execute()	Executes an initialized stream
SE_stream_flush_buffered_writes	SeStreamOp.flushBufferedWrites()	Forces any buffered writes to post on the server
SE_stream_free	NA	Deletes a stream
SE_stream_bind_input_column	NA	Binds a column to an input data location for inserting a row.
SE_stream_set_blob	SeRow.setBlob()	Sets the value for a blob column
SE_stream_set_clob	SeRow.setClob()	Sets the value for a clob column
SE_stream_set_date	SeRow.setTime()	Sets the value for a date column
SE_stream_set_double	SeRow.setDouble()	Sets the value for a double-precision column
SE_stream_set_dynamic_bind	SeRow.fromTableWithDynamicBind(), SeDelete.fromTableWithDynamicBind()	Binds parameter in the WHERE clause
SE_stream_set_float	SeRow.setFloat()	Sets the value for a single-precision float column
SE_stream_set_int64	NA	Sets the value for a 64-bit integer column
SE_stream_set_integer	SeRow.setInteger()	Sets the value for an integer column
SE_stream_set_nclob	SeRow.setNClob()	Sets the value for a Unicode CLOB column
SE_stream_set_nstring	SeRow.setNString()	Sets the value for a Unicode string column
SE_stream_set_shape	SeRow.setShape()	Sets the value for a shape column
SE_stream_set_smallint	SeRow.setShort()	Sets the value for a small integer column
SE_stream_set_string	SeRow.setString()	Sets the value for a string column
SE_stream_set_uuid	SeRow.setUuid()	Sets the value for a UUID column
SE_stream_invoke_ssa	NA	Starts and configures a server-side application
SE_stream_set_ssa_filter	SeStreamOp.setSSAFilter()	Sets a server-side application filter on a stream
SE_stream_get_raster	SeRow.getRaster()	Gets raster column from the current row.
SE_stream_get_raster_tile	SeRow.getRasterTile()	Gets raster tile from the row.
SE_stream_last_inserted_raster_id	SeInsert.lastInsertedRasterId()	Retrieves the raster ID in the row most recently inserted.
SE_stream_query_raster_tile	SeQuery.queryRasterTile()	Initiates a query on a raster tile.
SE_stream_set_raster_constraint	SeQuery.setRasterConstraint()	Sets raster constraints.
SE_stream_describe_column	SeStreamOp.describeColumn()	Describes a specified column for the given stream.
SE_stream_get_connection	NA	Returns a stream's connection handle.
SE_stream_get_ext_error	SeError.getExtError()	Retrieves extended error information.
SE_stream_get_invalidshape_mode	SeQuery.getInvalidShapeMode()	Gets fetch_invalidshape mode for the stream.
SE_stream_in_progress	NA	Returns the status of the specified stream.
SE_stream_last_inserted_row_id	NA	Gets the row ID of the last inserted data.
SE_stream_num_result_columns	NA	Returns the number of columns for the current operation of the specified stream.
SE_stream_set_invalidshape_mode	SeQuery.setInvalidShapeMode()	Turns "fetch_invalidshape" mode on or off for a read stream.
SE_stream_set_output_coordref	NA	Sets the output coordinate reference of a stream operation.
SE_stream_set_rowlocking	SeStreamOp.setRowLocking()	Sets the row locking environment for a stream
SE_stream_set_write_mode	NA	Enables buffered inserts.
SE_stream_calculate_layer_extent	SeQuery.calculateLayerExtent()	Returns the envelope of a layer query.
SE_stream_calculate_layer_statistics	SeQuery.calculateLayerStatistics()	Returns statistics for a layer.
SE_stream_calculate_table_statistics	SeQuery.calculateTableStatistics()	Returns statistics for a table and column.
SE_stream_insert_into_file	NA	Prepares to insert a row into an external file.
SE_stream_locate_single	SeLocator.locateSingle()	Locates single address on a stream.
SE_stream_locate_table	SeLocator.locateTable() Deprecated	Locates (georeferences) a table.
SE_stream_copy_state_rows	SeUpdate.copyStateRows()	Copies rows from a differences state to the source state.
SE_stream_restore_rows	SeUpdate.restoreRows(), SeDelete.restoreRows()	Restores rows in a multiversion table to its original state.
SE_stream_restore_rows_from_ lineage_by_rowid	SeUpdate.restoreRowsFromLineageByRowId(), SeDelete.restoreRowsFromLineageByRowId()	Restores a set of rows.
SE_stream_set_state	SeStreamOp.setState()	Sets state constraints for a stream.
SE_stream_set_row	NA	Updates a single row based on the ID from the specified table.
SE_stream_update_ordered	NA	Prepares to update a set of rows.
SE_stream_update_row	SeUpdate.singleRow()	Prepares to update a row in a registered table.
SE_stream_update_sdodim_table	SeUpdate.toSdoDimTable()	Updates the lower and upper bounds of the SDODIM table
SE_stream_update_table	NA	Prepares to update rows in a table.
SE_stream_bind_output_column	NA	Binds a column to an output data location for fetching a row.
SE_stream_get_blob	SeRow.getBlob()	Gets a Binary Large Object (BLOB) column from the current row
SE_stream_get_clob	SeRow.getClob()	Gets a clob column from the row.
SE_stream_get_date	SeRow.getTime()	Gets a date column from the row
SE_stream_get_double	SeRow.getDouble()	Gets a double-precision column from the row.
SE_stream_get_float	SeRow.getFloat()	Gets a single-precision float column from the row.
SE_stream_get_int64	NA	Gets a 64-bit integer column from the row
SE_stream_get_integer	SeRow.getInteger()	Gets an integer column from the row
SE_stream_get_nclob	SeRow.getNClob()	Gets a Unicode CLOB column from the row.
SE_stream_get_nstring	SeRow.getNString	Gets a Unicode string column from the row
SE_stream_get_shape	SeRow.getShape()	Gets a shape column from the row.
SE_stream_get_smallint	SeRow.getShort()	Gets a small integer column from the row
SE_stream_get_string	SeRow.getString()	Gets a string column from the current row
SE_stream_get_uuid	SeRow.getUuid()	Gets a UUID column from the row
SE_stream_fetch	SeQuery.fetch(), SeSSA.fetch()	Fetches the next row on the specified stream.
SE_stream_fetch_row	SeQuery.fetchRow()	Retrieves a single row from a specific layer.
SE_stream_delete_by_id_list	SeDelete.byIdList()	Deletes rows from a table using a list of IDs.
SE_stream_delete_from_table	SeDelete.fromTable()	Deletes rows from a table using an SQL where clause
SE_stream_delete_row	NA	Deletes the specified row from a spatially enabled table based on the layer and feature identifiers.
SE_stream_delete_table	NA	Prepares to delete rows from table using a where clause.
SE_stream_insert_table	NA	Identifies columns to populate when inserting data into a DBMS table.
SE_sql_construct_alloc	NA	Allocates an SE_SQL_CONSTRUCT structure.
SE_sql_construct_free	NA	Frees an SE_SQL_CONSTRUCT structure.
SE_stream_prepare_sql	SeQuery.prepareSql()	Prepares an SQL statement for execution.
SE_stream_query	NA	Initiates a layer query.
SE_stream_query_from_file	NA	Initiates a query on an external file.
SE_stream_query_rowid_by_uuid	SeQuery.prepareQueryRowIdByUuid()	Gets a list of ArcSDE row ID values corresponding to a list of UUIDs.
SE_stream_query_with_info	NA	Initiates a query using an SE_QUERYINFO structure.
SE_stream_get_spatial_masks	NA	Returns the spatial filter masks for the current row
SE_stream_set_spatial_constraints	SeQuery.setSpatialConstraints()	Sets spatial constraints.
SE_stream_query_logfile	SeQuery.prepareQueryLogfile()	Initiates a query on a logfile.
SE_stream_set_logfile	NA	Sets the destination of stream operations to a logfile.
	SeQueryInfo
SE_queryinfo_create	NA	Creates an SE_QUERYINFO object.
SE_queryinfo_duplicate	NA	Duplicates an SE_QUERYINFO structure.
SE_queryinfo_free	NA	Frees an SE_QUERYINFO object.
SE_queryinfo_free_columns	NA	Frees a string array.
SE_queryinfo_free_tables	NA	Frees tables.
SE_queryinfo_get_by_clause	getByClause()	Retrieves the order by clause for a query.
SE_queryinfo_get_columns	getColumns()	Retrieves the columns for a query.
SE_queryinfo_get_entity_type	getEntityType()	Retrieves the entity type.
SE_queryinfo_get_logfile	getLogfile()	Retrieves the logfile for a query.
SE_queryinfo_get_query_type	getQueryType()	Retrieves the query type.
SE_queryinfo_get_tables	NA	Retrieves the tables for a query.
SE_queryinfo_get_where_clause	NA	Retrieves the where clause for a query.
SE_queryinfo_set_by_clause	setByClause()	Sets the order by clause for a query.
SE_queryinfo_set_columns	setColumns()	Sets the columns for a query
SE_queryinfo_set_entity_type	setEntityType()	Sets the entity type.
SE_queryinfo_set_logfile	setLogfile()	Sets the logfile for a query.
SE_queryinfo_set_query_type	setQueryType()	Sets the query type.
SE_queryinfo_set_tables	NA	Sets the tables for a query.
SE_queryinfo_set_xml_doc_property	setXmlDocProperty()	Sets the XML document property constraint in an SE_QUERYINFO structure.
SE_queryinfo_set_where_clause	NA	Sets the where clause for a query.
SE_queryinfo_set_xpath_constraint	setXpathConstraint()	Sets the XPath expression in a queryinfo structure.

feedback | privacy | legal