Hello, all.
DB2 vv8.2.7, 9.1.3a, 9.5
Here is a simple table function returning sequence of i (this is a
parameter) rows with one column of int values from 1 to i:

In Oracle, the most efficient way to delete a row (if using a cursor
in SQL PL) is by rowid.  Rowid is an internal unique identifier that
Oracle assigns to every row in a database.  So you would open your
cursor by selecting rowid for the rows that you want to delete, then

Has anyone seen this one before?
I have an application which was working through an XA Transaction
Manager. This applicaiton did one database update, committed (twice)
and then ended. The XA TM performed the commits and closed down

Is there a good way to delete all archive log files which aren't being
referenced by any backups any longer? I use TSM for the archive log files.
- I'm about to write a script for the task, probably by parsing
db2adutl's output. But I'm thinking that this task must be a general

I would like to do a recursive query and use the results to do an
update on a related table. .. is this possible..?
DB2 V9.x doesn't like it...
The standard recursive select works, but is an update also

Can someone tell me what I need to get connected to our AS400?
I am trying to write an app in VS2005(Data source, Gridview) that requires
data from files on our AS400. I've downloaded DB2, and installed it, but
apparently I need an additional product, "DB Connect" to actually make ...

I'm getting an unexpected error while trying to run a script in the Command
Center: SQL2001N.
The message says that an interrupt occurred but no one did anything but
launch an unsaved script in the Script pane of the Command Center and wait

Greetings all,
Had an existing single domain Win2k server that was demoted when a
Win2k3SBS server was introduced.  Upon rejoining the domain as a
member server, we find that the DB2 services won't start.  We get a

We have the following query and  is taking considerable longer time to
run.
select A.*, B.name,B.user_type,C.task_id, c.queue_id, c.workid
FROM A, B, C

I noticed that DB2 does not support bitwise operations but I found
some UDFs that seem to give this functionality..
There seems to be a consensus that bitoperations are not usefull (or
bad practice) in sql.. but I am currious though,

      I have a field which had a field of DATA TYPE CLOB and in that
I have inserted an XML.
How can I see the contents of that XML file.
Please Help

I would like to make a split mirror copy of a HADR standby database. Please
note that I do not want to create a standby with a split mirror of the
primary, but I want to make a split mirror of the standby (for a reporting
database).

I am beginner with db2 ( DB2 v9.1.0.1 running on RHEL 4); this is my
first post.
I have this error " SQL0968C The file system is full. SQLSTATE=57011""
in my  instance configured with AUTO STORAGE ON & AUTORESIZE (indeed,

The following trigger does fire if the column has a NULL or if a NULL
is updated to the column. Any ides how to fix this?
AFTER UPDATE
ON <table name>

Why db2 doesn't remove(rename) inactive logs after they were archived
on TSM ? Documentation said  the logs that become inactive ( doesn't
contain active transaction) and if they are archive logs    will be
renamed (removed).