embedded native SQL(EXEC SQL) method to connect HANA as secondary database

Another Top-Down approach of HANA usage is EXEC SQL method which you write SQL commands between EXEC SQL/ENDEXEC lines. Difficult side of this approach is you will be dependent to static special SQL statements which does not follow ABAP syntax. For example in order to connect the HANA database ” connect to : ‘HDB’ ” statement is used. In DEMO_EXEC_SQL program you can find more samples including create/insert/read/delete statemens or check SAP Help for more details. Below i have shared a code to get a list of tables and view in your HANA db. Here i have used native SQL method to connect HANA and open/fetch/close database cursor SQL commands to extract data.

 

 

You may also like

  • delete EOIO messages from queue (0)
    Last time i have written a post about cancelling erroneus EO messages . Now what if the same problem occurs for type messages. Actually this case is worse as the first error message in […]
  • transport SO10 standard text objects (0)
    In smartforms and sapscript technologies standard texts are used for outputting fixed texts like company information, address or other templates. These standard texts are created from SO10 […]
  • add custom button to display with REUSE_ALV_GRID_DISPLAY (0)
    If you want to add a new functionality to your ALV toolbar with a custom button , you can copy from to your custom program and modify your standard pf-status. In order to activate your […]