Host Name & Data Source

Host Name

Select a host profile from the drop-down OR  click to create a new host profile or edit an existing one.

See To Create a Host Profile OR To Edit a Host Profile OR The <Default> Host Profile.

As an alternative, you can use a variable to define the Host Name (use the "Variable Select" option that is accessed if you right-click this box).

See The Use of a Variable to Define a Host Name.

Data Source

Select a database from the drop-down OR  click to create one. See To Add a Data Source to MCL-Designer V4.

As an alternative, you can use a variable to define the Data Source (use the "Variable Select" option that is accessed if you right-click this box).

See The Use of a Variable to Define a Data Source.

Before using the “Variable Select” alternative, consider your choices in the “Remote Database” tab (see Remote Database tab in "Project Properties"):

•If the “SQL Commands option” is set to “2. Server (Save SQL statement into MQD file for server)", the “Variable Select” option is NOT applicable/supported.

SQL Statement

Define the SQL statement. You can enter it and click to include variables anywhere in the statement. Ex: Select * from table where field = '&A1'

Return Value

Wait for Returned Value

Check this option to wait for an answer from the SQL statement. A time out should be defined (click and define a time out. See Time Out).

Store in Variable

Click to select the variable that will receive the return value. You can retrieve up to 80 values at once. See To Select/Create a Variable.

SQL request name (Must be unique)

SQL User Name

Define a unique name for the SQL request. One is always suggested.

Store Number 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.

Generate Result File

Generate Result File on Server

Check this option to create a result file. Once checked, it activates other options that relate to the "result file".

File Name

Define the name and path for the result file.

Record Format

Define the mask of the selected record.

Field Separator

Select the appropriate field separator for the "result file" from the drop-down.

Max. Record(s)

Define the maximum number of records for the "result file".

Add Record Number Field

Check this option to add a field, in the "result file", with the record number.

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.

ONLY to be used if the intended SQL statement is expected to return data (ex: record selection). For any other SQL statements, maintain the default option “<continue>".

For instance, if you intend to use an “INSERT” statement, you do NOT expect a value to be returned, so the “No Record” situation does NOT apply - there is no need to attribute a location for it.

When defining a screen as a target destination (ex: via a “Go to” process), you CANNOT use variables to specify the name of that target screen. You must select the intended screen from the available drop-down/list.

ODBC Error

Select a target location from the drop-down or list, in case an "ODBC Error" occurs. See Detail of a window below.

When defining a screen as a target destination (ex: via a “Go to” process), you CANNOT use variables to specify the name of that target screen. You must select the intended screen from the available drop-down/list.

Comm Error

Select a target location from the drop-down or list, in case a "Comm Error" occurs. See Detail of a window below.

When defining a screen as a target destination (ex: via a “Go to” process), you CANNOT use variables to specify the name of that target screen. You must select the intended screen from the available drop-down/list.