ImportOdbcQuery Script Examples: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
(403051)
No edit summary
Line 1: Line 1:
This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.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 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