Re: MS SQL Server and iSeries native database

[nelsonp@xxxxxxxxxxxxx]

RPG2SQL from RJS Software.
> -----Original Message-----
> From: franz400@xxxxxxxxxxxx [mailto:franz400@xxxxxxxxxxxx]
> Sent: Wednesday, August 29, 2007 04:58 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: MS SQL Server and iSeries native database
>
> I am looking for well tested low maint options for a native homegrown mfg database (hundreds of files) to "feed" an executive management system
> on a MS SQL Server. They prefer "near real time(within reason)", not nightly download. Many files are already triggered and could be modified to update summary files. 
> Need some way of handling that either the iSeries or the MS Server may go offline for a while and do not want manual intervention to be required.
> Would not like to reinvent the wheel.
> Can it be as simple as having the SQL Server pgms just connect & read files on the system i?  
> jim franz
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.