Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases.
DataBlade® API Function ReferenceThe HCL OneDB™ DataBlade® API Function Reference describes the DataBlade® API functions and the subset of functions that the DataBlade® API supports.
Function descriptionsThis section gives comprehensive reference information about the functions that are valid within DataBlade® API modules. It lists the function descriptions in alphabetical order, with syntax, usage information, and return values for the functions.
The mi_get_dbnames() functionThe mi_get_dbnames() function retrieves the names of all databases available on the database server, corresponding to the logged-in connection.

The mi_get_dbnames() function

The mi_get_dbnames() function retrieves the names of all databases available on the database server, corresponding to the logged-in connection.

Syntax

mi_integer mi_get_dbnames(conn, dbnameps, dbnamepssize, dbnamesb, dbnamesbsize)
   MI_CONNECTION *conn;
   char *dbnameps[];
   mi_integer dbnamepssize;
   char *dbnamesb;
   mi_integer dbnamesbsize;

conn: A pointer to a connection descriptor established by a previous call to mi_open(), mi_server_connect(), or mi_server_reconnect().
dbnameps: contains pointers to database names.
dbnamepssize: The size of dbnameps.
dbnamesb: A pointer to the result list of database names.
dbnamesbsize: The size of dbnamesb.


Valid in client LIBMI application?	Valid in user-defined routine?
Yes	No

Usage

The mi_get_dbnames() function copies database names into dbnamesb (up to dbnamesbsize) and copies database-name pointers into dbnameps (up to dbnamepssize). The user allocates dbnamesb and dbnameps.

If the connection is not logged in, this function retrieves the names of databases available on $INFORMIXSERVER. If the connection is not provided (conn argument is NULL), this function retrieves the names of databases on all database servers.

Return values

>=0: The number of retrieved database names.
MI_ERROR: The function was not successful.