Professional Web Applications Themes

VB 6.0 calling DB2 7.2 stored procedure - IBM DB2

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...

  1. #1

    Default VB 6.0 calling DB2 7.2 stored procedure

    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
    Uthuras Guest

  2. #2

    Default Re: VB 6.0 calling DB2 7.2 stored procedure

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

    Larry Edelstein

    Uthuras wrote:
     

    Larry Guest

  3. #3

    Default Re: VB 6.0 calling DB2 7.2 stored procedure

    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 doentation (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" <com> wrote in message
    news:google.com... 


    Mark Guest

Similar Threads

  1. #39136 [NEW]: Calling a stored procedure that creates temp table
    By aspen dot olmsted at alliance dot biz in forum PHP Bugs
    Replies: 1
    Last Post: October 12th, 02:44 PM
  2. oracle stored procedure calling
    By Raju_bhupesh in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 6th, 07:37 AM
  3. Calling stored procedure from MysQL 5.0
    By ShytKicker in forum Coldfusion Database Access
    Replies: 21
    Last Post: September 7th, 06:36 PM
  4. ASP page calling a stored procedure
    By Jim in forum ASP Database
    Replies: 2
    Last Post: December 11th, 10:13 AM
  5. Replies: 6
    Last Post: July 3rd, 07:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139