ImportOdbcQuery Script Examples: Difference between revisions
Jump to navigation
Jump to search
(403051) |
(No difference)
|
Revision as of 07:30, 20 June 2016
This page contains script examples for the ImportDataTable script command.
The following script extracts data from an ODBC using a data source name configured as described in the How to Configure an ODBC Data Source Name for Connecting to QPR ProcessAnalyzer page and selects all columns from the table PA_MODEL.
(SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL (SELECT 'OdbcQueryString', 'SELECT * FROM PA_MODEL') UNION ALL (SELECT 'TargetTable', '#ImportOdbcTable') UNION ALL (SELECT 'Append', '1') --#ImportOdbcQuery