Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2002
    Posts
    4

    Question Unanswered: Stored Procedures

    I need a little help with SQL stored procedures. Rather than writing a novel, if anyone has some experience and wouldn't mind a few questions, please let me know. Or if there are any good resources out there...TIA, Ken

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    Re: Stored Procedures

    Originally posted by kasmith
    I need a little help with SQL stored procedures. Rather than writing a novel, if anyone has some experience and wouldn't mind a few questions, please let me know. Or if there are any good resources out there...TIA, Ken
    Well what can I tell ya ?? ;-)

    1) make sure that you have at least some C compiler installed on your
    machine (client or server) you will need it to create the SP

    2) If you have a compiler (likes the VC++ 6 or 5) your
    sr_cpath.bat or sr_cpath.cmd has the proper REMout sets

    3) a bit of good luck in getting it right the first time

  3. #3
    Join Date
    Apr 2002
    Posts
    4
    I've got C++ 6.0 and can compile simple procedures, the problem is when I try to call another from within a procedure. I get error message 1109 - The specified DLL "<name>" could not be loaded. Help indicates DLL is not in a subdirectory identified in the system LIBPATH, yet it does not tell you where this mythical LIBPATH exists. Both the caller and called procedure are in the same project/DB.

  4. #4
    Join Date
    Apr 2002
    Posts
    188
    Originally posted by kasmith
    I've got C++ 6.0 and can compile simple procedures, the problem is when I try to call another from within a procedure. I get error message 1109 - The specified DLL "<name>" could not be loaded. Help indicates DLL is not in a subdirectory identified in the system LIBPATH, yet it does not tell you where this mythical LIBPATH exists. Both the caller and called procedure are in the same project/DB.
    have you tried calling it with all of the full name

    call owner.procedurename(?)

  5. #5
    Join Date
    Apr 2002
    Posts
    4
    yup...

  6. #6
    Join Date
    Mar 2002
    Posts
    34
    here's an example, and db2 cheat sheet. Hope this helps.

    FYI, it easier to read cheat sheet in word or wordpad.

    Cheers,
    BK
    Attached Files Attached Files

  7. #7
    Join Date
    Mar 2002
    Posts
    34
    here's sqlproc example
    Attached Files Attached Files

Posting Permissions

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