NEXT_DATABASE function [System]

Returns the next database ID number, or the first database if the parameter is NULL.

NEXT_DATABASE ( { NULL | database-id } )

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

NEXT_DATABASE can be used to enumerate the databases running on a database server. To get the first database pass NULL; to get each subsequent database, pass the previous return value. The function returns NULL when there are no more databases.