Binding problem

hemalathachandrasekaran · New User Joined: 01 Feb 2010 Posts: 5 Location: coimbatore

Hi, I am getting the sqlcode=-805. what do u mean by bind problem. how to rebound it.

Gnanas N · Posted: Mon Mar 08, 2010 12:58 pm

Hi,

Please visit this link and take the action as suggested for your reason code.
An application program attempted to use a DBRM or package 'location-name.collection-id.dbrm-name.consistency-token' that was not found.

Ragav86 · New User Joined: 27 Jan 2010 Posts: 37 Location: chennai

it mean the expected package was not found in db2(this may be the one of the reason).

check whether the consistency token in the program load module and consistency token in the db2 are matching. if not bind your dbrm again using bind package statement or using DB2I (BIND PACKAGE STATEMENT).

way to find out token.
1. go to your precompiled output of your program for every sql query some varibales will be automatically declered by your precompiler in working storage with the name of SQL-PLIST.(not sure about the name check it out)
this will have the timestamp of the load module, convert this to hex using select hex(time1),hex(time2) from sysibm.sysdummy1.

2. select hex(contoken) from sysibm.syspackage where name ='pack name';