Questions tagged [iseries]

IBM mid-range computers, previously called AS/400

Filter by
Sorted by
Tagged with
3
votes
5answers
1k views

SQL Query with ODBC, Joins and Group Bys

I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
5
votes
2answers
61k views

How can I enable distributed transactions for a linked server?

I have a SQL Server 2012 instance with a linked server pointing to a db2 database on an IBM Iseries system using the System i Access ODBC Driver. I'm trying to enable distributed transactions. I ...
1
vote
1answer
1k views

SQL statement slower on as400 console than from remote odbc [closed]

I am having a strange problem on one of my i systems running 7.1 I am using jdedwards 8.0 as erp but the issue is not related as i just found out. After some research it came down to this. I run the ...
0
votes
1answer
253 views

DB2 select from final table update gives SQL0199 error

Goal: I am trying to retrieve records that were affected by UPDATE query. Based on IBMs article I can use the following query: SELECT empno, salary FROM FINAL TABLE (UPDATE employee SET salary = ...