Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: DB@ SQL PREPARE/DECLARE error -805 in cursor 1

    Hi,

    I was new to DB2 we are using db2v8 on windows for peoplesoft Finance application. while executing SQR programs through SQRW we are getting

    SQL0805N Package "SQR.W84807 0X4442616B41434258" was not found.

    can someone tell me what could it be? tks
    please help me how to resolve this issue.

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    db2 ? SQL0805N

    try the user response options and chk.

    regds
    Paul

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    -805

    means package not found
    with utilities like peoplesoft and other, they supply a bind file xxxx.bnd or a list file yy.lst
    execute db2 bind to bring in the ps packages to db2 catalog
    it is indicated in the installation/config guide of the product
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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