ImportOdbcQuery Script Examples

From QPR ProcessAnalyzer Wiki
Revision as of 07:30, 20 June 2016 by TeeHiet (talk | contribs) (403051)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "https://wiki.onqpr.com/pa/index.php?title=ImportOdbcQuery_Script_Examples&oldid=2891"