[SAP] 查询远程数据库

Mona_1220

已于 2024-01-19 17:00:56 修改

阅读量407

点赞数 9

文章标签：数据库

于 2023-12-27 11:36:27 首次发布

本文链接：https://blog.csdn.net/Mona_1220/article/details/135241524

版权

查询远程数据库数据至内表

DATA: lo_connection TYPE REF TO cl_sql_connection.
  DATA: lo_statement TYPE REF TO cl_sql_statement.
  DATA: ld_result TYPE REF TO cl_sql_result_set.
  DATA: lv_sql TYPE string.
  DATA: l_ref_cnt           TYPE REF TO data.


  lv_sql = |select * from "/BA1/HKULT"|.

  TRY.
      lo_connection = cl_sql_connection=>get_connection( 'DBCON' ).
      lo_statement = lo_connection->create_statement( ).

      ld_result = lo_statement->execute_query( lv_sql ).
      GET REFERENCE OF lt_data INTO l_ref_cnt.

      CALL METHOD ld_result->set_param_table
        EXPORTING
          itab_ref = l_ref_cnt.

      ld_result->next_package( ).
      ld_result->close( ).
    CATCH cx_root INTO DATA(l_ref_cx).
  ENDTRY.