SAP Connect to external database

EXEC SQL.

CONNECT TO ‘BSK’

ENDEXEC.

EXEC SQL.

SET CONNECTION ‘BSK’

ENDEXEC.

EXEC SQL.

SELECT db_name() INTO :DBN FROM SVERS

ENDEXEC.

WRITE: / ‘current database name’, DBN.

EXEC SQL.

SET CONNECTION DEFAULT

ENDEXEC.

EXEC SQL.

SELECT db_name() INTO :DBN FROM SVERS

ENDEXEC.

WRITE: / ‘current database name’, DBN.

It’s basic Native SQL ? ABAP. Some SAP notes for reference.

Note 178949 – MSSQL: Database MultiConnect

Note 323151 – Several DB connections with Native SQL

Serkan AKKAVAK

Computer Engineer BSc

SAP Department Manager

Contact : serkurumsal@yandex.com