I want to create a trigger wich performs a write-action to a text file.
I'm intending to create it with:
CREATE TRIGGER TR_ALARMA_TSPRE
AFTER INSERT ON T_ALARMA_TS

I've got a batch etl process in which I typically wrap DML with selects
in order to capture the number of rows affected.  For example:
   SELECT 'rows updated', COUNT(*)
   FROM NEW TABLE

Hi to all !!!!
I have a question if can download the help or tutorials of DB2 to
install in my computer.
The problem is I can not be online, and need to have the help for

Environment: DB2 V8 LUW FP12.
I have a function that returns a table. I am trying to use it inside a
before trigger:
create trigger TRG.T_MACHINE_RTM

Dear Experts,
I would like to invite you to take part of my survey to share your
expertise on the storage usage for enterprise applications.
This is an educational survey for non-profit purposes, and it will be a

hi , i am trying to create such sql on db2 v8.2 on windows.
create view AP (APAM32, APNO20, APQY05, pocd01) as select APP1.APAM32,
APP1.APNO20, APP1.APQY05, COALESCE(POPT.POCD01, ' ') from APP1 left
join POPT on APP1.PONO01 = POPT.PONO01 and APP1.PONO05 = POPT.PONO05

guys help me on this rather nubish question.I have created a new data
type in java and i also want to create a new data type object in db2
that will store the money data object. The money implementation  takes
2 arguments and returns. I hava read abt user defined structured data

I was doing some research on tuning sheapthres and sortheap and ran
accross this at the boulder public lib:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/c0005404.htm
In here it states:

I am trying to create around 70 tablespaces for around 100 tables..
Am using DB2 UDB 8.2 in Linux environment...
This is one i generated through Control centre....
CREATE REGULAR TABLESPACE SNCI001 IN DATABASE PARTITION GROUP

if I have 1000 cobol insructions running in batch, and I have 1000
cobol instructions running in a store procedure, which one will be more
efficient (execute faster) or there is no difference. and in this
questions no db2 sql, simply cobol instructions!!!!

I have downloaded db2 version 9 through passport advantage.
The db2ese.lic file was included but I have my doubts if this is okay.
Db2licm output differs a lot from version 8.
My "db2licm -l" shows:

What are the advantages / disadvantages of having primary keys in lieu
of ordinary indexes ? If there are no foreign relationships defined, is
it better to have a two column index allowing reverse scans or primary
key ? Any performance or other benefits / issues ?

Our web programmer was looking in his application log an found the
following error:
2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter
- <[IBM][CLI Driver][DB2/6000] SQL0723N  An error occurred in a

I am VERY new to DB2 and have created a workingdays function to return
the working days between 2 dates, but I get some compiler errors when
running it:
CREATE FUNCTION WORKINGDAYS (STARTDATE, ENDDATE DATE) RETURNS INTEGER

Am trying to create the DDL statements of a database using
$ db2look -d TESTDB -e -z db2tar  -i testiii -w test123 -m -o
db2look.sql
I get all the useful information except that of the Bufferpools and