select (select max(c1) from t2) from t1 as t2
I was expecting this to work..long problem short, i summariize my
query up there. what could issue be?
i dont wnat to use common table expr (with statement..)

I'm having problems to register a view on Replication Center 9.5. When
I try to register it, I receive the following error:
ASN1562E  The replication action ended in error. An unexpected error
occurred.  Reference Code "REGISTRATION9SE".

Hello All;
I would not expect to need to do what I am asking about, but
developers and project leaders are asking for possibilities.  I am
working with about 30 DB2 databases and related applications.  One

All,
I notice that tasks executed through the Admin Task Scheduler are not
run while the database is quiesced (the db2acd process seems unable to
connect, although the task is executed under it's creator

I have a table (ABC) that is in tablespace DATA1, and with index in
tablespace INDEX1, each of which is on it's own filesystem (FS_DATA,
FS_INDEX).  The table contains data for the years 2007, 2008, and
2009.  I've written a set of scripts that:

I'm running DB2 Express C on a Windows XP box.
In the application log I see lots of these messages:
ID: 4:
2009-05-24-01.01.27.926000   Instance:DB2   Node:000

Db: db2 udb 9.5
For a db2 table is it possible to find when each of the row in the
table was last updated. Is this information internally stored in the
database?

I'm trying to find the syntax for SELECT FROM MERGE, but I can't see
anything. I need to get the number of rows inserted and updated. I'm
using DB2 9.1.
If I can't do that with MERGE, how do I rewrite this into some updates

This is a data warehouse environment.
My devlopers face the below mentioned issue while truncating a huge
table
using the following command

I Backed up and restored my prod DB into another offsite location.
Then i federated the db and created a view so the select selects data
from both Prod DB and Backup DB using a union statement.
The DB has a table that is Partitioned By Range on a Timestamp column.

In an [After Update Trigger]  we need to retrieve/access other rows/
records within same table
The reference on the IBM:
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp?topic=/com.ibm.db2
.udb.doc/ad/c0009164.htm

I'm using DB2 Express-C 9.1.2.
SQL "SELECT * FROM SYSCAT.INDEXES" throws as error:
SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: CREATOR
What does it mean?

I have a Cobol program with static SQL that references nicknames.  The
precompile gives me the following warning:
SQL1179W  The "PACKAGE" called "VSEUSER.NWAC08.FJS_FJS" may require the
     invoker to have necessary privileges on data source objects.

From a remote control center I am unable to "discover" things on this
AIX server. Interactions with the DAS get the following response.
SQL22220N  The DB2 Administration Server encountered a script error.
Script error code "17".

due to modify existing software
I have to write someexternel routines in C on sun machine,
I can succesfully combile and bind SO and BND files into dba database,
bound package is visible in control center,