SQL statement syntax changes

ALTER TEXT CONFIGURATION

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ > SQL Statement Support > ALTER TEXT CONFIGURATION statement.

ALTER TEXT INDEX

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ > SQL Statement Support > ALTER TEXT INDEX statement.

CREATE DATABASE

Syntax has been enhanced to specify the user name for the single usable user ID with DBA authority created with a new database. See Reference: Statements and Options > SQL Statements > CREATE DATABASE statement.

CREATE TEXT CONFIGURATION

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ > SQL Statement Support > CREATE TEXT CONFIGURATION statement.

CREATE PROCEDURE

New SQL SECURITY INVOKER | DEFINER clauses. These clauses are inherited from SQL Anywhere (see “Utility enhancements”). See Reference: Statements and Options > SQL Statements > CREATE PROCEDURE statement.

CREATE TEXT INDEX

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ> SQL Statement Support > CREATE TEXT INDEX statement.

DROP TEXT CONFIGURATION

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ > SQL Statement Support > DROP TEXT CONFIGURATION statement.

DROP TEXT INDEX

New statement to support full-text searching. See Unstructured Data Analytics in Sybase IQ > SQL Statement Support > DROP TEXT INDEX statement.

GRANT

New syntax to support granular authorities. See Reference: Statements and Options > SQL Statements > GRANT statement.

LOAD TABLE

BLOCK FACTOR, BLOCK SIZE, and UNLOAD FORMAT clauses have been deprecated.

REVOKE

New syntax to support granular authorities. See Reference: Statements and Options > SQL Statements > REVOKE statement.

SELECT

New INTO TEMPORARY TABLE clause. This clause is inherited from SQL Anywhere (See “Utility enhancements”). See Reference: Statements and Options > SQL Statements > SELECT statement.