Exit Script Examples - Revision history

Ollvihe at 20:49, 25 October 2021

2021-10-25T20:49:17Z

← Older revision		Revision as of 20:49, 25 October 2021
Line 1:		Line 1:
	This page contains script examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.23Exit\|Exit]] script command.		This page contains script examples for the [[SQL Scripting Commands#--.23Exit\|Exit]] script command.
	<br/>		<br/>
	<br/>		<br/>

Ollvihe at 08:19, 7 February 2018

2018-02-07T08:19:59Z

← Older revision		Revision as of 08:19, 7 February 2018
Line 1:		Line 1:
	This page contains script examples for the [[~~Supported_QPR_ProcessAnalyzer_Commands_in_Scripts~~#--.23Exit\|Exit]] script command.		This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23Exit\|Exit]] script command.
	<br/>		<br/>
	<br/>		<br/>

TeeLeht at 06:47, 12 August 2016

2016-08-12T06:47:12Z

← Older revision		Revision as of 06:47, 12 August 2016
Line 35:		Line 35:
	(SELECT 'RunScriptId', @ScriptToRun)		(SELECT 'RunScriptId', @ScriptToRun)
	--#Exit		--#Exit
			</pre>

			The following example script stops the execution of the current script if the script has been last modified more than 600 seconds ago
			<pre>
			(SELECT 'AnalysisType', '24') UNION ALL
			(SELECT 'TargetTable', '#ScriptAnalysis')
			--#GetAnalysis

			(SELECT 'Exit', IIF((DATEDIFF(ss,[Last Modified On],GETDATE()) > 600),1,0) FROM #ScriptAnalysis where [Id] = @_ScriptId)
			--#Exit
	</pre>		</pre>


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

TeeHiet: 403051

2016-06-20T06:22:55Z

403051

New page

This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23Exit|Exit]] script command.
<br/>
<br/>
The Exit command can in effect be used to "call" a script, i.e. run a different script and then return to continue the current script.
<pre>
(SELECT 'Exit', '0') UNION ALL
(SELECT 'RunScriptId', '12')
--#Exit
</pre>

The Exit command can also be used to "goto" a script, i.e. stop the execution of the current script and run a different script.
<pre>
(SELECT 'Exit', '1') UNION ALL
(SELECT 'RunScriptId', '12')
--#Exit
</pre>

The following example stops the script execution, gives a message, and runs a script with Id 12.
<pre>
(SELECT 'Exit', '1') UNION ALL
(SELECT 'MessageText', 'Data from SAP not valid. Script execution will be terminated. Check source data. Running script Id 12.') UNION ALL
(SELECT 'RunScriptId', '12')
--#Exit
</pre>

The following example script fragment checks if the previous ProcessAnalyzer command had any exceptions, and if it did, will goto script with Id 2. If the previous command didn't have any exceptions, the script execution is stopped.
<pre>
DECLARE @ScriptToRun VARCHAR(10)

IF @_ExceptionOccurred = 1
SET @ScriptToRun = '2'
ELSE SET @ScriptToRun = <nowiki>''</nowiki>

(SELECT 'Exit', '1') UNION ALL
(SELECT 'RunScriptId', @ScriptToRun)
--#Exit
</pre>

[[Category:Examples]]