StartBackground Script Examples - Revision history

Ollvihe at 20:58, 25 October 2021

2021-10-25T20:58:29Z

← Older revision		Revision as of 20:58, 25 October 2021
Line 24:		Line 24:
	(SELECT 'Enabled', 'TRUE')		(SELECT 'Enabled', 'TRUE')
	--#StartBackground		--#StartBackground


	(SELECT 'AnalysisType', '18') UNION ALL		(SELECT 'AnalysisType', '18') UNION ALL

Ollvihe at 20:47, 25 October 2021

2021-10-25T20:47:29Z

← Older revision		Revision as of 20:47, 25 October 2021
Line 1:		Line 1:
	This page contains examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.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, 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.		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.

Ollvihe at 07:43, 7 February 2018

2018-02-07T07:43:47Z

← Older revision		Revision as of 07:43, 7 February 2018
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 [[QPR ProcessAnalyzer Scripting Commands#--.23StartBackground\|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.		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.

TeeLeht at 11:59, 14 September 2016

2016-09-14T11:59:56Z

← Older revision		Revision as of 11:59, 14 September 2016
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 [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.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]]

TeeHiet: 306662

2016-08-30T11:46:31Z

306662

← Older revision		Revision as of 11:46, 30 August 2016
Line 24:		Line 24:
	--#ImportSapQuery		--#ImportSapQuery
	</pre>		</pre>

			[[Category:Examples]]

TeeHiet: 306662

2016-08-30T11:45:20Z

306662

New page

This page contains examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.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.
<pre>
Print 'Starting SAP import'
(SELECT 'Enabled', 'TRUE')
--#StartBackground

(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 'TargetTable', '#SAPmode1') UNION ALL
(SELECT 'Append', '0') UNION ALL
(SELECT 'SapWhereClause', 'VBELN BETWEEN `0060000039` AND `0060000041`') UNION ALL
(SELECT 'SapQueryTable', 'VBAK')
--#ImportSapQuery
</pre>