Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Unanswered: SQL Stored Procedure

    Hello,

    I have a problem to export a Stored Procedure with GET ROUTINE:

    Command:
    get routine into proc.sar from procedure updprovider

    Error:
    SQL0443N Routine "GET_ROUTINE_SAR" (specific name "db2udp!get_routine_sar") has returned an error SQLSTATE with diagnostic
    text "-31, , C:\SQLLIB\bnd\ps...". SQLSTATE=38000

    I hope you can help me!

    Best regards

    Joni

  2. #2
    Join Date
    Jun 2003
    Location
    Kiev, Ukraine
    Posts
    1

    Lightbulb Re: SQL Stored Procedure

    Originally posted by openikos
    I have a problem to export a Stored Procedure with GET ROUTINE:

    SQL0443N Routine "GET_ROUTINE_SAR" (specific name "db2udp!get_routine_sar") has returned an error SQLSTATE with diagnostic
    text "-31, , C:\SQLLIB\bnd\ps...". SQLSTATE=38000
    Probably it is too late to help you But can be useful for others...

    You need to have psmgtptp.bnd file in SQLLIB\bnd\ subfolder. Usually it is installed by fixpack (for DB2 7.1/7.2) or by initial DB2 installer (for DB2 8.1). If it wasn't for some reason, you can extract it from fixpack or installer archive manually and just copy to SQLLIB\bnd\ .

    As far as I know, DB2 8.1 Personal Edition does not contain that file. You can take it from DB2 8.1 Enterprise Server Edition, then.

Posting Permissions

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