Browse Data Sources Flowchart

 <     >  Query Statements Browse Statements Browse Query Example Table of Contents

 

This flow chart shows the typical pattern for a single browse data-sources query using InstantSQL. Error handling is not shown in order to simplify the flow chart. An application should check for errors following each InstantSQL statement as shown in the status inquiry flow charts.

In contrast to most other InstantSQL statements, a connection to a data source is not necessary prior to browsing data sources. The data source names returned in the result set can be used in the SQL CONNECT DATASOURCE statement in order to connect to a data source found by browsing data sources.

The advanced statement SQL BIND COLUMN can be used to improve performance by eliminating the SQL GET DATA statement(s) for each row returned in the result set.

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