DB2 - Parameters

  • Thread starter Thread starter OldButStillLearning
  • Start date Start date
O

OldButStillLearning

I went through the VB2005 UI and create a DataSet and I create a DataAdapter
with the set of queries that I want to be able to run. One of my queries
requires that "CustomerID" be passed. In constructing the query for SQL
Server I would specify @CustomerID and this would be recognized as a
parameter. In Oracle I believe I would specify ":CustomerID". What would I
specify for DB2?

Thansk in advance for your assistance!!
 
OldButStillLearning said:
I went through the VB2005 UI and create a DataSet and I create a
DataAdapter with the set of queries that I want to be able to run.
One of my queries requires that "CustomerID" be passed. In
constructing the query for SQL Server I would specify @CustomerID and
this would be recognized as a parameter. In Oracle I believe I would
specify ":CustomerID". What would I specify for DB2?

Thansk in advance for your assistance!!
Click to expand...

with a '?', as stated in the documentation of the DB2 ado.net
provider.

so:
SELECT * FROM Customers WHERE Country = ?

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
 
Back
Top