DB2 Version 10.1 for Linux, UNIX, and Windows

DB2Parameter Members

DB2Parameter class members

Public Fields

Name Description
public field static Default DB2Parameter.Default Field gets a DB2Parameter object with the IsDefault property set to true.
public field static Unassigned DB2Parameter.Unassigned Field gets a DB2Parameter object with the IsUnassigned property set to true.

Public Constructors

Name Description
DB2Parameter()

Initializes a new instance of the DB2Parameter class.

DB2Parameter(String, Object)

Initializes a new instance of the DB2Parameter class with the parameter name and an object holding a value to be passed as a parameter (for example, another DB2Parameter instance, or instances of IBM.Data.DB2Types structures or classes).

DB2Parameter(String, DB2Type)

Initializes a new instance of the DB2Parameter class with the parameter name and data type.

DB2Parameter(String, DB2Type, Integer)

Initializes a new instance of the DB2Parameter class with the parameter name, data type, and width.

DB2Parameter(String, DB2Type, Integer, String)

Initializes a new instance of the DB2Parameter class with the parameter name, data type, width, and source column name.

DB2Parameter(String, DB2Type, Integer, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)

Initializes a new instance of the DB2Parameter class with the parameter name, data type, width, source column name, parameter direction, numeric precision, and other properties.

Public Properties

Property Description
public property ArrayLength Gets or sets the number of elements of the Value property to use for parameter bind-in.
public property DB2Type Gets or sets the DB2Type of the parameter.
public property DB2TypeOutput Determines if the output-only parameter values associated with the DB2Parameter is returned as native DB2 data types (specifically, classes and structures in the IBM.Data.DB2Types namespace).
public property DbType Gets or sets the DbType of the parameter.
public property Direction Gets or sets a value indicating whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.
public property IsDefault DB2Parameter.IsDefault Property gets or sets a value indicating whether the parameter uses the default value assigned by the data server.
public property IsNullable Gets or sets a value indicating whether the parameter accepts null values.
public property IsUnassigned DB2Parameter.IsUnassigned Property gets or sets a value indicating whether the parameter is treated as an unassigned value by the data server.
public property ParameterName Gets or sets the name of the DB2Parameter.
public property Precision Gets or sets the maximum number of digits used to represent the Value property.
public property Scale Gets or sets the number of decimal places to which Value is resolved.
public property Size Gets or sets the maximum size, in bytes, of the data within the column.
public property SourceColumn Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value .
public property SourceColumnNullMapping Gets or sets a value indicating whether the column is nullable.
public property SourceVersion Gets or sets the DataRowVersion to use when loading Value .
public property Value Gets or sets the value of the parameter.

Public Methods

Method Description
public method CreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public method Equals (inherited from Object) Overloaded. Determines whether two Object instances are equal.
public method GetHashCode (inherited from Object) Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public method GetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public method GetType (inherited from Object) Gets the Type of the current instance.
public method GetXmlReader Returns an XmlReader from a character, binary, or DB2Type.XML column.
public method InitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public method ResetDbType Overridden. Resets the data type associated with this DB2Parameter instance.
public method ToString Overridden. Gets a string containing the ParameterName .

Protected Methods

Method Description
protected method Finalize (inherited from Object) Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and Microsoft(R) Visual C++(R), finalizers are expressed using destructor syntax.

protected method MemberwiseClone (inherited from Object) Creates a shallow copy of the current Object.