Filter
Top Products
7
- 118
7.11 Job Setting - Actions
7.11.3 Setting items in Communication action (Stored procedure)
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
(3) DB-tag link settings
Set assignments between field values and tag component values (or constant
values).
Up to 256 rows can be set in [DB-tag link settings] for each communication action.
(a) Return/Argument
Select the argument type of a stored procedure in the following:
• Input (Integer), Input (Real), Input (String), Input (Date)
• Output (Integer), Output (Real), Output (String)
• I/O (Integer), I/O (Real), I/O (String)
Set the argument in accordance with the order of the first and second argument in
the first row.The argument is set automatically when the procedure name is set by
selecting on the [Stored procedure list] screen.
*1
*1: In case the data type of the argument of the stored procedure is not applicable, any of "Input
(String)", "Output (String)", or "I/O (String)" is set as an argument.
When the database type is SQL server, "Return" can be set.
Remark
(1) When "DB buffering" is enabled in Job settings, none of the return values,
output variables, and input/output variables can be used.
(2) When calling the stored procedure whose returned values, output arguments,
or input/output arguments exists in the job whose "DB buffering" is enabled,
remain the tag settings with blank (unset).
(3) When the tag settings are blank (unset), the default value of the stored
procedure are set to input value of input argument and input/output argument.
(b) Tag
Select or directly enter a tag, constant, or variable of the substitution target.
The constant can be used only for input arguments.
(c) Component
Select or directly enter a component value, constant value, or variable of the
substitution target.
Remark
For tag components, constants or variables, refer to the following:
• Section 7.11.1 (1) About tag components
• Section 7.11.1 (2) About constants
• Section 7.11.1 (3) About variables