Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Post Unanswered: Reply Wanted Immediately

    Hi Guys!

    New To DB2(First Day). Need help developing a SP to insert /update/delete a table record.
    The procedure does the following.
    1. Takes 2 parameters.
    2. Should check for the user authentication to drop an existing procedure
    3. Should check for the existence of the Object(Porcedure). If
    <available> drop else <msg>
    4. Insert the row into the coresponding table.
    5. Should Capture Errors if any ?



    Please Help
    Thanks
    Bollin

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    Re: Reply Wanted Immediately

    Originally posted by bollin99
    Hi Guys!

    New To DB2(First Day). Need help developing a SP to insert /update/delete a table record.
    The procedure does the following.
    1. Takes 2 parameters.
    2. Should check for the user authentication to drop an existing procedure
    3. Should check for the existence of the Object(Porcedure). If
    <available> drop else <msg>
    4. Insert the row into the coresponding table.
    5. Should Capture Errors if any ?



    Please Help
    Thanks
    Bollin
    Hello Bollin,

    You have several options,

    1) Java
    2) CL,

    if you are to use the regular CL language make sure that you have
    a C++ compiler on your environment, if on Windows a copy of the
    MSN C++ will do, if on AIX the Visula Age C compiler will do, gnuc
    compiler have not worked for me

    marcos

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Reply Wanted Immediately

    I'll suggest you to check the following link ...

    http://dbforums.com/search.php?s=&ac...&searchid=3618

    briankalberer has posted a number of SQL Stored Procedures in this forum ....

    Cheers

    Sathyaram


    Originally posted by bollin99
    Hi Guys!

    New To DB2(First Day). Need help developing a SP to insert /update/delete a table record.
    The procedure does the following.
    1. Takes 2 parameters.
    2. Should check for the user authentication to drop an existing procedure
    3. Should check for the existence of the Object(Porcedure). If
    <available> drop else <msg>
    4. Insert the row into the coresponding table.
    5. Should Capture Errors if any ?



    Please Help
    Thanks
    Bollin

  4. #4
    Join Date
    Sep 2002
    Posts
    30

    Arrow Stored Procedures !

    Hi santaram
    Went to the url you sent , but did not find what i really need.
    Can you please still let me know regarding this.

    Thanks
    Bollin

  5. #5
    Join Date
    Apr 2002
    Posts
    188

    Re: Stored Procedures !

    Originally posted by bollin99
    Hi santaram
    Went to the url you sent , but did not find what i really need.
    Can you please still let me know regarding this.

    Thanks
    Bollin
    Bollin,

    not to be an ass.. but man, help out here. if you want me to write it
    down for you then, send me the $$$ and I will contract for you and
    write it, samples you can go to the IBM site and download several of
    the RedBooks on how to structure a SP on any system, if you
    at least tried it, send the code and I would gladly help you
    debugged it, help you learn ..

    maor71

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Stored Procedures !

    Goto the search page and search for all posts by briankalberer ....

    HTH

    Cheers

    Sathyaram

    Originally posted by bollin99
    Hi santaram
    Went to the url you sent , but did not find what i really need.
    Can you please still let me know regarding this.

    Thanks
    Bollin

  7. #7
    Join Date
    Aug 2002
    Posts
    35
    It is simple. In your stored procedure first handle that error and send it
    the front page don't abend . And you shuld n't use commit or roll bcak on stored procedures. You can set your stored procedure definition for commit but I suggest just handlke those commits on the front end based
    on err flag.

    Need any help let me know.

    From,
    vasu
    vasu

Posting Permissions

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