Enhanced ABAP Programming with Dynamic Open SQL

  • by Ulrich Koch, Development Architect, SAP
  • Adrian Goerler, Java Server Technology Group, SAP AG
  • September 15, 2001
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.

See more by this author

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.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.