Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    7

    Unanswered: compile stored procedure

    I want to compile a procedure on db2 udb (AIX unix machine).
    I installed c compiler. I get sqlstate 42904.

  2. #2
    Join Date
    Apr 2002
    Posts
    188
    Ensure that the DB2 registry variable DB2_SQLROUTINE_COMPILER_PATH is set to point to a script or batch file that sets up the C compiler environment. On a UNIX operating system, for example, you may create a script called "sr_cpath" in the /home/DB2INSTANCE/sqllib/function/routine directory. To set the DB2 registry variable DB2_SQL_ROUTINE_COMPILER_PATH accordingly, issue the following command:

    db2set DB2_SQLROUTINE_COMPILER_PATH = \
    "/home/DB2INSTANCE/sqllib/function/ \
    routine/sr_cpath"

Posting Permissions

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