Seagate ST43401N/ND Instalační příručka stáhnout pdf (Strana 63)

CHAPTER 5 Implement: Making Required Application Changes

If a pattern match is found in the cell boundaries then the selectivity is

estimated to be the sum of the weights of all cells with a pattern match.

In either case the resulting selectivity estimate will be more accurate than in

previous versions.

This also applies to queries with

like clauses of the type like “_abc”, or like

“[ ]abc”

If Your Version is 11.5, 11.9.x, or 12.0

This section covers the following topics:

• Changes to Transact-SQL

• The enable xact coordination Configuration Parameter

• New Reserved Words

• Wide Columns and Data Truncation

Changes to Transact-SQL

In general, changes to existing Transact-SQL commands add options to them

and will not create a problem for applications where these changed commands

appear. In some cases ASE 12.5 allows you to specify new sizes for arguments

to commands. This is a result of the larger data sizes now available. If you

intend to use larger data sizes, check

What’s New in Adaptive Server Enterprise

at http://manuals.sybase.com:80/onlinebooks/group-

as/asg1250e/whatsnew/@Generic__BookView

for new size limits and other

changes to Transact-SQL.

The enable xact coordination Configuration Parameter

Non-DTM RPCs may fail initially on 12.0 and 12.5 when enable xact

coordination

is turned on. To prevent problems, turn this configuration

parameter off with

sp_configure.

Note This is expected to be fixed in subsequent releases of ASE 12.5.

1 2 ... 58 59 60 61 62 63 64 65 66 67 68 ... 145 146

Žádné komentáře

Seagate ST43401N/ND Instalační příručka Strana 63