sql_data_sources is used to get the list of datasources available to the dsn. It returns a vector of 2 element vectors containing Data source name and type pairs.
As defined in ODBC API for the corresponding catalog call.
As defined in ODBC API for the corresponding catalog call.
A vector containing a 2 element vector for each defined data source with a string data source name as 1st element and a string data source type as the 2nd element.
SQL> select aref (aref (sql_data_sources(), 0), 0); callret VARCHAR _______________________________________________________________________________ Local Virtuoso 1 Rows. -- 4 msec.
sql_columns sql_primary_keys, sql_gettypeinfo, sql_statistics, sql_tables.