topic Re: Bind Variables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064301#M427016 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>chk this link:</P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277</A></P><P></P><P></P><UL><UL><LI level="2" type="ul"><P>reward if helpful</P></LI></UL></UL><P>regards,</P><P>madhumitha</P></BODY></HTML> Tue, 06 Mar 2007 15:13:28 GMT Former Member 2007-03-06T15:13:28Z Bind Variables https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064300#M427015 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Does ABAP support the use of bind variables in database queries ?</P><P></P><P>In Oracle (and Sql Server), a query that is run many times but with a slightly different 'where' clause is much faster when bind variables are used. This is because the statment does not need to be parsed as the DBMS will reuse an already parsed version from memory.</P><P></P><P>How is this feature implemented in ABAP. (Java calls them Prepared Statements and VB has an API function to create them).</P><P></P><P>Thanx in advance</P><P>Asif</P></BODY></HTML> Tue, 06 Mar 2007 14:51:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064300#M427015 Former Member 2007-03-06T14:51:26Z Re: Bind Variables https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064301#M427016 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>chk this link:</P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277</A></P><P></P><P></P><UL><UL><LI level="2" type="ul"><P>reward if helpful</P></LI></UL></UL><P>regards,</P><P>madhumitha</P></BODY></HTML> Tue, 06 Mar 2007 15:13:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064301#M427016 Former Member 2007-03-06T15:13:28Z Re: Bind Variables https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064302#M427017 <HTML><HEAD></HEAD><BODY><P>Hi Asif,</P><P></P><P>chk this, it wud be helpful:</P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90732509-d358-2910-35be-bdeaa59d6277</A></P><P>/people/azazali.shaik/blog/2006/11/15/abap-and-javascript-part-2</P><P></P><P>regards,</P><P>keerthi</P></BODY></HTML> Wed, 07 Mar 2007 03:46:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bind-variables/m-p/2064302#M427017 Former Member 2007-03-07T03:46:43Z