On Tuesday, 23 October 2012 18:05:39 UTC+1, Jack wrote:
> Hi, We're running Microsoft SQL Server 2005 under Windows Server 2008. We're running an iSeries under V5R4. In SQL Server, I have a table with an update trigger linked to it. The trigger will perform an update in an AS/400 file (a WHERE condition will be used). My question is: For performance consideration, what would be best suited in the trigger? Thanks
We used a similar situation with some triggers & AS400 updates but I couldnt be sure what we used. I know that sql server people said not to use cursors, and of course we find creating sensible access paths on the as400 speeds up activity there.