Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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 a SELECT statement. Rows in a table can be updated by using an UPDATE, an INSERT, or an INSERT OR REPLACE statement. Rows can be removed from a table by using a DELETE statement.

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

For more information about the 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.

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

Subtopics

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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