InstantSQL Browse Statements

Browse Statements

< > Browse Query Example Browse Data Sources Flow Chart Browse Types/Tables/Columns/etc. Flow Chart Table of Contents

InstantSQL provides facilities for finding the names and descriptions of available data sources. Facilities to determine the structure of an available data source are also provided.

InstantSQL provides the following browse statements:

Statement	Purpose
SQL QUERY DATASOURCES	List all available data sources.
SQL QUERY TYPES	List all data types supported by a data source.
SQL QUERY TABLES	List all tables in a data source.
SQL QUERY COLUMNS	List all columns in a table or tables.
SQL QUERY INDEXES	List all indexes in a table.
SQL QUERY PROCEDURES	List all procedures in a data source.
SQL QUERY PROCEDURE-COLUMNS	List all procedure columns of a procedure or procedures.

The browse query for available data sources is the only query that does not require a connected data source. All browse queries for a particular data source require that the data source be connected. The results from the queries will typically only list the items the user name specified in the connection has access to, although this will be dependent upon the type of data source and its driver.

Each of the browse queries returns a result set. The result set for each browse query is described in the help file topic for that browse statement. The rows for the result set are fetched with the SQL FETCH ROW statement. The SQL GET DATA statement can be used to transfer the data from the fetched row to COBOL data items, or the SQL BIND COLUMN statement can be used so that the data is transferred to bound COBOL data items as part of the row fetch operation.

Click here for a Browse Query Example