SQL Scripting Commands - Revision history

MarHink: /* --#ImportSapQuery */

2025-01-14T15:49:52Z

--#ImportSapQuery

← Older revision		Revision as of 15:49, 14 January 2025
Line 319:		Line 319:
	:<code>@_ExceptionMessage</code> If there was an exception, contains a message that would have been displayed, NVARCHAR(MAX), otherwise NULL.		:<code>@_ExceptionMessage</code> If there was an exception, contains a message that would have been displayed, NVARCHAR(MAX), otherwise NULL.
	:<code>@_ExceptionDetails</code> If there was an exception, contains the details that would have been displayed, including the system stack trace, NVARCHAR(MAX), otherwise NULL.		:<code>@_ExceptionDetails</code> If there was an exception, contains the details that would have been displayed, including the system stack trace, NVARCHAR(MAX), otherwise NULL.
			;ImportChunkSize
			:Specifies the size of the chunks of data used when importing the data from SAP to PA Server. The value represents the approximate maximum number of data cells in each chunk (consisting tables of <number of rows> * <number of columns> data cells. Default value is 200000. Smaller value causes big imports to be split into more chunks taking more time in total, but it makes importing of each chunk faster possibly helping in some timeout situations.
	; SapUser		; SapUser
	: SAP username used to connect to SAP. Mandatory. Corresponds to the "USER" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.		: SAP username used to connect to SAP. Mandatory. Corresponds to the "USER" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.

Ollvihe: /* --#GetAnalysis */

2024-01-24T14:20:01Z

--#GetAnalysis

← Older revision		Revision as of 14:20, 24 January 2024
Line 126:		Line 126:
	; <Analysis Parameter>		; <Analysis Parameter>
	: The --#GetAnalysis command supports the following analysis types:		: The --#GetAnalysis command supports the following analysis types:
	* UserPermissions=11: Opens a detailed list of users in server
	* DataTableAnalysis=18: Reads a data table from SQL server and stores it in temporary table		* DataTableAnalysis=18: Reads a data table from SQL server and stores it in temporary table
	* Etl=19		* Etl=19
	* EtlReport=20		* EtlReport=20
	* RunScript=25		* RunScript=25
	* ScriptLogReport=32
	* ExpressionAnalysis=33		* ExpressionAnalysis=33
	; TargetTable		; TargetTable

Ollvihe at 12:53, 18 January 2024

2024-01-18T12:53:50Z

← Older revision		Revision as of 12:53, 18 January 2024
Line 272:		Line 272:
	: Password for the Salesforce cloud.		: Password for the Salesforce cloud.
	; SalesforcePWKey		; SalesforcePWKey
	: [[~~Secure Strings~~\|~~Secure string key~~]] for the stored Salesforce password. Alternative for the SalesforcePW property.		: [[Storing_Secrets_for_Scripts\|Secret name]] for the stored Salesforce password. Alternative for the SalesforcePW property.
	; SalesforceUrl		; SalesforceUrl
	: Optional. Salesforce web service url.		: Optional. Salesforce web service url.
Line 326:		Line 326:
	: Password of the SAP user used to connect to SAP. Mandatory. Corresponds to the "PASSWD" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.		: Password of the SAP user used to connect to SAP. Mandatory. Corresponds to the "PASSWD" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.
	; SapPWKey		; SapPWKey
	: [[~~Secure Strings~~\|~~Secure string key~~]] for the stored SAP password. Alternative for the SapPW property.		: [[Storing_Secrets_for_Scripts\|Secret name]] for the stored SAP password. Alternative for the SapPW property.
	; SapClient		; SapClient
	: The SAP backend client. Mandatory. Corresponds to the "CLIENT" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.		: The SAP backend client. Mandatory. Corresponds to the "CLIENT" constant on SAP side. See the [http://help.sap.com/saphelp_nw04/helpdata/en/e9/23c80d66d08c4c8c044a3ea11ca90f/content.htm SAP .NET Connector documentation] for more info.

Ollvihe at 12:50, 18 January 2024

2024-01-18T12:50:44Z

← Older revision		Revision as of 12:50, 18 January 2024
Line 202:		Line 202:
	: The ODBC driver connection string that includes the settings needed to establish the initial connection. Mandatory. See [http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcconnection.connectionstring%28v=vs.110%29.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-1 OdbcConnection.ConnectionString Property in Microsoft Development Network] for more information on the possible connection strings.		: The ODBC driver connection string that includes the settings needed to establish the initial connection. Mandatory. See [http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcconnection.connectionstring%28v=vs.110%29.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-1 OdbcConnection.ConnectionString Property in Microsoft Development Network] for more information on the possible connection strings.
	; OdbcConnectionStringKey		; OdbcConnectionStringKey
	: [[~~Secure Strings~~\|~~Secure string key~~]] for the connection string. Alternative for the OdbcConnectionString property.		: [[Storing_Secrets_for_Scripts\|Secret name]] for the connection string. Alternative for the OdbcConnectionString property.
	; OdbcQueryString		; OdbcQueryString
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.

Ollvihe: /* --#ImportSapQuery */

2023-11-21T08:12:44Z

--#ImportSapQuery

← Older revision		Revision as of 08:12, 21 November 2023
Line 418:		Line 418:
	:		:
	;SncLibraryPath		;SncLibraryPath
	:Full path ~~and~~ name of the [[Importing_Data_from_SAP#SNC_encrypted_connection\|SNC]] shared library to be used.		:Full path including file name of the [[Importing_Data_from_SAP#SNC_encrypted_connection\|SNC]] shared library to be used.
	;SncMode		;SncMode
	: Determines whether connections will be secured with [[Importing_Data_from_SAP#SNC_encrypted_connection\|SNC]]. Value '''0''' doesn't use SNC (default) and value '''1''' uses SNC.		: Determines whether connections will be secured with [[Importing_Data_from_SAP#SNC_encrypted_connection\|SNC]]. Value '''0''' doesn't use SNC (default) and value '''1''' uses SNC.

Ollvihe at 16:32, 13 November 2023

2023-11-13T16:32:45Z

← Older revision		Revision as of 16:32, 13 November 2023
Line 206:		Line 206:
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
	; QueryExecutionTimeout		; QueryExecutionTimeout
	: Defines timeout in seconds for ODBC command execution. If not specified, default value is 600 seconds.		: Defines timeout in seconds for the ODBC command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or 1, you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or 1, you will receive an error message. Optional. Default value is FALSE.
Line 237:		Line 237:
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
	; QueryExecutionTimeout		; QueryExecutionTimeout
	: Defines timeout in seconds for OLE DB command execution. If not specified, default value is 600 seconds.		: Defines timeout in seconds for the OLE DB command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.
Line 468:		Line 468:
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
	; QueryExecutionTimeout		; QueryExecutionTimeout
	: Defines timeout in seconds for SQL command execution. If not specified, default value is 600 seconds.		: Defines timeout in seconds for the SQL command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the client side. FALSE or 0, the query is executed in the server side. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the client side. FALSE or 0, the query is executed in the server side. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.

Ollvihe: /* --#ImportOleDbQuery */

2023-11-13T16:31:30Z

--#ImportOleDbQuery

← Older revision		Revision as of 16:31, 13 November 2023
Line 236:		Line 236:
	; OleDbQueryString		; OleDbQueryString
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
			; QueryExecutionTimeout
			: Defines timeout in seconds for OLE DB command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.

Ollvihe: /* --#ImportSqlQuery */

2023-11-13T16:30:09Z

--#ImportSqlQuery

← Older revision		Revision as of 16:30, 13 November 2023
Line 465:		Line 465:
	; SqlQueryString		; SqlQueryString
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
			; QueryExecutionTimeout
			: Defines timeout in seconds for SQL command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the client side. FALSE or 0, the query is executed in the server side. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the client side. FALSE or 0, the query is executed in the server side. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or any other Integer than "0", you will receive an error message. Optional. Default value is FALSE.

Ollvihe: /* --#ImportOdbcQuery */

2023-11-13T16:29:25Z

--#ImportOdbcQuery

← Older revision		Revision as of 16:29, 13 November 2023
Line 205:		Line 205:
	; OdbcQueryString		; OdbcQueryString
	: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.		: The SQL query string. Mandatory. Note that if the query doesn't return any data, the target data table or temporary table is not created.
			; QueryExecutionTimeout
			: Defines timeout in seconds for ODBC command execution. If not specified, default value is 600 seconds.
	; ExecuteInClientSide		; ExecuteInClientSide
	: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or 1, you will receive an error message. Optional. Default value is FALSE.		: Defines whether the command is executed from the QPR ScriptLauncher or from the server. This parameter is used when there is no server connection available, for example. TRUE or 1, the query is executed in the QPR ScriptLauncher. FALSE or 0, the query is executed in the server. Supports only data table as the import destination. If 'TargetTable' has been defined as the import destination and the value of this parameter is given as TRUE or 1, you will receive an error message. Optional. Default value is FALSE.

Ollvihe at 18:18, 2 September 2023

2023-09-02T18:18:40Z

← Older revision		Revision as of 18:18, 2 September 2023
Line 55:		Line 55:
	: 1 = use the default network credentials.		: 1 = use the default network credentials.
	: 0 = don't use the default network credentials.		: 0 = don't use the default network credentials.
	: If CallWebService command is run in the server side (ExecuteInClientSide=False), the default network credentials can be used only if in the server configuration ~~[[Web.config_file#Qpr.ProcessAnalyzer.Common.Properties.Settings_Section\|~~AllowForwardingNetworkCredentials]] is true (it is false by default). Otherwise, if the CallWebService command is run in the client side (ExecuteInClientSide=True), the default network credentials can always be used.		: If CallWebService command is run in the server side (ExecuteInClientSide=False), the default network credentials can be used only if in the server configuration AllowForwardingNetworkCredentials is true (it is false by default). Otherwise, if the CallWebService command is run in the client side (ExecuteInClientSide=True), the default network credentials can always be used.
	; CatchOperationExceptions		; CatchOperationExceptions
	: Optional. Defines whether to stop the script execution or to continue to run the script from the next statement if an exception occurs when running the script:		: Optional. Defines whether to stop the script execution or to continue to run the script from the next statement if an exception occurs when running the script: