StartBackground Script Examples: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
(306662)
No edit summary
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This page contains examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23StartBackground|StartBackground]] command.
This page contains examples for the [[SQL Scripting Commands#--.23StartBackground|StartBackground]] command.


The following example will first show a "Starting SAP import" message in the user interface, and then run an import from SAP in the background.
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.
<pre>
<pre>
Print 'Starting SAP import'
Print 'Starting SAP import'
(SELECT 'Enabled', 'TRUE')
--#StartBackground


(SELECT 'SapAppServerHost', '127.0.0.1') UNION ALL
(SELECT 'SapAppServerHost', '127.0.0.1') UNION ALL
Line 18: Line 16:
(SELECT 'SapConnectionIdleTimeout', '600') UNION ALL
(SELECT 'SapConnectionIdleTimeout', '600') UNION ALL
(SELECT 'ExecuteInClientSide', '1') UNION ALL
(SELECT 'ExecuteInClientSide', '1') UNION ALL
(SELECT 'TargetTable', '#SAPmode1') UNION ALL
(SELECT 'DataTargetName', 'SAPDATA') UNION ALL
(SELECT 'Append', '0') UNION ALL
(SELECT 'Append', '0') UNION ALL
(SELECT 'SapWhereClause', 'VBELN BETWEEN `0060000039` AND `0060000041`') UNION ALL
(SELECT 'SapWhereClause', 'VBELN BETWEEN `0060000039` AND `0060000041`') UNION ALL
(SELECT 'SapQueryTable', 'VBAK')
(SELECT 'SapQueryTable', 'VBAK')
--#ImportSapQuery
--#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
</pre>
</pre>


[[Category:Examples]]
[[Category:Examples]]

Latest revision as of 20:58, 25 October 2021

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