transferred from: http://blog.sina.com.cn/s/blog_3f2c03e301017fqz.html------------------------------------------------------------ in the ABAP program, in addition to using EXEC SQL to perform NativeSql, there is a way to use native SQL dynamically: Adbc API Instance Program: Adbc_demo the global classes provided by SAP are:cl_sql_connectioncl_sql_statement The adbc API is described below:adbc-abap Database Connectivity ADBC is a API for the Native SQL interface of the as ABAP, that's based on ABAP Objects. The methods of ADBC make it possible to; Send database specific SQL commands to a database system and process the resultTo establish and administer database connections.While the statements of Native SQL offer exclusively static access to the Native SQL interface, ADBC makes an object o rientated and dynamic access possible. The ADBC classes all begin with the prefix Cl_sql_ or Cx_sql_ and is documented. The following paragraphs briefly introduce the most important classes. cl_sql_statement-execution of SQL statementscl_sql_prepared_statement-prepared SQL Statementscl_sql_connection-administration of Database Connectionscx_sql_exception-exception ClassNotes Note ADBC can used when access to a database via the Native instead of the Open SQL interface is necessary a nd static access is not sufficient.ADBC does not the support automatic client handling. The client ID of a database table must be specified explicitly. Note that application programs should only use data from the current client. In Multitenancy systems, this is checked by the ABAP runtime environment. Continuecl_sql_statement-execution of SQL statementscl_sql_statement-prepared SQL Statementscl_sql_connection-database Connectionscx_sql_exception-exception ClassExamples of Adbc http://help.sap.com/abapdocu_702/en/abenadbc.htm
"Reprint" NativeSql instance
