I have a problem when I try to open the tables list on a database.
I work with 8.2.0 Enterprise Edition.
The control center return this error:
[IBM][CLI Driver][DB2/NT] SQL0104N E' stato trovato un token "SELECT

I have a table with over 97M rows and a primary key:
(px int,
sx int
effectivedate date)

The continuing saga of Ian trying to learn DB2-SQL
18. CASE Statements
Are these even possible:
SELECT

I have encountered a problem in passing a VARCHAR parameter (which is a
list of accepted values) to the IN predicate of a DB2 user-defined
function.
For example, I have a table (mytable) storing ppl names & their

Guys,
I'm trying to determine if the application is issuing semget() calls
and fails. Hence I issued the command
truss -d -o truss.log db2 "connect to dbname"

I'm trying to change a column on a DB2 table so that it has a default value
but I cannot get it to work. Does anyone have any experience in this area.
I'm trying with this statement:
Alter Table x

Hello, all.  Was hoping someone might be able to help us out with an
issue:
We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server; we'll call this one

Let's say that I have a table TABLE1 in schema A and in SCHEMA B.
I have a stored procedure that does a select from A.TABLE1 and inserts rows
from that select in B.TABLE1.
When the procedure is running and I do a SELECT * FROM A.TABLE1 then this

can someone plz help me on this one
i need to fetch the first record from every group of records with the
same emp id.
i cannot use group by because i want to fetch all the fields

Hi;
In db2 8.2, how do I limit a query resultset to x rows?
Thanks,
nat

DB2 V 8.1.6 and DB2 V8.2.4
I'm using a  Fact Table and 7 Dimension tables in a MQT definition.
create mqt1(col-list) as
(

Hi ... We are running v7.1 on Linux Redhat 7.2
All things were fine, until the power supply of the box fried
after 4 years of un-interrupted service (2 reboots only)
Replaced the power supply, and all (well almost) is working 100%

For the table given below
PK1   spk1    STATE1       PROV1      PLAN1
pk2   spk2    state2       prov2      plan2
Tried the query for the above table( using a self join)

Single partition DB2v8.1 FP7 on AIX 5.2.
I'm trying to determine whether we're archiving logs directly to tape
(and not to disk) using TSM. Without knowing from which sample it was
compiled, is there an easy way to find out how db2uext2 is configured

I have a database restore that hasn't finished because it ran into a
problem with not enough memory to complete the restore utility.
However, I cannot update the db cfg to allow enough memory because I
cannot connect to the database because the restore has not completed.