ImportOdbcQuery Script Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery|ImportOdbcQuery]] script command. | This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery|ImportOdbcQuery]] script command. | ||
The following script extracts data from an ODBC | The following script extracts data from an ODBC connection to QPR ProcessAnalyzer database and selects all columns from the table PA_MODEL. | ||
<pre> | <pre> | ||
(SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL | (SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL | ||
Revision as of 12:27, 13 November 2019
This page contains script examples for the ImportOdbcQuery script command.
The following script extracts data from an ODBC connection to QPR ProcessAnalyzer database 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