Skip to Content

How to achieve BITWISE AND operation in SAP BODS

Hi All,

case when (columnname & power(2,(24-1))= power(2,(24-1))) then 'Y' else 'N' end

I tried the above requirement by using custom function in BODS but it takes more time to fetch the records.

Custom function:

$Result_Ind= SQL('Data_store' ,'Select case when ($ColumnValue) & power(2,(24-1))= power(2,(24-1))) then \'Y\' else \'N\' end');

return $Result_Ind;

So could you please suggest me how to do it with less time.

Appreciate quick response.

Kalyani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 12, 2017 at 09:24 AM

    Including a call to the sql function in a custom function generates an additional round trip to the database for every record processed in the Query transform. This is bad programming practice. Obvious that processing will be (much) slower.

    Add comment
    10|10000 characters needed characters exceeded