Jonathan Benn Jonathan Benn - 5 days ago 6
SQL Question

How to get the row count via ADBC native SQL?

I can do the following query using Open SQL:

select count(*) into lv_count
from prcd_elements client specified
where waerk = 'USD'


How do I do the same thing with ABAP Database Connectivity (ADBC) native SQL?

I've tried the following but it gives me an exception... I'm not sure what data type I need for
lt_table
to hold a count, and class
CL_SQL_RESULT_SET
(returned by
execute_query
) seems to require a local table.

data lt_table type standard table of prcd_elements.

data(lo_sql) = new cl_sql_statement( ).
data(lo_result) = lo_sql->execute_query(
|select count(*) from prcd_elements where waerk = 'USD'|
).
lo_result->set_param_table( REF #( lt_table ) ).
lo_result->next_package( ).
lo_result->close( ).


Thanks!

Answer

With some help from a few mysterious benefactors, I figured this one out. I needed to create an internal table with a single column of type I (Integer), and then extract the count from this internal table.

types:
  begin of s_count,
    count type i,
  end of s_count.

data lt_table type standard table of s_count.

data(lo_sql) = new cl_sql_statement( ).
data(lo_result) = lo_sql->execute_query(
  |select count(*) from prcd_elements where waerk = 'USD'|
).
lo_result->set_param_table( REF #( lt_table ) ).
lo_result->next_package( ).
lo_result->close( ).

data(lv_count) = lt_table[ 1 ]-count.
Comments