topic FM for SQL Select in Application Development and Automation Discussions

FM for SQL Select

Former Member — Tue, 15 Dec 2009 06:31:42 GMT

Good afternoon.

Prompt, whether is FM c which help it was possible to receive a data set, command SELECT?

I know is DB_EXECUTE_SQL, but it fulfils all DML operations, except SELECT.

kesavadas_thekkillath — Tue, 15 Dec 2009 06:59:55 GMT

Check the function group SDBI_DYNSQL , RSDU_SQL & SDBI_SQL

Former Member — Tue, 15 Dec 2009 07:10:42 GMT

I am not good in ADBC interfaces ,but you can check for below classes and package SDB_ADBC.

CL_SQL_METADATA->GET_CONNECTION  " used to get underlying connection depending on DB
CL_SQL_STATEMENT->EXECUTE_QUERY  "use the connection to get data

Please go thru ADBC documentation.

Thanks