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 like all data first is retrieved to SQL-Server, updated at SQL-Server and then finally sent back to the AS/400 and comitted.

Do any one know a working pass-through-method for updating ?

I've tried using openquery like:

Select * from OPENQUERY(AS400, '

UPDATE  AS400.S1019865.NSCDEVDATA.WSZZP100

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

It does not work.

Any suggestions ?