Table 2-5 summarizes the changes to existing Transact-SQL commands.
Command |
Change |
---|---|
disk init |
Allows the following unit specifiers f or the device size: ‘k’ or ‘K’ (kilobytes), ‘m’ or ‘M’ (megabytes), and ‘g’ or ‘G’ (gigabytes) |
disk reinit |
Allows the following unit specifiers f or 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. |
alter table |
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:
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 255 bytes |
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 access rule |
Allows you to create a rule determining how a user connects to a server. |
union in view |
You are now allowed to use the union command in a view |