Use the DB2 Stored Procedures editor to add, change, view, or delete a DB2 stored procedure for the model. Use the Parameters tab to add parameters for the procedure.
To define DB2 stored procedure parameters
The DB2 Stored Procedure Editor opens.
on the toolbar to create a parameter.
Specifies the name of the parameter. The name must be unique to the procedure.
Specifies the mode of the parameter. Select from the drop-down list; valid values are Input, Output, and Input Output.
Specifies the data type of the parameter. Select from the drop-down list.
Specifies whether the data type is for binary data.
Specifies the default value of the parameter. Create or select from the drop-down list.
Specifies the type of data to which the variable is anchored. Select from the drop-down list; valid values are: Variable, Column, Table Row, View Row, and Cursor Variable.
Specifies the global variable to which the selected variable is anchored. This field appears only when you set the value for the Anchored To Type field as either Variable or Cursor Variable.
Specifies the name of the table for the anchored column. This field appears only when you set the value for the Anchored To Type field as Table Row.
Specifies the name of the anchored column for the variable. This field appears only when you set the value for the Anchored To Type field as either Column or View Row.
The DB2 for LUW Stored Procedure Editor closes.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|