SQLLIST() Function - List SQL Sources

Syntax

SQLLIST(arg{,ERR=lineref})

Description

For BBj-specific information, see SQLLIST() Function - List SQL Sources BBj.

The SQLLIST() function returns the names of the available databases in the SQL system, with each item terminated by a linefeed. These are normally set up through the SQL configuration file (sql.ini). or through ODBC access in Windows, through the Windows ODBC Administrator. The arg parameter must be 0.

Attempting to use this function with an error branch on a platform that does not support SQL will generate an !ERROR=151 and go to the READY prompt instead of taking the error branch.

Examples

>LET LIST$=SQLLIST(0)
>PRINT LIST$
TAOS Demo Data
Chile Company Data

See Also

Functions - Alphabetical Listing