c-treeSQL API Function Descriptions

This document lists the c-treeSQL API Functions with a brief explanation of each function.

ALTER INDEX Alters an existing index by passing attributes to change to the underlying storage system.

ALTER TABLE Alters the schema of an existing table by adding new columns or modifying existing columns of the specified table.

CALL Invokes a built-in SQL procedure or Java stored procedure (JSP).

COMMIT WORK Used to commit a transaction explicitly after executing one or more SQL statements.

CONNECT Establishes a connection to a database.

CREATE INDEX Creates an index on the specified table using the specified col- umns of the table.

CREATE PROCEDURE Creates a stored procedure.

CREATE SYNONYM Creates a synonym for the table, view or synonym specified.

CREATE TABLE Creates a table definition.

Column Constraints Specifies a constraint for a column that restricts the values that the column can store.

Table Constraints Specifies a constraint for a table that restricts the values that the table can store.

CREATE TRIGGER Creates a trigger for the specified table.

CREATE VIEW Creates a view with the specified name on existing tables and/or views.

DELETE Deletes zero, one or more rows from the specified table that satisfy the search condition specified in the WHERE clause.

DISCONNECT Terminates the connection between an application and a database environment.

DROP INDEX Deletes an index on the specified table.

DROP PROCEDURE Deletes a stored procedure.

DROP SYNONYM Drops the specified synonym.

DROP TABLE Deletes the specified table.

DROP TRIGGER Deletes a trigger.

DROP VIEW Deletes the view from the database.

GET DIAGNOSTICS Retrieves information about the execution of the previous SQL statement.

GRANT Grants various privileges to the specified users for the database.

INSERT Inserts new rows into the specified table/view.

RENAME Renames the specified table name, view name or synonym to the new name specified.

REVOKE Revokes various privileges to the specified users for the database.

ROLLBACK WORK Ends the current transaction and undoes any database changes performed during the transaction.

SELECT Selects the specified column values from one or more rows contained in the table(s) specified in the FROM clause.

ORDER BY CLAUSE Specifies the sorting of rows retrieved by the SELECT state- ment.

SET CONNECTION Sets the database associated with the connection name as the current database.

SET TRANSACTION ISOLATION Explicitly sets the isolation level for a transac- tion.

SET SCHEMA specifies a new default qualifier for database object names.

UPDATE Updates the columns of the specified table with the given values that sat- isfy the search_condition.

UPDATE STATISTICS Queries system tables and updates table and column statis- tics.