Deprecated features

This section lists deprecated features supported in the current software that will not be supported in release 15.0 of Sybase IQ. Changes in these features may affect existing applications.

Lists of deprecated features may be incomplete and are subject to change.

The following SQL statements and clauses are deprecated:

IQ local store for store type in the CREATE DBSPACE command.

RELOCATE clause in the ALTER DBSPACE command.

The STRIP ON clause of the LOAD TABLE statement has been deprecated. To continue stripping trailing blanks, use STRIP RTRIM instead. For details, see LOAD TABLE statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.

The following database options are deprecated:

Database options deprecated in Sybase IQ 15.0
Option name	Option name
ANSI_INTEGER_OVERFLOW	MIN_SMPDJ_OR_HPDJ_INDIRECT_SIZE
AUTO_COMMIT	MIN_SMPDJ_OR_HPDJ_FILTERED_PPM
AUTO_REFETCH	MIN_SMPDJ_OR_HPDJ_SIZE
AUTOMATIC_TIMESTAMP	MIN_SMPDJ_OR_HPDJ_SIZE
BELL	MPX_GLOBAL_TABLE_PRIV
CHAR_OEM_TRANSLATION	MPX_LOCAL_SPEC_PRIV
COMMAND_DELIMITER	MPX_OPTIONS
COMMIT_ON_EXIT	NULLS
CONVERT_HG_TO_1242	ON_ERROR
DESCRIBE_JAVA_FORMAT	OPTIMISTIC_WAIT_FOR_COMMIT
DISK_STRIPING	OPTIMIZATION_LOGGING
DISK_STRIPING_PACKED	OUT_OF_DISK_MESSAGE_REPEAT
DIVIDE_BY_ZERO_ERROR	OUT_OF_DISK_WAIT_TIME
ECHO	OS_OPTION_CRASH
ENABLED_ORDERED_PUSHDOWN_INSERTION	OUTPUT_FORMAT
ENABLE_THREAD_ALLOWANCE	OUTPUT_LENGTH
FLATTEN_SUBQUERIES	OUTPUT_NULLS
FLOAT_AS_DOUBLE	PARALLEL_GBH_ENABLED
HEADINGS	PARALLEL_GBH_MIN_ROWS_PER_UNIT
INPUT_FORMAT	PARALLEL_GBH_UNITS
IO_EXERCISER_PARAM_FILE	PERCENT_AS_COMMENT
IQMSG_LENGTH_MB	QUERY_PLAN_ON_OPEN
ISQL_COMMAND_TIMING	QUIET
ISQL_ESCAPE_CHARACTER	RETURN_JAVA_AS_STRING
ISQL_FIELD_SEPARATOR	RI_TRIGGER_TIME
ISQL_LOG	SCREEN_FORMAT
ISQL_PLAN	SORT_PHASE1_HELPERS
ISQL_PLAN_CURSOR_SENSITIVITY	STATISTICS
ISQL_PLAN_CURSOR_WRITABILITY	SQLCONNECT
ISQL_QUOTE	SQLSTART
JAVA_HEAP_SIZE	TEMP_KB_PER_STRIPE
JAVA_INPUT_OUTPUT	THREAD_COUNT
JAVA_NAMESPACE_SIZE	THREAD_STACK
JAVA_PAGE_BUFFER_SIZE	THREAD_SWAPS
LOCAL_KB_PER_STRIPE	TRUNCATE_WITH_AUTO_COMMIT
LOCAL_RESERVED_DBSPACE_MB	TRUNCATION_LENGTH
LOG_DETAILED_PLANS	TRUNCATE_DATE_VALUES
LOG_MAX_REQUESTS	TRUNCATION_LENGTH
MAIN_KB_PER_STRIPE	TSQL_HEX_CONSTANT
MAX_WORK_TABLE_HASH_SIZE	UUID_HAS_HYPHENS
MIN_NLPDJ_FILTERED_PPM	MAIN_CACHE_MEMORY_MB
MIN_NLPDJ_TABLE_SIZE	TEMP_CACHE_MEMORY_MB

Additional notes on deprecated database options:

The IQMSG_LENGTH_MB database option has been deprecated and must be removed from existing scripts and code. Attempts to use the IQMSG_LENGTH_MB option return an error. See “Message log management” for information on the new message log management feature.
The FLATTEN_SUBQUERIES option has been deprecated. For information on new subquery flattening options, see “Improved query performance”.
Deprecated options related to disk striping in releases prior to Sybase IQ 15.0: DISK_STRIPING, DISK_STRIPING_PACKED, MAIN_KB_PER_STRIPE, TEMP_KB_PER_STRIPE, LOCAL_KB_PER_STRIPE. To align your schema with storage, see “Migrating Data,” in the Installation and Configuration Guide.
MAIN_CACHE_MEMORY_MB and TEMP_CACHE_MEMORY_MB are removed. The IQ main and IQ temporary cache size settings are now server options only. If databases need to run with different cache sizes, change the option on the server using the stored procedure sa_server_option main_cache_memory_mb or temp_cache_memory_mb options. For example, instead of:
```
execute {set option
"PUBLIC".MAIN_CACHE_MEMORY_MB = 200}
```
use this:
```
execute {call sa_server_option
('main_cache_memory_mb',200)}
```
This command changes the option on a running engine before starting a database but cannot change the cache size on a running database. If two databases need to be run with different cache sizes, then set the option before starting each database.

If you set the cache sizes using the server startup -iqmc or -iqtc switches, the specified values are used for all databases started on that server unless the values are changed with an sa_server_option option. If the cache sizes are not specified, the default values apply.

For more information on setting IQ main and IQ temporary cache sizes and the use of the sa_server_option stored procedure, see “Setting IQ main and IQ temporary cache sizes”.

The following server startup option is deprecated:

-iqdroplks

To rebuild the free list at the dbspace level, use sp_iqcheckdb command with appropriate arguments instead.

See ”Compatibility views”in SQL Anywhere Server - SQL Reference.

The following stored procedure and stored procedure mode are deprecated:

sp_iqrelocate

To empty out all objects in a file within a dbspace, use the sp_iqemptyfile procedure. To relocate files, use ALTER TABLE MOVE and sp_iqemptyfile.
sp_iqcheckdb repair mode

A new mode dropleaks allows you to reset the allocation map for the entire database or a specified dbspace target.

The iq_bcp utility is deprecated. Sybase IQ 15.0 has a true client-side loader that supports the full functionality of the IQ LOAD TABLE command, including the ability to load BCP formatted text files. For more information, see “Direct loading of data from clients”.