DB2 Stored Procedures

[Steve]

Has anyone worked with stored procedures for DB2 version 6?

I have been running into a lot of issues that relate to stored procedures
and using Visual Basic as the front end.

Any help would be grealy apperciated.

Thanks.

[Joe Goodman]

I've been working with DB2 stored procedures since V4 (on MVS).
What platform of DB2 are we talking about?


"Steve" <mstrpgmr@yahoo.com> wrote:
>
>Has anyone worked with stored procedures for DB2 version 6?
>
>I have been running into a lot of issues that relate to stored procedures
>and using Visual Basic as the front end.
>
>Any help would be grealy apperciated.
>
>Thanks.

[Greg Nash]

Hi,
I'm using SP's on v7.1 / NT calling from VB.
A few things you might want to note:
- The dataenvironment designer doesn't like DB2 SP's, probably because:
- The DB2 ADO functionality doesn't provide the names and types of parameters
on SP's back to the client. You have to specify them. ("Enumerator is not
available")
- (training I've had says the dataenvironment is a quick way to make some
things happen, but not a good way)
- VB and MS Access don't like DB2 time & date values, as MS doesn't recognise
the time resolution being finer than 1ms (Is that 'ms' millisecond, or microsoft??
:-)
- You can, however, cast between char and date/time, also between some of
the numeric formats. I've had problems with decimal parameter types. In
VB I call them adSmallInt (if the sizing fits) and then they work.

You can find some info in an IBM paper called "Writing Applications Using
the IBM OLE DB2 Provider for DB2". (A pdf, search IBM's web site).

hth,
Greg
>"Steve" <mstrpgmr@yahoo.com> wrote:
>>
>>Has anyone worked with stored procedures for DB2 version 6?
>>
>>I have been running into a lot of issues that relate to stored procedures
>>and using Visual Basic as the front end.