If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > -805 in Db2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-15-05, 02:32
Subatra Subatra is offline
Registered User
 
Join Date: Dec 2005
Posts: 1
-805 in Db2

There is a problem with a DB2 COBOL program.
This program has a cursor to read a Db2 table. The first read of the table goes on fine.
The subsequent reads also go on fine as long as the call to another program is skipped.

If however, the other program is called, the next fetch from the table (cursor) in the main program fails with SQL code of -805.
This -805 SQL code occurs only if the other program is called.

Along with the SQL code of -805, the following details are being set:
SQLCAID > SQLCA

SQLCABC > +000000136

SQLCODE > -000000805

SQLERRML > +0046

SQLERRMC > N090DSN..E8...&...0004500C022CF339.E8785EMQ.03

SQLERRP > DSNXEPM

SQLERRD > -000000250, +000000000, +000000000, -000000001, +000000000

E8785EMQ is the plan name. We use packages for binding with the plan.

We checked the contoken between DBRM and SYSIBM.SYSPACKAGE. They are matching.
Please help us to fix this issue. We tried rebinding several times. But still the issue is coming up.
Reply With Quote
  #2 (permalink)  
Old 12-15-05, 15:50
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
It looks to me the plan name in the called program doesn't match with the table in calling program. Bind the called program with correct plan name.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On