A major strength of ABAP is that database access via Open SQL is embedded in the language. This article focuses on Dynamic Open SQL, an extension of Open SQL, which offers a way to address development efforts that involve dynamic or semi-dynamic database access, thus avoiding the need to generate ABAP source code at runtime. It examines the features of ABAP Releases 4.6 and 6.10, and includes some easy-to-follow demonstration programs designed to acquaint you with the world of Dynamic Open SQL.
Ulrich Koch
Ulrich Koch received his doctorate in mathematics at the Westfälische-Wilhelms-Universität of Münster, Germany. In 1990, he joined SAP, where he became a member of the Business Programming Languages Group. As a Development Architect, currently Ulrich is mainly responsible for the external interfaces of the ABAP language. This includes in particular the design of semantics for and implementation of the set of commands that form the Open SQL and Native SQL parts of ABAP. Other special areas he works in include ABAP transaction handling and transparent object persistence.
You may contact the author at u.koch@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.
Adrian Goerler
Adrian Görler studied physics at the Ruprecht-Karls-University in Heidelberg, Germany, where he specialized in computational biophysics. He received his doctorate at the Max-Planck-Institute for Medical Research, Heidelberg, and did postdoctoral research work in various international laboratories. In 1999, Adrian joined SAP and became a member of the Business Programming Languages group, where he worked as a kernel developer responsible for the implementation and maintenance of Open SQL as well as Native SQL in ABAP. Since 2001, Adrian has been a member of the Java Server Technology group, where he has been working on the implementation of Open SQL for Java, especially Open SQL/SQLJ.
You may contact the author at adrian.goerler@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.
