Category: PROGRAM LIBRARY

ADBC usage with HANA as a secondary database

“ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. The ADBC methods can be used to pass Native SQL statements to the database interface”. It was a definition from SAP Help. It is obvious that ADBC can be used ABAP on HANA systems. I think there are very few advantages of ADBC method but on the other hand many disadvantages that demotivates to use.

test your SQL statement before using it in your ABAP program

For a long time i thought that there is a missing SQL console feature integrated in SAP functionality. With ABAP 7.4 and usage of Eclipse as IDE, SAP succeded to fulfill this gap with new Eclipse SQL Console. Actually before this feature, there was a similar feature that we could use for the same aim. Therefore i wanted to write down both options so that you can pick one of the suitable one for you.

COND, SWITCH, CASE, IF statement comparison

As far as i have discovered new commands coming with ABAP 7.4 (COND,SWITCH), i realized that they have some superiority over the old predecessors considering code repetition. Lately i have started to make use of COND command very often. The reason for that is SWITCH has same usage with CASE but has less code. Likewise COND provides declaring free conditions and accordingly assign a field value therefore has less code than IF. Below i have written very simple sample code for you to easily compare each of these commands.