VB, DB2, ODBC, Stored Procedure

[Guest_imported]

What's the best way to call a stored procedure(with parameters) in VB using an ODBC DB2 interface?

 

[wmd3]

When ever I call a stored procedure I just:

------------------------------------

set [Recordset] = [Connection].Execute("EXEC [Stored Procedure Name] [Parameter1], [Parameter2], [etc.]&quot

------------------------------------

But, there are several other ways also.
(Use the Command Object, Recordset.Open, etc.)

It really just comes down to what you are really doing and what you need.

(Note: My experience is with SQL Server, but the SQL should be similar.)

- Bill

 

[Guest_imported]

Thanks Bill. I guess my question is geared more towards the DB2 syntax side of things? I have accessed stored procedures against a SQL Server in the past just as you have suggested. Thanks though!