|
<< Click to Display Table of Contents >> QU-F Query Executor |
  
|
|
<< Click to Display Table of Contents >> QU-F Query Executor |
|
QU-F Query Executor
Purpose of Program
Use this program to launch SQL Queries with variables as defined in DE-A SQL Query/Export. This enables an administrator to develop data queries with variables such as a date range and then users with access to this program can execute the queries entering the values for the variables without having access to the full query wizard. This program requires that JDBC settings have been defined at SM-T Enter Java Settings.
General Program Operation
Click the drop down to see the list of available queries. Enter the variables as prompted and click Execute. The results will display in a window with an option to Export to CSV which will open them in the default program associated with CSV files (typically Excel)