ImportOdbcQuery Script Examples: Difference between revisions
Jump to navigation
Jump to search
(403051) |
No edit summary |
||
| Line 1: | Line 1: | ||
This page contains script examples for the [[ | This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery|ImportOdbcQuery]] 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. | 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. | ||
Revision as of 07:44, 7 February 2018
This page contains script examples for the ImportOdbcQuery 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