DB2 - Bind process

GeekInterview.com > Interview Questions > Mainframe > DB2

Go To First | Previous Question | Next Question

DB2 | Question 193 of 198

Bind process

What happens during pre-compilation and finally bind process?

Total Answers and Comments: 2

Last Update: August 25, 2008 Asked by: prasenjit_in

Sponsored Links

Best Rated Answer

—

Submitted by: prasenjit_in

Pre-compilation---> Pre compiler check's the program for any embedded sql statements if found than separates them into a DBRM and an object module is formed for the host language to be compiled by the compiler.....On the otherhand the DBRM that is formed is either binded into a package or a plan to form an effective application plan....Now when the program that had embedded sql-statements is finally run than,for each of the sql statements a call is made to the corresponding table using the application plan which had the optimised accesss logic.Remember in programs with embeded sql-statements at run-time a thread is created between the program and the table it tries to access!

Above answer was rated as good by the following members:
omstennis

August 20, 2008 04:32:07

kashi2005

Member Since: March 2006 Contribution: 3

RE: Bind process

It checks the SQL query and checks the permissions for users

Is this answer useful? Yes | No

August 25, 2008 04:14:25

prasenjit_in

Member Since: April 2008 Contribution: 18

RE: Bind process

Pre-compilation---> Pre compiler check's the program for any embedded sql statements if found than separates them into a DBRM and an object module is formed for the host language to be compiled by the compiler.....On the otherhand the DBRM that is formed is either binded into a package or a plan to form an effective application plan....Now when the program that had embedded sql-statements is finally run than for each of the sql statements a call is made to the corresponding table using the application plan which had the optimised accesss logic.Remember in programs with embeded sql-statements at run-time a thread is created between the program and the table it tries to access!

Is this answer useful? Yes | No

1 0

Overall Rating: +1

ODP.NET - Working with Bind Variables together with OracleParameter

ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m

SCOR Model Process

SCOR Model Process The Supply Chain Operations Reference Model commonly known as SCOR is a diagnostic tool for the Supply Chain Management It lets the users know the various processes involved in a business and the important things that lead to customer satisfaction The Supply Chain Operations refer

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h

Creating an Efficient Process for Data Warehouses

Creating an Efficient Process for Data Warehouses Since data warehouses were first introduced during the 1990s a large number of companies have failed when attempting to implement and use them Many of these failures are not a result of the data warehouse itself but rather the policies and the proces

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve

Related Categories

—

User Name		Remember Me?
Password

Question Bank