Question

极限挑战: 如何在ABAP中使用native sql连接外部数据库?

我用sm30在表dbcon中创建了一个连接"TEST", 然后运行这个程式, 但失败了. 我的SAP版本是 4.0, application server上的数据库是NT环境下的ORACLE. 是不是还要在application server上 进行什么配置啊? 哪位高人做出来过? 大家一起探讨一下吧. REPORT zkrdbtst . DATA dsn(10) VALUE 'DSN'. DATA: BEGIN OF wa, client(3), arg1(3), arg2(3), END OF wa. DATA f3(3). **Connect to external database EXEC sql. connect to 'TEST' as 'CONN' ENDEXEC. **Set connection EXEC sql. set connection 'CONN' ENDEXEC. **Execute native SQLs. *EXEC sql. * CREATE TABLE AVERI_CLNT ( * CLIENT CHAR(3) NOT NULL PRIMARY KEY, * ARG1 CHAR(3) NOT NULL, * ARG2 CHAR(3) NOT NULL * * ) *ENDEXEC. * EXEC SQL. INSERT INTO AVERI_CLNT (CLIENT, ARG1, ARG2) VALUES ('002', 9, 2) ENDEXEC. EXEC SQL. SELECT * INTO :WA FROM AVERI_CLNT where client = '002' ENDEXEC. WRITE: / wa-client, wa-arg1. **Disconnect EXEC sql. disconnect 'CONN' ENDEXEC.

Answer 1

At least one Windows application server must be available on the R/3 system and the DBSL dynamic library (DLL) dbmssslib.dll must be installed on this server. 但是这个怎么构建呀? 查看更多答案>>

求采纳