Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
as400newbie
Starting Member
1 Post |
Posted - 2008-04-30 : 19:09:04
|
Is there an easy way to send a single record of data from an AS400 to a SQL table? I know nothing about SQL and have only transferred data to different systems via ftp. I have to send the record as soon as it is created on the 400 so another application can use it as it is received. Simple is better.Thank you |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-30 : 19:36:22
|
Since you need to send it as soon as it is created on the 400, you are going to need to do this on the 400 side. If you were going the other way around, you could handle this through transactional replication or a trigger. Does the 400 have any export capabilities?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|