469,632 Members | 1,772 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

AS400 to AS400 connection

Hi All

I am creating a database trigger to write details real time from tables
on one AS400 to another over our WAN. Is there such a concept as ODBC
connections on the AS400 to
perform this task and if so can anyone explain how I would configure
such a connection.

There will be a process on the receiving AS400 waiting to process the
data as soon as
it is received.

All provious data transfer between AS400's in our organisation have
been using SAVF
and FTP but this is a differnet issue.

Thanks in advance for any help offered

Iain

May 19 '06 #1
1 2079
Iain racontait dans comp.databases.ibm-db2:
Hi All
Hello

I am creating a database trigger to write details real time from
tables on one AS400 to another over our WAN. Is there such a
concept as ODBC connections on the AS400 to
perform this task and if so can anyone explain how I would
configure such a connection.

You can configure a remote data base (using WRKRDBDIRE), and use it
through SQL interface :

CONNECT TO blablabla
INSERT INTO blobloblo

There will be a process on the receiving AS400 waiting to process
the data as soon as
it is received.

All provious data transfer between AS400's in our organisation
have been using SAVF
and FTP but this is a differnet issue.

Thanks in advance for any help offered

Iain


--
Cordialement/Best regards
Marc Rauzier
May 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by alan_sec | last post: by
4 posts views Thread by Matthew Wells | last post: by
13 posts views Thread by Sehboo | last post: by
4 posts views Thread by Brad Allison | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.