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

© Copyright 2000-2020 Micro Focus or one of its affiliates.