DB2 Stored Procedures


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: DB2 Stored Procedures

  1. #1
    Steve Guest

    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.

  2. #2
    Joe Goodman Guest

    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.




  3. #3
    Greg Nash Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center