Professional Web Applications Themes

Problem building stored procedure - IBM DB2

Hello , I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I need to write stored procedures for DB2. I have installed Application Development Client, which has provided me IBM DB2 stored procedure builder, which I am using to create stored procedures. db2level command on the DB2 m/c shows this information -- DB21085I Instance "DB2" uses DB2 code release "SQL07020" with level identifier "03010105" and informational tokens "DB2 v7.1.0.40", "n010415" and "WR21254". I am posting db2level details for information sake.. From DB2 stored procedure builder, when I type in all the details in the "SQL stored procedure ...

  1. #1

    Default Problem building stored procedure

    Hello ,
    I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I
    need to write stored procedures for DB2. I have installed Application
    Development Client, which has provided me IBM DB2 stored procedure
    builder, which I am using to create stored procedures.

    db2level command on the DB2 m/c shows this information --
    DB21085I Instance "DB2" uses DB2 code release "SQL07020" with level
    identifier
    "03010105" and informational tokens "DB2 v7.1.0.40", "n010415" and
    "WR21254".

    I am posting db2level details for information sake..

    From DB2 stored procedure builder, when I type in all the details in
    the "SQL stored procedure using wizard" option for my stored procedure
    ; generation of stored procedure succeeds, but build step fails --

    The following error messages are printed --

    Create stored procedure returns -7032

    *** BIND E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp\P5649990.sqc
    ***
    SQL0060W The "C" precompiler is in progress.
    SQL0091W Precompilation or binding was ended with "0"
    errors and "0" warnings.

    *** COMPILE E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp\P5649990.c
    ***

    echo off
    REM set VCV6_DRIVE=c:\Microsoft Visual Studio
    REM set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%V CV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\incl ude
    REM set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\V C98\lib
    REM set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_ DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tool s;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib; %VCV6_DRIVE%\VC98\lib
    echo off
    REM set VCV5_DRIVE=c:\Program Files\devstudio
    REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DR IVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
    REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\ lib
    REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_D RIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin
    echo on
    set SQLROUTINE_FILENAME=P5649990
    set db2path=E:\SQLLIB

    nmake /f E:\SQLLIB\function\routine\sqlproc.mak
    *** E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp\P5649990.def
    ***
    LIBRARY P5649990
    EXPORTS _pgsjmp20
    pgsjmp=_pgsjmp20
    E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp>set
    SQLROUTINE_FILENAME=P5649990
    E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp>set
    db2path=E:\SQLLIB
    E:\SQLLIB\function\routine\sqlproc\SHOWDB\DB2ADMIN \tmp>nmake /f
    E:\SQLLIB\function\routine\sqlproc.mak

    The name specified is not recognized as an internal or external
    command, operable program or batch file.

    Build failed.
    Changes rolled back.

    I'll appreciate reply mentioning the steps to be taken, to solve the
    above problem..

    Regards,
    Mukul
    Mukul Gandhi Guest

  2. #2

    Default Re: Problem building stored procedure

    Mukul Gandhi wrote:
    > Hello ,
    > I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I
    > need to write stored procedures for DB2. I have installed Application
    > Development Client, which has provided me IBM DB2 stored procedure
    > builder, which I am using to create stored procedures.
    >
    > [...]
    >
    > I'll appreciate reply mentioning the steps to be taken, to solve the
    > above problem..
    Do you have MS Visual C++ installed on your workstation? SQL Stored
    Procs currently require a C or C++ compiler.


    Good luck,





    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    [url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian Guest

  3. #3

    Default Re: Problem building stored procedure

    "Ian" <ianbjormobileaudio.com> a écrit dans le message de
    news:3f6872b3$1_1corp.newsgroups.com...
    > Mukul Gandhi wrote:
    >
    > > Hello ,
    > > I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I
    > > need to write stored procedures for DB2. I have installed Application
    > > Development Client, which has provided me IBM DB2 stored procedure
    > > builder, which I am using to create stored procedures.
    > >
    > > [...]
    > >
    > > I'll appreciate reply mentioning the steps to be taken, to solve the
    > > above problem..
    >
    > Do you have MS Visual C++ installed on your workstation? SQL Stored
    > Procs currently require a C or C++ compiler.
    >
    >
    > Good luck,
    >
    >
    You can have a look to
    [url]http://www7b.software.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]
    that describes how to use GCC.

    However, it is written "not to be supported" by the labs. And you cannot
    debug the proc with that ...

    Does anyone have any idea why IBM refrain from supporting GCC for all the
    samples/c programs and stored procs ?
    IBM pushed CygWin stuff for making a DB2 Everyplace application, so it seems
    pretty inconsistant to me.

    Cheers,

    Jean-Marc


    Jean-Marc Blaise Guest

  4. #4

    Default Re: Problem building stored procedure

    Hi Jean-Marc,
    Thanks for your help.. With the help of the article you have
    mentioned, I have successfully configured GCC on the DB2 m/c.. , and
    have successfully been able to build SQL stored procedures..

    I also tried with IBM DB2 8.x. It has enhanced stored procedure
    capability by providing both SQL and Java stored procedures..

    Just a different question -- I am wondering why this approach has been
    taken by DB2 architects.. Stored procedures are first compiled to C,
    and then converted to DLLs.. Why its not designed like -- that stored
    procedures are converted to DLLs(or the final runtime) directly..?

    Thanks again!

    Regards,
    Mukul


    "Jean-Marc Blaise" <blaisedeltadb.spam.no.com> wrote in message news:<bkahnc$jju$1news-reader5.wanadoo.fr>...
    > "Ian" <ianbjormobileaudio.com> a écrit dans le message de
    > news:3f6872b3$1_1corp.newsgroups.com...
    > > Mukul Gandhi wrote:
    > >
    > > > Hello ,
    > > > I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I
    > > > need to write stored procedures for DB2. I have installed Application
    > > > Development Client, which has provided me IBM DB2 stored procedure
    > > > builder, which I am using to create stored procedures.
    > > >
    > > > [...]
    > > >
    > > > I'll appreciate reply mentioning the steps to be taken, to solve the
    > > > above problem..
    > >
    > > Do you have MS Visual C++ installed on your workstation? SQL Stored
    > > Procs currently require a C or C++ compiler.
    > >
    > >
    > > Good luck,
    > >
    > >
    > You can have a look to
    > [url]http://www7b.software.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]
    > that describes how to use GCC.
    >
    > However, it is written "not to be supported" by the labs. And you cannot
    > debug the proc with that ...
    >
    > Does anyone have any idea why IBM refrain from supporting GCC for all the
    > samples/c programs and stored procs ?
    > IBM pushed CygWin stuff for making a DB2 Everyplace application, so it seems
    > pretty inconsistant to me.
    >
    > Cheers,
    >
    > Jean-Marc
    Mukul Gandhi Guest

  5. #5

    Default Re: Problem building stored procedure

    Hi Mukul,

    Maybe Serge Rielau (hi Serge !), who posted once about the VPSM could give
    more news about it.

    I guess the compiler stuff has really been painfull for many users, even if
    I fully understand that the use of native C for / while loops is a good
    idea, but many people are waiting for either no compiler mandatory install
    (the GET ROUTINE/PUT ROUTINE is for me a "workaround" in Prod, but not in
    Dev), adn/or full gcc support. Why buying any additional component to make
    full usage of DB2 ?

    Does anybody have news about that ?

    Regards,

    Jean-Marc

    "Mukul Gandhi" <mukulw3> a écrit dans le message de
    news:d9a610c9.0309190631.28a917e7posting.google.c om...
    > Hi Jean-Marc,
    > Thanks for your help.. With the help of the article you have
    > mentioned, I have successfully configured GCC on the DB2 m/c.. , and
    > have successfully been able to build SQL stored procedures..
    >
    > I also tried with IBM DB2 8.x. It has enhanced stored procedure
    > capability by providing both SQL and Java stored procedures..
    >
    > Just a different question -- I am wondering why this approach has been
    > taken by DB2 architects.. Stored procedures are first compiled to C,
    > and then converted to DLLs.. Why its not designed like -- that stored
    > procedures are converted to DLLs(or the final runtime) directly..?
    >
    > Thanks again!
    >
    > Regards,
    > Mukul
    >
    >
    > "Jean-Marc Blaise" <blaisedeltadb.spam.no.com> wrote in message
    news:<bkahnc$jju$1news-reader5.wanadoo.fr>...
    > > "Ian" <ianbjormobileaudio.com> a écrit dans le message de
    > > news:3f6872b3$1_1corp.newsgroups.com...
    > > > Mukul Gandhi wrote:
    > > >
    > > > > Hello ,
    > > > > I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I
    > > > > need to write stored procedures for DB2. I have installed
    Application
    > > > > Development Client, which has provided me IBM DB2 stored procedure
    > > > > builder, which I am using to create stored procedures.
    > > > >
    > > > > [...]
    > > > >
    > > > > I'll appreciate reply mentioning the steps to be taken, to solve the
    > > > > above problem..
    > > >
    > > > Do you have MS Visual C++ installed on your workstation? SQL Stored
    > > > Procs currently require a C or C++ compiler.
    > > >
    > > >
    > > > Good luck,
    > > >
    > > >
    > > You can have a look to
    > >
    [url]http://www7b.software.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]
    > > that describes how to use GCC.
    > >
    > > However, it is written "not to be supported" by the labs. And you cannot
    > > debug the proc with that ...
    > >
    > > Does anyone have any idea why IBM refrain from supporting GCC for all
    the
    > > samples/c programs and stored procs ?
    > > IBM pushed CygWin stuff for making a DB2 Everyplace application, so it
    seems
    > > pretty inconsistant to me.
    > >
    > > Cheers,
    > >
    > > Jean-Marc

    Jean-Marc Blaise Guest

Similar Threads

  1. stored procedure problem
    By Leon Shaw in forum Dreamweaver AppDev
    Replies: 42
    Last Post: November 7th, 05:13 PM
  2. MSSQL Stored Procedure Problem
    By Sequenzia in forum Coldfusion Database Access
    Replies: 2
    Last Post: October 10th, 07:56 PM
  3. Help building dynamic stored procedure
    By ossie in forum Dreamweaver AppDev
    Replies: 4
    Last Post: March 23rd, 08:56 AM
  4. ADO/Stored Procedure Problem
    By James Arnall in forum ASP Database
    Replies: 9
    Last Post: August 13th, 08:37 PM
  5. Problem with DBMS_JOB within a stored procedure
    By dwayne in forum Oracle Server
    Replies: 2
    Last Post: July 8th, 03:40 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