Generating and executing SQL queries
To test SQL access to your data, generate and execute a SQL query from an existing virtual table or virtual view.
Before you begin
To avoid fetching large result sets that are memory intensive, the Data Virtualization Manager studio provides settings related to SQL generation and retrieval that can limit the amount of data that is actually retrieved for a particular query execution. For more information, see SQL preferences.
[PARENT
TABLE].BASE_KEY = [CHILD TABLE].PARENT_KEY
) when joining the parent table with a child
subtable, since this will result in a table scan of the entire Adabas file. It is recommended
instead to use the CHILD_KEY (for example, [PARENT TABLE].CHILD_KEY = [CHILD
TABLE].PARENT_KEY
).Procedure
Results
- Double-click a row to view additional details about that row.
- Select the Export Result Set view option to export the SQL results to a .csv file.
- Click SQL Messages to view query-related system messages.
By default, if a result set includes 25 or more columns, each set of 25 columns are displayed incrementally as groups. You can choose which group you want to view using the Columns Group field. You can set the number of columns that you want to include in each group, ranging from 25-200, in the Columns per group field.
To change how SQL results display in the SQL Results view, see Data Virtualization Manager preferences.
What to do next
- Modify the SQL to meet your needs
- Execute the SQL to test and view the resulting data
- Create virtual views to join data or include missing columns
- Generate a SQL class to get access to data from your programs or applications