Changes to global variables

Global variables in default statements

You can now use global variables in default clauses. For example:

create table foo (c1 int, c2 int default @@spid)

NULL values for @@servername

Earlier versions of Adaptive Server allowed you to use a NULL value for @@servername with monitoring tables. With Adaptive Server 12.5.2, @@servername cannot be NULL when you are using monitoring tables, sp_sysmon cache wizard, or sp_monitor.

If you do issue any of these commands with @@servername set to NULL, Adaptive Server issues error message 5629, “remote distributed transaction participant cannot be started.” If this occurs:

1. Define a local server name with sp_addserver.

2. Restart the server.

You must also perform these steps if you are using the Real Time Messaging Services option. See the Real Time Messaging Service User’s Guide for more information.

Copyright © 2005. Sybase Inc. All rights reserved.

View this release bulletin as PDF