Alphabetical list of functions
352
SELECT NEXT_CONNECTION( NULL )
The following statement returns a value like 1661140050.
SELECT NEXT_CONNECTION( 569851433 )
The following call returns the connection after connection-id on the current
database.
NEXT_CONNECTION( connection-id )
The following call returns the the connection after connection-id (regardless
of database).
NEXT_CONNECTION( connection-id, NULL )
The following call returns the connection after connection-id on the specified
database.
NEXT_CONNECTION( connection-id, database-id )
The following call returns the first connection (regardless of database).
NEXT_CONNECTION(NULL, NULL)
The following call returns the first connection on the specified database.
NEXT_CONNECTION( NULL, database-id )
NEXT_CONNECTION can be used to enumerate the connections to a
database. To get the first connection pass NULL; to get each subsequent
connection, pass the previous return value. The function returns NULL when
there are no more connections.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
NEXT_DATABASE function [System]
Returns an identifying number for a database.
NEXT_DATABASE ( { NULL |
database-id
} )
database-id An integer that specifies the ID number of the database.
The following statement returns the value 0, the first database value.
SELECT NEXT_DATABASE( NULL )
The following statement returns NULL, indicating that there are no more
databases on the server.
SELECT NEXT_DATABASE( 0 )
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples
To Next Page
Loading...