Hi.

I am very interested in the row-level security in 2005, i.e. where you can assign rights not only to a table, but also to individual rows.

This is very powerfull, when...

I found a good and fast solution for updating linked AS/400

It is the same solution that Ken LaRoy suggest

UPDATE OPENQUERY(ISERIES, 'SELECT * FROM Library.File WHERE field2 = ''00248000'' ')

SET field1...

Hi.

I have problem when updating large tables (> million rows) using traditional

4 level naming in update like:

UPDATE  AS400.S1019865.NSCDEVDATA.WSZZP100

SET ZZSSRV = '2006-02-08 09:00:19'

It works but is very slow.

It seems...

Hi.

I use Microsoft OLE DB Provider for DB2  (DB2OLEDB) for linking to AS/400 from SQL-Server 2000

I use OpenQuery for all reading (best performance)

Have no problem with updating the...