DB2Parameter.Direction Property

Gets or sets a value indicating whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual Basic]
Public Property Direction As ParameterDirection  Implements _
   IDataParameter.Direction
[C#]
public ParameterDirection Direction {get; set;}
[C++]
public: __property ParameterDirection get_Direction();
public: __property void set_Direction(ParameterDirection);
[JScript]
public function get Direction() : ParameterDirection;
public function set Direction(ParameterDirection);

Implements:: IDataParameter.Direction

Property value

One of the System.Data.ParameterDirection values. The default is Input.

Exceptions

Exception type	Condition
ArgumentException	The property was not set to one of the valid ParameterDirection values.

Remarks

If the ParameterDirection is Output, and execution of the associated DB2®Command does not return a value, the DB2Parameter will contain a null value. Null values are handled using the DBNull class. The Output, InputOut, and ReturnValue parameters are updated after the DB2Command has been executed.

Example

[Visual Basic, C#] The following example creates a DB2Parameter and sets some of its properties.

[Visual Basic]
Public Sub CreateDB2Parameter()
    Dim myParameter As New DB2Parameter("Description", DB2Type.VarChar, 88)
    myParameter.Direction = ParameterDirection.Output
End Sub 'CreateDB2Parameter

[C#]
public void CreateDB2Parameter()
 {
    DB2Parameter myParameter = new DB2Parameter("Description", DB2Type.VarChar, 88);
    myParameter.Direction = ParameterDirection.Output;
 }