Kbase P114316: What is a Binding variables ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/15/2006 |
|
Status: Unverified
GOAL:
What is a Binding variable?
GOAL:
What does Binding variables used for?
FACT(s) (Environment):
DataServers
FIX:
A bind variable is a placeholder in a SQL command for a value that will be supplied at runtime by the application. Because you can change the value of the bind variable as many times as needed without changing the actual text of the SQL command, it can reuse the same statement over and over without incurring the overhead of reparsing the command each time it's executed.
This technique is used by the Dataservers to improve performance.
For example, in the dataserv.lg a statement like:
SELECT * FROM SPORTS.CUSTOMER WHERE progress_recid = :rid
:rid is the binded variable
In the example, the same SELECT statement on the Customer table can be reused just changing the value of the recid