Skip to Content
0
Oct 06, 2016 at 09:19 AM

Connecting External database with DBCON with SAP.Net Connector

97 Views

Hi Experts,

We have a scenario that requires to read data from External Database (e.g. Sybase IQ) through SAP and .Net Connector. A DBCON configuration already setup and verified connecting to the External Database. However, we are stilling missing the link to invoke query data from selected DBCON. After some research, I could only found solution to get data from DBCON thru ABAP program with this reference. http://scn.sap.com/docs/DOC-28819

Is it possible to have same operation SAP .Net Connector?

REPORT ZSAP2ORACLE.

data: l_record(20).

* opening the connection to database

EXEC SQL.

CONNECT TO 'MYCONNECTION'

ENDEXEC.*executing the select command

EXEC SQL.

SELECT ars_no into :l_record FROM arsdata

ENDEXEC.*closing the connection

EXEC SQL.

DISCONNECT :'MYCONNECTION'

ENDEXEC.

WRITE: / l_record.

Thanks