Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Compilation and Binding of Cobol-DB2 program.

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

New User


Joined: 24 Jun 2008
Posts: 22
Location: Hyderabad

PostPosted: Tue Sep 30, 2008 12:58 pm    Post subject: Compilation and Binding of Cobol-DB2 program.
Reply with quote

I am raising this question as I am on bench and dont have access to mainframes to test it.

I have a existing cobol-db2 program, modified the cobol code(not db2 queries), compiled it but dint bind it. If I try to run it, will it give SQLCODE -818 (Timestamp mismatch)? Or It depends on pre-compiler option?
Back to top
View user's profile Send private message

ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Tue Sep 30, 2008 2:29 pm    Post subject:
Reply with quote

Gives TIme Stamp Mismatch error.
Back to top
View user's profile Send private message
Bharath Nadipally

New User


Joined: 24 Jun 2008
Posts: 22
Location: Hyderabad

PostPosted: Tue Sep 30, 2008 2:42 pm    Post subject:
Reply with quote

As I am not doing any DB2 query changes in program, I dont want to bind it again. Is it possible by using any of Pre-compiler options?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Sep 30, 2008 3:36 pm    Post subject:
Reply with quote

Quote:

I dont want to bind it again


until you bind it again,
you will continue to receive some time of sql error return code
when you try to execute the module.
Back to top
View user's profile Send private message
ramakrishnag

New User


Joined: 10 Sep 2008
Posts: 6
Location: india

PostPosted: Tue Sep 30, 2008 5:12 pm    Post subject: Reply to: Compilation and Binding of Cobol-DB2 program.
Reply with quote

Hi,

Bind is not thing but the SQL code internally converting into Cobol code.

So, even you have not done any code changes at DB2 part, still you have to bind once again.

The code will be inserted in during the compilation.

Thanks,
Rama
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Sep 30, 2008 9:12 pm    Post subject:
Reply with quote

RAMA,

what you described is the precompiler step.


The bind does not even look at the source or load module. only deals with the dbrm.



it is Pre-compile (build DBRM, insert COBOL code)
compile convert source program to object module
BINDER (know as the linkage-editor) convert OBJECT into EXECUTABLE
DB2 BIND - proofs dbrm against db2 catelog.

pre-compile, compile, linkedit are done without db2 running.
you need db2 to perform a db2 bind.

and no, that is not a definitive list of everything that goes on. but was a little more expansive and correct than what you stated.
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
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am

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