Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Statement

Statement objects are used to run SQL commands on the data grid. Queries (SELECT statements) and data manipulation language (DML) SQL commands can be run by using Statement objects. Statement objects are created by invoking the createStatement() method on the Session object.

A Statement object is created for each individual SQL command. A Statement can be run multiple times and must be closed when it is no longer needed.

You can create a query by using the SELECT statement, update rows by using an INSERT or an INSERT OR REPLACE statement, or delete rows by using a DELETE statement.

The INSERT statement is supported for both, transacted and non-transacted sessions. For more information about INSERT statement, see The SQL INSERT Statement.

For more information about INSERT OR REPLACE statement, see The INSERT OR REPLACE Statement.

The DELETE statement is supported for non-transacted sessions only. For more information about the DELETE statement, see The SQL DELETE Statement.

Subtopics

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.