Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: Error Ehile creating a stored procedure

    We recently creted a new Database instance in AIX

    and whn we create a store procedure we the error

    ND;
    [IBM][CLI Driver][DB2/6000] SQL0035N The file "P7472187.msg" cannot be opened.

    *** SCRIPT END : Connection: 10.80.10.36-TMSADMIN-OBDEV9II (tpeomdev) Oct-14-2003 17:40:30 ***

    what could be the reason...

    When we execure a sample procedure from the db2 command
    we get the wrror

    db2 => create procedure peter begin end
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0035N The file "P8461366.msg" cannot be opened


    our db2set gives this

    DB2_SQLROUTINE_COMPILER_PATH=/home/tmsadmin/sqllib/function/routine/sr_cpath
    DB2_ENABLE_LDAP=YES
    DB2COMM=TCPIP
    DB2AUTOSTART=YES


    Also the contents of sr_cpath is

    #!/bin/sh
    PATH=$PATH:/usr/vacpp/bin
    PATH=$PATH:/usr/ibmcxx/bin
    PATH=$PATH:/usr/lpp/xlC/bin
    export PATH
    Last edited by synap1974; 10-14-03 at 10:20.

  2. #2
    Join Date
    Sep 2003
    Posts
    8

    Re: Error Ehile creating a stored procedure

    I believe this is something to do with the C++ compiler resides on the DB2 server.

Posting Permissions

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