Changed Transact-SQL commands

Table 7 summarizes the changes to existing Transact-SQL commands.

Table 7: Changed commands

Command

Change

disk init

Allows the following unit specifiers for the device size: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes)

disk reinit

Allows the following unit specifiers for the device size: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes)

create table

Supports the new size_in_bytes parameter, which allows you to specify the size of an in-row Java-SQL column.

create database

Allows the following unit specifiers f or the device size: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes)

alter database

Allows the following unit specifiers f or the device size: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes)

set

You can update as many as 1024 columns in the set clause using literals, variables, or expressions returned from a subquery

select...for browse

You cannot use the select...for browse option on tables containing more than 255 columns

select select_list into...at pathname

Allows you to specify a proxy table as the target of a select into command. The at indicates that the new table is a proxy table.

compute

If a compute clause includes a group by clause:

  • The compute clause cannot contain more than 127 aggregates.

  • The group by clause cannot contain more than 255 columns.

Columns included in a compute clause cannot be longer than 255 bytes.

like

The character string indicated by the like keyword cannot be longer than the column length. The maximum column length is 16K.

declare cursor

You can include as many as 1024 columns in an update clause of a client’s declare cursor statement

+ operator

Returns result strings up to a length of 16384 bytes

dump database

Includes compression syntax for making a compressed dump

load database

Includes compression syntax for loading a compressed dump

dump transaction

Includes compression syntax for making a compressed dump

load transaction

Includes compression syntax for loading a compressed dump

print statement

The total length of the format string + the output cannot exceed 1K. However, Adaptive Server does not issue an error message if you exceed this length.

create procedure (SQLJ)

Creates a SQLJ stored procedure, which is a Java method with a SQL name. Adaptive Server executes a SQLJ stored procedure in the same way it executes a Transact-SQL stored procedure.

create function (SQLJ)

Creates a user-defined function by adding a SQL wrapper to a Java static method. Can return a value defined by the method.

create access rule

Allows you to create a rule determining what data a user can access.

union in view

You are now allowed to use the union command in a view


New global variables

Adaptive Server version 12.5 adds the following global variables:


Changed global variables

The internal global variabe, @@pagesize has changed to display the virtual page size.