TableAdapter Configuration Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I created a DSN (ODBC) to connect to a database in IBM DB2. I wanted to
create a dataset for 'Select' Statement by wizard.

When I add a query variable @strGeoID in 'where' statement - where
(PRODDTA.F1755.ZAURRF = @strGeoID), I got the error message:
-----------------------------
Generated SELECT statement.
Error in list of function arguments: '@' not recognized.
Unable to parse query text.
-----------------------------

Does anybody can tell me how to solve the problem?


Thanks !
 
You cannot use the @variable when executing a query in DB2. You would use a
question mark ? e.g (PRODDTA.F1755.ZAURRF = ?)
If you have more than one critirea in the WHERE clause the question mark(s)
can be enumerated (e.g. parameter1, parameter2).

It took me a while to figure this when I had to run against DB2.
 
Back
Top