Returns the next database ID number, or the first database if the parameter is NULL.
NEXT_DATABASE ( { NULL | database-id } )
Parameter |
Description |
---|---|
database-id |
An integer that specifies the ID number of the database. |
INT
The following statement returns the value 0, the first database value:
SELECT NEXT_DATABASE( NULL ) FROM iq_dummy
The following statement returns NULL, indicating that there are no more databases on the server:
SELECT NEXT_DATABASE( 0 ) FROM iq_dummy