Re: SQL Server data to the AS/400

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 08:22 AM 9/25/97 PDT, you wrote:
>I have a client who is looking at a package which uses SQL Server as the 
>data repository.  If they purchase this package they will have the need 
>to replicate some of this data to the AS/400.   This package will 
>replace a "home-grown" PC application that allows the user to enter some 
>information and parts of that information is then uploaded to the AS/400 
>where a "monitor" job waits for it and updates other application files.
>
>My question is this:  What would be the best way to get this data to the 
>AS/400 in a pseudo real-time manner.  They want the data to be placed in 
>the same files that the "monitor" job currently uses so they do not have 
>to make any changes to the current AS/400 processing.
>
>Any suggestions?

Rich,

Maybe have an 'after' trigger program on the SQL Server table that uses
ODBC, say, to copy the record to the 400 file. Then specify the 'monitor'
program as an 'after' trigger program on the 400 file, to update the other
files.

Just an idea, from the hip

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---