-
DB2 Stored Procedures
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.
-
Re: DB2 Stored Procedures
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.
-
Re: DB2 Stored Procedures
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|