Tagged Questions
3
votes
2answers
124 views
DB2 error - SQL Statement too long or complex
Getting this error in a DB2 production system:
ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0101 - SQL statement too long or complex.
The statement has a large number of OR ...
0
votes
2answers
169 views
Migrate DB2 UDB (Iseries) to SQL Server
I'm looking for a tools that allows migration of DB2/UDB databases to SQL Server.
It's quite easy migrate schema and data using linked server or import export with SISS.
But what about stored ...
2
votes
2answers
367 views
Syntax changes between DB2 for i (DB2/400) v5r4 and v6r1
Does anyone know where can I find list of syntax changes between DB2 for i v5r4 and v6r1?
We are currently migrating a backing database for an application from DB2 for i v5r4 to v6r1 and found out ...
5
votes
1answer
745 views
How do I resolve this data source connection issue with Cognos?
We have (fairly recently) installed IBM's Cognos 10 as our business intelligence reporting tool. Most of the databases that we report over are DB2 9.7 LUW Enterprise Edition. We installed the DB2 ...
3
votes
1answer
173 views
What is object Server?
As I was reading article I came across IBM's site about object Server. What actually is Object Server and what are it's uses? Can this be explained for a beginner?
6
votes
6answers
2k views
On DB2, who updated a record and what did the record look like before the update?
(SQL Server 2008 R2 Standard, database under full recovery)
I have a table with fields id, firstname, lastname. A statement is executed:
insert into dbo.sometable (id, firstname, lastname) values ...
