Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Server to update AS/400 file
94 views
Skip to first unread message
Jack
Oct 23, 2012, 1:05:39 PM10/23/12
to
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'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
Jonathan Bailey
Oct 29, 2012, 11:22:16 AM10/29/12
to
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.
> 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
Jonathan
0 new messages