Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Bind process

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Chandan1993

New User


Joined: 21 May 2017
Posts: 6
Location: India

PostPosted: Wed Mar 13, 2019 10:33 pm    Post subject: Bind process
Reply with quote

as i know DSNHPC utility separates DB2 and cobol code and creates Token as timestamp. and during run time when timestamp is mismatch then we get -805 abend.
but now my question is if i compiled my program today and forgets to bind.If bind tomorrow then timetamp for cobol loadmodule and db2 would be different and code should through -805 abend. but in my case code ran properly..why ?
why i didn't get error as -805

can somebody clarifies my doubt please.
Back to top
View user's profile Send private message

daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 726
Location: Pennsylvania

PostPosted: Wed Mar 13, 2019 10:42 pm    Post subject:
Reply with quote

The contoken for the load module is created at compile time.

The Bind, of the Load Module and DBRM can be done whenever. This creates the Package, with the proper Contoken matching the Load module.

It is a mismatch of the contoken between the Package and the Load module that issues the -805 sqlcode.
Back to top
View user's profile Send private message
Chandan1993

New User


Joined: 21 May 2017
Posts: 6
Location: India

PostPosted: Wed Mar 13, 2019 10:46 pm    Post subject:
Reply with quote

daveporcelan wrote:
The contoken for the load module is created at compile time.

The Bind, of the Load Module and DBRM can be done whenever. This creates the Package, with the proper Contoken matching the Load module.

It is a mismatch of the contoken between the Package and the Load module that issues the -805 sqlcode.


could you please make more clear. Are you saying i should get -805 in my case ?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 726
Location: Pennsylvania

PostPosted: Wed Mar 13, 2019 10:57 pm    Post subject:
Reply with quote

Quote:
If bind tomorrow then timetamp for cobol loadmodule and db2 would be different and code should through -805 abend.


This is a false assumption.

The timestamp for the load module and dbrm are created at compile time.

The Bind sees that they match. It uses a second indicator called a contoken, while creating the package. This contoken ties the load module and the package together. The timestamp is no longer used after the bind is done.

At run time the contoken of the load module and the package are checked to see if they match. In your case they do, thus why it worked.

Apparently, you were not provided proper db2 training.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2300
Location: NY,USA

PostPosted: Thu Mar 14, 2019 3:33 am    Post subject:
Reply with quote

Also, you need to be able to differentiate between-818 and -805 clearly. Please read DB2 manual and link is provided at the top of this site.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. How to process gdg in rexx program wh... pkmurali CLIST & REXX 12 Thu Dec 13, 2018 10:08 am
No new posts Process Last Key of a record based on... naveen katkuri DFSORT/ICETOOL 5 Mon Nov 12, 2018 9:54 am
No new posts Process only last key record in a fil... Naveen.katkuri24 DFSORT/ICETOOL 8 Tue Oct 09, 2018 9:39 am
No new posts Process file after 7 days of hold charlessxavier All Other Mainframe Topics 4 Tue May 22, 2018 3:54 pm
No new posts How syntax check at Bind time is diff... Poha Eater DB2 5 Wed Mar 21, 2018 9:16 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us