Skip to Content
0

How to achieve BITWISE AND operation in SAP BODS

Oct 11, 2017 at 11:12 AM

46

avatar image

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

10 |10000 characters needed characters left characters exceeded

Can any one please respond..

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Oct 12, 2017 at 09:24 AM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0