Adaptive Server Reference Manual: Commands

reorg

The reference page for reorg includes this incorrect note:

Replace with:

alter table

The Auditing section of the alter table reference page includes this bullet item, which is incorrect:

• If the with parameter contains set transfer table on, Adaptive Server prints this to extrainfo: SET TRANSFER TABLE ON. If the with parameter contains set transfer table off, Adaptive Server prints this to extrainfo: SET TRANSFER TABLE OFF.

create table

Add this text to the "Information in extrainfo" column of the Auditing section of the create table reference page:

• If the with option for with transfer table [on | off] is:
  • on – Adaptive Server prints WITH TRANSFER TABLE ON in the extra info in the audit record.
  • off – Adaptive Server prints WITH TRANSFER TABLE OFF.

dump database and dump transaction

There are two updates for dump database and dump transaction:

• The Parameters section of both dump database and dump transaction include the following:

  • compress:: compression_level is a number between 0 and 9, 100, or 101. For single-digit compression levels, 0 indicates no compression, and 9 provides the highest level of compression. Compression levels of 100 and 101 provide faster, more efficient compression, with 100 providing faster compression and 101 providing better compression. If you do not specify compression_level, Adaptive Server does not compress the dump.

  The 100 and 101 compression levels do not work with compress:: compression_level. Specifying these values causes the command to return an error.

  You may, however, continue to use 100 and 101 compression levels with the with compression= parameter.

• The maximum file path/name size for a physical device is 127 characters. This limitation is not explicitly stated in the Restrictions subsection of the Usage section of the reference pages for dump database and dump transaction.

execute

The Usage section includes this bullet item:

You cannot supply string and char_variable options to execute the following commands: begin transaction, commit, connect to, declare cursor, rollback, dump transaction, dbcc, set, use, or nested execute commands.

Adaptive Server currently uses a more relaxed list, which includes:

• use
• exec(< string >) – not the execute stored procedure
• connect
• begin transaction
• rollback
• commit
• dbcc

set

The definitions for the following set options should now read:

• set literal_autoparam on | off – is on by default. If the server-level setting for literal_autoparam is on, this option enables and disables use of that feature. If the server level setting is off, this setting has no effect.
• set statement_cache on | off – is on by default. If the server-level setting for statement_cache is on, this option enables and disables use of that feature. If the server level setting is off, this setting has no effect.

transfer table

Add the following information to the Usage section of the transfer table reference page:

When transfer table runs into an error (such as duplicate key), only the underlying error number is reported, but not the error message. This makes it difficult for a user to understand why the statement was aborted. For example:

Msg 2633, Level 20, State 1
Server 'SYB155', Line 1
TRANSFER TABLE failed to insert a row to table 'my_tab'. The indicated error was 2601.
Msg 16025, Level 16, State 1
Server 'SYB155', Line 1
TRANSFER TABLE my_tab: command failed with status 2633.

To retrieve the error message, manually query master..sysmessages. For example, if 2601 is your error number, enter:

select * from master..sysmessages where error = 2601

See the Troubleshooting Guide for more information about error 2601.