What is BIND parameter

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
its.sudip
Member
Posts: 19
Joined: Sat Apr 28, 2012 1:55 pm
Location: Bangalore

What is BIND parameter

Post by its.sudip » Sat Apr 28, 2012 2:26 pm

What is BIND parameter and what are the BIND parameters in IBM DB2?
Sudip Sen
Assistant Systems Engineer,
Bangalore,
Karnataka - 560037

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Sun Apr 29, 2012 2:09 am

your questions (this and the others that you posted today)
can be easily answered by RTFM.
there is a manuals button on the top of every page.
read thru the DB2 application programmers guide.


i am moving this thread to INTERVIEW QUESTIONS as the topic fits there better.

db2 application programming forum is for db2 problems for more advanced topics
than posed by beginners/INTERVIEW Questions
.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

pawan1284
Member
Posts: 3
Joined: Fri May 04, 2012 10:37 pm

Post by pawan1284 » Fri May 04, 2012 11:24 pm

DURING PRE-COMPILTION PROCESS SQL CODES ARE MOVED TO DBRM THEN BINDING PROCESS TAKES PLACE AND CREATES A PACKAGE.
THE OPERATION OF BINDING PROCESS IS
1.CHECK AUTHENTICATION.
2.SELECTS BEST ACCESSING DB2 PATH.(OPTIMIZATION PATH)
3.PARSING & SYNTACTIC ERRORS.
pavan

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Sat May 05, 2012 12:02 am

Pavan,

good answer,
don't forget that the db2 pre-compiler does not access the db2 catalogue
(db2 does not have to be available during pre-compile)
whereas
the bind process registers the sql with db2 so that the program containing the sql (or Stored Procedure) can execute successfully in the correct environment.
(Obviously. db2 has to be available for a bind)
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others