StartBackground Script Examples

From QPR ProcessAnalyzer Wiki
Revision as of 07:43, 7 February 2018 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

This page contains examples for the StartBackground command.

The following example will first show a "Starting SAP import" message in the user interface, then run an import from SAP that is executed in client side, then enter the background execution mode and then create a new model based on the extracted data.

Print 'Starting SAP import'

(SELECT 'SapAppServerHost', '127.0.0.1') UNION ALL
(SELECT 'SapSystemNumber', '10') UNION ALL
(SELECT 'SapUser', 'qpr') UNION ALL
(SELECT 'SapPW', 'demo') UNION ALL
(SELECT 'SapRouter', '') UNION ALL
(SELECT 'SapClient', '200') UNION ALL
(SELECT 'SapLanguage', 'EN') UNION ALL
(SELECT 'SapPoolSize', '5') UNION ALL
(SELECT 'SapPeakConnectionsLimit', '10') UNION ALL
(SELECT 'SapConnectionIdleTimeout', '600') UNION ALL
(SELECT 'ExecuteInClientSide', '1') UNION ALL
(SELECT 'DataTargetName', 'SAPDATA') UNION ALL
(SELECT 'Append', '0') UNION ALL
(SELECT 'SapWhereClause', 'VBELN BETWEEN `0060000039` AND `0060000041`') UNION ALL
(SELECT 'SapQueryTable', 'VBAK')
--#ImportSapQuery

(SELECT 'Enabled', 'TRUE')
--#StartBackground


(SELECT 'AnalysisType', '18') UNION ALL 
(SELECT 'DataTableName', 'SAPDATA') UNION ALL 
(SELECT 'TargetTable', '#SAPDATA') 
--#GetAnalysis

(SELECT 'ModelName', 'NewModel');
(SELECT * from #SAPDATA;
--#ImportEvents