Re: SQL Server Pull From Systemi

["Mark Allen" <scprideandms@xxxxxxxxx>]

Thanks all, I'll pass these on to him, but he figured it out (or I should
say we...he still can't related librarys to schemas, table to files, LF's to
views, records to rows, fields to columns) but we got a test replicate
done.  Now to rebuild all the missing pieces as soon as we figure out what
the logic should be... (don't ask, I am going to try and move this to access
the i5 directly and not this replicated, hope the SQl server doesn't reboot,
hope the kron jobs don;t hang stuff

On 10/8/07, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Mark, perhaps you and your SQL guy can spend that hour watching this
> webcast:
>
> http://www.systemiportal.com/events/view_entry.php?id=262&cat_id=4
>
> It should help you connect the dots between SQL Server and i5/OS.
>
> Elvis
>
> Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
> October 16
> 2007 System i Fall Technical Conference | Orlando | November 4-7
> Celebrating 10-Years of SQL Performance Excellence on IBM System i,
> eServer
> iSeries and the server affectionately known as the AS/400
>
> -----Original Message-----
> Subject: SQL Server Pull From Systemi
>
> One of the "pieces" we lost in last weeks SQL Server crash was a number of
> stored procedures that in  essence were set  as kron jobs that did the
> following:
>
> Delete all records from FILEA on SQL Server
> Import all records from FILEA on Systemi to FILEA on SQL Server
>
> Our SQL guy is having problems getting the SQL server to even see the
> Systemi or any files to begin doing the critical ones manually.
>
> I know he needs to set up some kind of OLEDB  or ODBC connection, but
> other
> than that I am clueless and he's been pounding the keyboard all day just
> tryign different things, googling etc without much success.  Can someone
> point me in the right direction to point him.
>
> I can last about an hr with him before we both get frustrated.............
>
> --
> 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.