Ansicht
Dokumentation
09622 - SAP R/3 and the other running a legacy system.
rdisp/max_wprun_time - Maximum work process run time SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
SAP R/3 and the other running a legacy system.
thanksOrlando Luxardo Martinich
Soporte Técnico
Corp. José R. Lindley S.A.
Telf. 381-2000 Anexo 2410 Celular 900-9378 RPM 45913
e-mail OLuxardoZincakola.com.pe
"Olson, Clyde" <clyde.olsonZsap.com>
14/03/2003 04:45 p.m.
Por favor, responda a
DoNotReply@consolut.eu
Para
"'DoNotReply@consolut.eu'" <DoNotReply@consolut.eu>
cc
Asunto
RE: SAP R/3 and the other running a legacy system.
Hello Orlando,
There is a table called DBCON. This is the key to your solution.
You add a row to the table dbcon with the following parameters
con_name = some name for example PRDSYS
DBMS = DB4
User = AS/400
user id (the user must exist on the target system)
Password = whatever (not
interpreted)
CON_ENV =
AS4_HOST=as0001;AS4_DB_LIBRARY=RMTLIB;AS4_CON_TYPE=SOCKETS;
where
as0001 is the host name in the tcp/ip host name table
and
RMTLIB is the name of the library that contains the table you want to
access
Then in your abap you would put something like this:
EXEC SQL. CONNECT TO PRDSYS ENDEXEC.
EXEC SQL. SET CONNECTION TO PRDSYS. ENDEXEC.
EXEC SQL.
SELECT MYFIELD FROM MYTABLE
ENDEXEC.
EXEC SQL. DISCONNECT PRDSYS ENDEXEC.
Or...
DATA con_name(30) VALUE 'PRDSYS'.
* Open the link to the database 'PRDSYS'
EXEC SQL.
CONNECT TO :con_name
ENDEXEC.
IF SY-SUBRC <> 0.
* Error handling
ENDIF.
* Execution of DB operations
EXEC SQL.
SELECT * FROM MYTABLE
ENDEXEC.
EXEC SQL.
UPDATE MYTABLE SET ... WHERE ...
ENDEXEC.
EXEC SQL.
COMMIT WORK
ENDEXEC.
* Reset to the standard R /3 link
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
All of this changes a little if you are using an R/3 release prior to 4.6,
but you can look at note 146624 for other information.
Best regards,
Alan
-----Original Message-----
From: oluxardoZincakola.com.pe [mailto:oluxardoZincakola.com.pe]
Sent: Friday, March 14, 2003 3:13 PM
To: DoNotReply@consolut.eu
Subject: SAP R/3 and the other running a legacy system.
Hi all.
We have two iSeries. One of them running SAP R/3 and the other running a
legacy system. We want to read files from this legacy system by means of
an ABAP program. We tried it using EXEC SQL over a DDM file but we
could not did it. We have already reviewed redbook SG24-4672-03 and all
examples are based on the same computer.
Is there any other way to perform it ? Considering that we have two
different computers.
Best regards and TIA
Orlando Luxardo Martinich
Soporte Técnico
Corp. José R. Lindley S.A.
Telf. 381-2000 Anexo 2410 Celular 900-9378 RPM 45913
e-mail OLuxardoZincakola.com.pe
[Non-text portions of this message have been removed]
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
[Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
PERFORM Short Reference CL_GUI_FRONTEND_SERVICES - Frontend Services
This documentation is copyright by SAP AG.
Length: 5446 Date: 20240423 Time: 105904 sap01-206 ( 3 ms )