Consider the following table (Single level of hierarchy ... No need for
recursion)
PRIMARY_COLUMN        SECONDARY_COLUMN
-----------------------------

Expert tunning Database
http://quickdba.blogspot.com/2006/05/oracle-expert-tuning-secrets_22.html

i see in this forum to make this routine using
"DELETE FROM (SELECT 1 FROM <name> WHERE <condition> FETCH FIRST <n>
ROWS
ONLY)

I'm sorry but previously command
ALTER TABLE tbl ACTIVATE NOT LOGGED INITIALLY
on table created without  NOT LOGGED INITIALLY option was impossible.
Or not?

I have one STATES table with two fields (STATECODE, NAME).
I had written following stored procedure on this table
CREATE PROCEDURE ESCRIP.STATES_GETALL(OUT @ERRORCODE INT, OUT
@ERRORDESCRIPTION VARCHAR(200))

Some stored procedures call other stored procedures.  When moving
stored procedures as part of a release this requires that you create
the children procedures before the calling procedures.
Is there a tool, script, or some other way to determine the dependency

DB2 LUW latest & greatest 8.2 FP11
Is there any way to dynamically reference the table and/or column name
in a trigger body, perhaps w/ a special register or something?
SP WRITE_AT() is passed: table,PK,operation,user,column,oldval,newval

I have a history table, and I want to select the first date occurrence
of a type 'A' event after the last event of type other than 'A', if
there is one. The best I can come up with is below. This seems
convoluted, especially compared with a cursor over the history in

  I have a problem with one of my view. Basically, I need to create a
view
to sum the amount in Table A grouped by the EMPLOYEE_ID. But I also
need the ability to limit the date range.

For the following SQL and plan
==============================================================
SELECT Q1.PLCY_KY, Q1.PLCY_TRM_EFCTV_DT, Q1.ACNTG_BGN_DT,
     CASE

DB2 V8 FP 11 running on Linux.
Given two tables:
T_SW_ID (SW_ID INTEGER, SW_NAME VARCHAR);
T_SW    (MACHINE_ID varchar, SW_ID DECIMAL (8), VERSION varchar,

I am trying to understand what invalidates Dynamic Packages in the
Package Cache.
By monitoring the Size of the Package Cache, it appears the following
does

Is there any performance issues related to having default timestamps in
tables?
I have a Data Model in which all the tables have created_tms and
last_updated_tms which I have set default value as Current timestamp.

I have an SQL script with bunch of CREATE TABLES, ALTER TABLES, ...
I'd like it to run transactially. I have found that id I run a ALTER
STATEMENT inside a transaction and then roll it back the changes disapear.
So if this works for one statement it should also for a script, right ?

I have a table with CHAR(8), CHAR(5), DOUBLE, DOUBLE, VARCHAR(40),
DOUBLE, CHAR(1). This should be roundabout less than 100 bytes per row.
The primary key is the CHAR(8)+CHAR(5).
The table holds 413896 rows so the pure byte count should be about 42MB.