Skip to Content
0
Former Member
Jun 08, 2009 at 07:11 AM

Data Read from External Database to SAP

173 Views

Hi All,

My Requirement is to fetch the data from external database(INTERBASE) .

i hope for this i need to maintain an Entry in DBCON Table.

i Dont Have any BASIS Suppport Here.

So can anyone tell How to goahead with the REquirement.

My Code.

types:begin of ty_cal,

cl_cal(3) type c,

cl_s_descr(14) type c,

end of ty_cal.

data:i_test type standard table of ty_cal,

wa_test type ty_cal.

data dbtype type dbcon_dbms.

PARAMETERS dbs TYPE dbcon-con_name.

select single dbms from dbcon into dbtype where con_name = dbs.

exec sql.

connect to :dbs

endexec.

Error.

Short text

Connection ID unknown

What happened?

The connection identifier points to the data in the table DBCON

needed to establish a connection to the database system in the

context of the multi-connect. However, there is no entry

with the key "ORA".