SQL Statement Changes

Sybase IQ version 15.3 includes changes to Interactive SQL.

• The ALTER DBSPACE statement has a new ALTER FILE FORCE READWRITE clause that changes the status of the specified shared temporary store dbfile to read-write. See Reference: Statements and Options > SQL Statements > ALTER DBSPACE.

• The ALTER LOGIN POLICY statement has a new LOGICAL SERVER clause that configures values of certain login policy options on a per logical server basis. Sybase IQ no longer supports the MULTIPLEX SERVER clause for login policies. See Using Sybase IQ Multiplex > Multiplex Reference > SQL Statements > ALTER LOGIN POLICY Statement.

• The following statements are new: ALTER LS POLICY, COMMENT ON LOGICAL SERVER, ALTER LOGICAL SERVER, CREATE LOGICAL SERVER, and DROP LOGICAL SERVER. See Using Sybase IQ Multiplex > Multiplex Reference > SQL Statements.

• Java support is now external to the database. The CREATE DATABASE clause JAVA { ON | OFF } and the ALTER DATABASE clauses JDK and REMOVE JAVA are no longer supported.

  Upgrade or change the version of the Java Development Kit (JDK)/Java Runtime Environment (JRE) installed on your system to change the version of Java used by Sybase IQ.

• The CREATE MULTIPLEX SERVER and ALTER MULTIPLEX SERVER statements now include a PRIVATE keyword to specify host and port pairs for private interconnections. A new PRIVATE NULL clause for ALTER MULTIPLEX SERVER clears the private_connection_info column for a server. See Using Sybase IQ Multiplex > Multiplex Reference > SQL Statements.

• The DROP MULTIPLEX SERVER statement has two new clauses – WITH DROP MEMBERSHIP and WITH DROP LOGICAL SERVER. See Using Sybase IQ Multiplex > Multiplex Reference > SQL Statements > DROP MULTIPLEX SERVER Statement.