Functions

New and changed functions for Adaptive Server 15.0

New functions

Function

Description

biginttohex

Returns the platform-independent hexadecimal equivalent of the specified integer

count_big

Returns the number of (distinct) non-null values or the number of selected rows as a bigint

datachange

Measures the amount of change in the data distribution since update statistics

data_pages

Returns the number of pages used by the specified table, index, or a specific

hextobigint

Returns the bigint value equivalent of a hexadecimal string

is_quiesced

Returns 1 if the database is quiesced and 0 if it is not.

partition_id

Returns the partition id of the specified data or index partition name.

partition_name

The explicit name of a new partition, partition_name returns the partition name

reserved_pages

Reports the number of pages reserved to a table, index or a specific partition.

row_count

Returns an estimate of the number of rows in the specified table.

showplan_in_xml

Returns the execution plan in XML.

ssel_message

Returns the message text when you specify a message ID.

tran_dumpable_status

Returns a true/false indication of whether dump transaction is allowed.

used_pages

Reports the number of pages used by a table, an index, or a specific partition.

xmlvalidate

Validates XML documents, including those containing non-ASCII characters (I18N). Described in XML Services.

Several function names have been replaced with more readable names.

Superceded functions with their new function names

Superceded function name

New function name

data_pgs

data_pages

used_pgs

used_pages

reserved_pgs

reserved_pages

rowcnt

row_count

ptn_data_pgs

data_pages