DB2Parameter Class

.NET Framework 2.0, 3.0, 3.5, and 4.0 inheritance hierarchy

.NET Framework 2.0, 3.0, 3.5, and 4.0 syntax

[Visual Basic]
NotInheritable Public Class DB2Parameter
   Inherits DbParameter
   Implements IDbDataParameter, IDataParameter, ICloneable
[C#]
public sealed class DB2Parameter : DbParameter,
   IDbDataParameter, IDataParameter, ICloneable
[C++]
public __gc __sealed class DB2Parameter : public
   DbParameter, IDbDataParameter, IDataParameter, ICloneable
[JScript]
public class DB2Parameter extends DbParameter implements
   IDbDataParameter, IDataParameter, ICloneable

Remarks

The parameter names are not case sensitive.

Example

[Visual Basic, C#] The following examples create multiple instances of the DB2Parameter class by using the DB2ParameterCollection within the DB2DataAdapter. These parameters are used to select data from the database and place the data in the DataSet. It is assumed that a DataSet and a DB2DataAdapter have already been created with the appropriate schema, commands, and connection.

[Visual Basic]
Public Sub AddDB2Parameters()
    ' ...
    ' create myDataSet and myDataAdapter
    ' ...
myDataAdapter.SelectCommand.Parameters.Add(
  "CategoryName", DB2Type.VarChar, 80).Value = "toasters"
myDataAdapter.SelectCommand.Parameters.Add(
  "SerialNum", DB2Type.Integer).Value = 239
myDataAdapter.Fill(myDataSet)
End Sub 'AddDB2Parameters

[C#]
public void AddDB2Parameters()
 {
 // ...
 // create myDataSet and myDataAdapter
 // ...
   myDataAdapter.SelectCommand.Parameters.Add(
     "CategoryName", DB2Type.VarChar, 80).Value = "toasters";
   myDataAdapter.SelectCommand.Parameters.Add(
     "SerialNum", DB2Type.Integer).Value = 239;
   myDataAdapter.Fill(myDataSet);
 }

The following example demonstrates the use of string literals in DATE columns. You can use a similar method for TIME and TIMESTAMP columns.

[Visual Basic]
Public Sub InsertDateDB2Parameters()
    ' ...
    ' create DB2Connection myConn
    ' ...
    Dim myStatement As String = "INSERT INTO myTable (dateCol1, dateCol2, dateCol3) 
values (?, ?, ?)"
    Dim myCommand As New DB2Command(myStatement, myConnection)
    Dim param1 As New DB2Parameter("dateCol1", DB2Type.Date) ' 
Date for DATE column dateCol1
    param1.Value = DateTime.Parse("06/23/1982 08:52:43 -5:00")
    Dim param2 As New DB2Parameter("dateCol2", DB2Type.VarChar) 	' 
VarChar for DATE column dateCol2
    param2.Value = "1982-06-23-8:52:43.000000"
    Dim param3 As New DB2Parameter("dateCol3", "1982-06-23-8:52:43.000000")
  ' String for DATE column dateCol3
    myCommand.Parameters.Add(param1))  ' added parameter of type Date
    myCommand.Parameters.Add(param2))  ' added parameter of type VarChar
    myCommand.Parameters.Add(param3))  ' added parameter of type String
    myCommand.ExecuteNonQuery()
End Sub ' InsertDateDB2Parameters

[C#]
public void InsertDateDB2Parameters()
 {
 // ...
 // create DB2Connection myConn
 // ...
   DB2Command myCommand = myConnection.CreateCommand();
   myCommand.CommandText = "INSERT INTO myTable (dateCol1, dateCol2, dateCol3)
 values (?, ?, ?)";
   DB2Parameter param1 = new DB2Parameter("dateCol1", DB2Type.Date);
	// Date for DATE column 'dateCol1'
   param1.Value = DateTime.Parse("06/23/1982 08:52:43 -5:00");
   DB2Parameter param2 = new DB2Parameter("dateCol2", DB2Type.VarChar);	
 // VarChar for DATE column 'dateCol2'
   param2.Value = "1982-06-23-8:52:43.000000";
   DB2Parameter param3 = new DB2Parameter("dateCol3", "1982-06-23-8:52:43.000000");
 // String for DATE column 'dateCol3';
   myCommand.Parameters.Add(param1));  // added parameter of type Date
   myCommand.Parameters.Add(param2));  // added parameter of type VarChar
   myCommand.Parameters.Add(param3));  // added parameter of type String
   myCommand.ExecuteNonQuery();

Query limitation

You cannot use a positioned parameter marker (?) and a named parameter marker (for example, : paramEmpAddr) in the same query.

Thread safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread safe.