Hi,
using ROWNUMBER() is affecting the plan of a view very badly...
is there a way of writing the following view to ensure rownumber()
is done as the last thing done?

I am trying to setup 2 logical nodes in a same instance.
I changed the db2nodes.cfg file as
0 db2 0
1 db2 1

db2cli.ini File is the place where various options regarding database
connection and application characteristics are given for applications
using DB2 CLI driver.
Why is the very same file (db2cli.ini) also used for specifying

We have some DB2 table on the host that has varchar(3200) columns that
are used to store binary data (I know that "varchar(3200) for bit
data" should have been used, by modifying host table is not an option
at this time).

Position Description: SUPPORT INTERNAL ACCOUNTS FOR PRODUCTION DB2 UDB DBA
NEEDS.  TASKS INCLUDE BUT   ARE NOT LIMITED TO  BACKUP RECOVERY, PERFORMANCE
AND TUNING, PROBLEM   DETERMINATION AND RESOLUTION, DEPLOYMENT AND UPGRADE
ETC.  ROTATIONAL ON CALL   AND OFF SHIFT SUPPORT ...

Why do I get SQL0104N in UDB 8.1 for Windows Command Center -
Interactive, when I copy-paste-and-execute this function from the
docs?
FWIW I have % defined as the statement terminator, but appending a %

Can we implement a view or a query that can access two DB2 database
Eg
Data Base 1
 Table: Employer

Red Hat Linux AS 2.1
DB2 WSE 8.1 FP5
I installed FP5 on my v8 server this weekend, and I think I
have found a new bug in the DB2 IMPORT command.

hi, we use db2 udb v8.1 on windows, i am trying to use federated
database objects to create wrapper, even though i have update dbm cfg
using federated yes, i still get error "the instance for the db is not
enable for the specified action", do i miss sth else?

hi, we are using db2 udb v8.1 on windows, i have a sql which is
SELECT id, oeno01, oeno22, 0,'oeftol' FROM xxx.OELTOL13_OEFTOL  WHERE
oeno01=2210728 AND oeno22=1 UNION ALL SELECT id, oeno01, oeno22,
1,'oeftoly' FROM xxx.OELTOL13_OEFTOLY  WHERE oeno01=2210728 AND

Does a type 4 driver need a runtime client installed on each client
computer? Thank you very much

Any suggestion would be fine.
I have installed DB2 Connect EE V8.1 (fixpak 4) at two different Windows
2000 Servers, both have the same regional settings.
I am connecting to the same DB2 z/OS subsystem running V7 from a DB2 Command

Hi, to everybody,
let's consider this scenario: you have 1 data-table and 10
dictionary-tables; the data-table has 5 million records and 30 columns, 10
of these columns have a foreign-key to the dictionary-tables: the

I was looking at DB2 SQL reference books by IBM and saw the maxium
size limits on CHAR, VARCHAR and other data types.
Is there a similar limit on the total number of bytes per row?  In
other words, what is the maximum number of bytes that a table can have

In a table which has an animal id, its dam id and sire id, I want to see
a combined list of all animal ids. I tried the following, which did not
work, but did not give any error messages:
select regnum from (