Greetings

Machine : Pentium III
Os : Windows 2000
Prodcut : Visual Basic 6.0
DB2 EE 7.2

I'm doing some testing on VB application calling DB2 stored procedure.
There seem to be not much info available on how to invoke the call. In
fact, most of
the example related to VB calling DB2 OS/390 and z/OS. Has anyone done
sample
VB application that invoke DB2 stored procedure on DB2 for windows?

A sample code or a site for reference would help me get start with.
Thanking
in adavance and hope to get prompt feedback on this.

Thanks again

Uthuras

Have you consulted "DB2 Universal Database in Application Development
Environments" at http://www.redbooks.ibm.com ?

Larry Edelstein

Uthuras wrote:

> Greetings
>
> Machine : Pentium III
> Os : Windows 2000
> Prodcut : Visual Basic 6.0
> DB2 EE 7.2
>
> I'm doing some testing on VB application calling DB2 stored procedure.
> There seem to be not much info available on how to invoke the call. In
> fact, most of
> the example related to VB calling DB2 OS/390 and z/OS. Has anyone done
> sample
> VB application that invoke DB2 stored procedure on DB2 for windows?
>
> A sample code or a site for reference would help me get start with.
> Thanking
> in adavance and hope to get prompt feedback on this.
>
> Thanks again
>
> Uthuras

Provided you use the MS OLE DB over ODBC driver with the IBM ODBC driver,
there is nothing special about calling stored procedures from VB to DB2, not
are there any real problems.

The easiest technique is the use the VB6 Data Environment Designer, this
lets you build your calling code via point-and-click, and provides you with
canned code that will do the hard work (connection setup, queries and SP
calls). Samples make little sense as it's all mouse clicking. Tutorial
information on this mouse clicking is in the VB6 documentation (uses SQL
Server, but that's essentially irrelevant as the alterations are obvious -
see my first paragraph).

BTW, within VB6, you also have access to the DB2 Stored Procedure Builder
Addin, but this is more for the "other side" of the problem


"Uthuras" <uthuras@hotmail.com> wrote in message
news:2ebe688f.0310121910.2ae1a2b3@posting.google.c om...
> Greetings
>
> Machine : Pentium III
> Os : Windows 2000
> Prodcut : Visual Basic 6.0
> DB2 EE 7.2
>
> I'm doing some testing on VB application calling DB2 stored procedure.
> There seem to be not much info available on how to invoke the call. In
> fact, most of
> the example related to VB calling DB2 OS/390 and z/OS. Has anyone done
> sample
> VB application that invoke DB2 stored procedure on DB2 for windows?
>
> A sample code or a site for reference would help me get start with.
> Thanking
> in adavance and hope to get prompt feedback on this.
>
> Thanks again
>
> Uthuras