How to Work with Processes > Working with the Remote Database Processes Group

Process Purpose

The ODBC Execute SQL Script process is used to execute an SQL script on a data source in a specific Host server.

This data source must always be connected/linked to the operating system being used. See To create a Data Source in the PC.

When you add a process, you are required to define its settings. This occurs in the process's properties window which is displayed automatically after having added the Execute SQL Script process. This properties window includes two tabs - "General" and "Advanced".

If any subsequent edition is required, double-click the process to open its properties window and enter the necessary modifications.

General tab

Fill in the following options:

Host Name
Host Name	Select a Host profile from the drop-down list or click to create a new one. See How to Create a Host Profile or The <Default> Host Profile.
Remote SQL Transaction
MQD File Name	Select the MQD file where the script (SQL Statement) is stored.
Transaction	Select the unique name for the SQL statement with the MQD file.
Parameters to send (format = &xxx)
Param Name column	Enter the parameter name from the selected transaction within the MQD file.
Data or Variables column	Enter a fixed value to be sent to the script or click and select a variable with that value.You can execute up to 80 transactions with parameters at once. See Variable Definition.
Store returned parameters to Value
Param Name column	This column mentions the record number to store in a variable.
Store in Variable column	Click to select the variable that will receive this value. It can receive up to 80 records at once.

Use the editing icons to the right of the table to move the rows up and down and to delete or add more rows.

Proceed to the "Advanced" tab.

Advanced tab

Proceed as follows:

If … Go to
No Record	Select a target location from the drop-down or list, in case a "No Record" occurs. See Detail of a window below.
ODBC Error	Select a target location from the drop-down or list, if an "ODBC Error" occurs. See Detail of a window below.
Com. Error	Select a target location from the drop-down or list, if a communications error occurs. See Detail of a window below.
Store Nbr of Record(s) in Variable
Variable	Click to select the variable that will receive the number of selected records. See To Select/Create a Variable.

Detail of a window:

"S:Menu" is a screen included in the same program as the process.

"R:Routine_1" is a routine included in the same program as the process.

If required, click to setup a timeout. See To Define a Time Out.

After filling in the required options, click to conclude or to abort the operation.

The added process is displayed in the corresponding "Actions" tab or "Process" window.

Use the right click in MCL-Designer's input boxes to access certain features regarding the input box's option as well as general actions such as "Copy"; "Paste"; "Search".

Ex: If you right-click the "Variable" input box (included in a "Conversion's" properties window), you are provided with the "Search..."and "Variable Select" options.

If you right-click another input box, it will provide other possibilities.