Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: iseries
Linked Server Between SQL Server and iSeries is rounding decimals
Question : We just set up a new SQL Server 2008 database, and I got the link set up between […]
SQL Server – Query Over Linked Server to IBM DB2 throws an error
Question : We have a partner that uses a IBM DB2 iAccess database, which we connect to using a linked […]
Error updating zoned field from SQL Server stored procedure linked server to iSeries
Question : I’m trying to update a table on an iSeries (AS400) within a SQL Server stored procedure using linked […]
How to resolve foreign key references across different databases (iSeries and SQL Server)
Question : I’ve got a system that has a DB2 iSeries database. We are rewriting a portion of the system […]
How we can design best optimized solution: Generate huge random numbers and check in database table whether this numbers are there or not
Question : We have one table like: Table Name: random_number_series Its columns are as below: number [numeric(10)] name [varchar(10)] status […]
How can I enable distributed transactions for a linked server?
Question : I have a SQL Server 2012 instance with a linked server pointing to a db2 database on an […]
SQL Server OPENQUERY vs Regular Query against AS400
Question : I log into a SQL Server database which has an AS400 server as a linked server. I’ve discovered […]