How to achieve BITWISE AND operation in SAP BODS

[kalyani_kolli]

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

[kalyani_kolli]

Can any one please respond..

[former_member187605]

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.

[kalyani_kolli]

Can you please suggest the other solution for this problem..

[former_member187605]

Implement the logic in a custom function (without calls to the underlying database).