Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

what is the bind process , explain.

This is a discussion on what is the bind process , explain. within the DB2 forums, part of the Databases category; explain me abt Bind process in DB2....

Go Back   Geeks Talk > Databases > DB2
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 05-16-2008
Junior Member
 
Join Date: May 2008
Location: Banglore
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
naresh.somapalyam is on a distinguished road
what is the bind process , explain.

explain me abt Bind process in DB2.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-16-2008
Junior Member
 
Join Date: May 2008
Location: Banglore
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
naresh.somapalyam is on a distinguished road
Re: what is the bind process , explain.

what is the Bind processs in DB2.
Reply With Quote
  #3 (permalink)  
Old 05-26-2008
Junior Member
 
Join Date: May 2008
Location: Kolkata
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
dbadb2udb is on a distinguished road
Re: what is the bind process , explain.

Hi,
In DB2 bind is a process that makes bridge between the applications and the database.
Regards,
Shubhrojyoti
Reply With Quote
  #4 (permalink)  
Old 10-02-2008
Junior Member
 
Join Date: Oct 2008
Location: Delhi
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
rengupta83 is on a distinguished road
Re: what is the bind process , explain.

Bind converts high level database request into optimized internal form. It compiles the SQL statement into code.
Reply With Quote
  #5 (permalink)  
Old 10-27-2008
Junior Member
 
Join Date: Oct 2008
Location: Hyd
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Hari koteswararao is on a distinguished road
Re: what is the bind process , explain.

Few things are happend in bind process. those are..
1. Checking for syntax like sql statements, DCLGEN variables.
2. it verifies the access authority like updating or retriving of data from database.
3. after completion of checking of access authority it creates a documentary evidance in PLAN_TABLE
Reply With Quote
  #6 (permalink)  
Old 10-27-2008
Junior Member
 
Join Date: Oct 2008
Location: Hyd
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Hari koteswararao is on a distinguished road
Re: what is the bind process , explain.

Directly we can code DDL statements into PL/SQL programs..
Reply With Quote
  #7 (permalink)  
Old 2 Weeks Ago
Junior Member
 
Join Date: Apr 2007
Location: chennai
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
ragav_sathish is on a distinguished road
Re: what is the bind process , explain.

consider u r running an application program such as pro c .. when u compile ,the sql statements present inside the c file is seperated and its being stored in the database as package (may contain access plan of the sql).. the above process in called binding.. during runtime its linked and the pgm is executed
Reply With Quote
Reply

  Geeks Talk > Databases > DB2

« Data web | - »
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Bind dropdown list to textbox ushalakshmi ASP.NET 6 06-10-2008 07:02 AM
ODP.NET - Working with Bind Variables together with OracleParameter admin ASP.NET 0 04-09-2008 08:01 PM
Invalid host/bind variable name k_sakthivel Oracle 1 11-20-2007 02:34 AM
Explain the Difference Robert VB.NET 3 06-06-2007 11:19 AM
Explain the Process in UNIX sripri Unix/Linux 1 07-29-2006 04:19 PM


All times are GMT -4. The time now is 08:56 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved