The iseries tag has no wiki summary.
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 ...
5
votes
1answer
772 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 ...
4
votes
1answer
473 views
SQL Server OPENQUERY vs Regular Query against AS400
I log into a SQL Server database which has an AS400 server as a linked server.
I've discovered that running queries against this AS400 server is MUCH faster if I run the select in an OPENQUERY...
...
3
votes
2answers
147 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 ...
3
votes
1answer
182 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?
2
votes
5answers
335 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 ...
2
votes
2answers
383 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 ...
0
votes
2answers
175 views
Is there a SQL Server equivalent to “OVERRIDING USER VALUE”
While googling I found about the OVERRIDING USER VALUE parameter for an INSERT for IBM's iSeries.
Is there an equivalent command for Microsoft SQL Server versions 2005 or newer to allow you to ...
0
votes
2answers
176 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 ...
0
votes
0answers
28 views
Duplicate Customer Records for SQL Query from ODBC with Joins and Group Bys [duplicate]
Possible Duplicate:
SQL Query with ODBC, Joins and Group Bys
I am getting duplicate customer records with the query below. The main purpose of the query is to pull a list of customers into ...
-1
votes
1answer
99 views
AS400 CL Programming - Export Summary data to Excel [closed]
I'm new here!
I can already export detailed reports from AS400 QM query (WRKQMQRY).
But, Here's the issue:
I'm summing data and then returning the summary data, but I want to produce an Excel file.
...
