We need to export out data from db2 tables to flat files with '||'
at the
end of each record (as record delimiter).
For now, we are thinking of hardcoding the value for record

Newbie, looking at DB2 on AS400 iSeries, on Windows network.  I have
read that users are authenticated at the OS level, not at the database
level.
How do I make it possible for users to change their passwords on their

I'm trying to build a query but struggling on how to achieve the
linking.
For examples, I have a table and a view similar to this..
Table: Accounts

db2dasdiag.log file contains the following:
2007-08-16-17.52.08.081000+180 I2H210             LEVEL: Error
PID     : 1760                 TID : 3952
FUNCTION: DB2 Tools, DB2 administration server, getProcess, probe:10

can any one help me to get the number of transactions happened in a
database per day..

I hope this doesn't come across as totally newbieish, but I've been
searching the web and the IBM docs until smoke is coming out of my head.
Scenario: We are trying to take primitive "snapshots" of our production
database into a test environment by taking (what we thought are) ...

I have a coma del text file that has an email that has to go into a
varchar(4000) . This email column has CR-LP and coma as part of the
text.  when I try to import the table, i am getting a truncation error
and it reject the next line thinking its the next row.

 how to reduce the tablespace's High water mark?
 ths!

I have a newbie stored procedures performance question that I'm hoping
someone can answer.
It seems like one of the benefits of using SQL stored procedures is
that they can reduce the network traffic between the client and

I don't know much about db2 but I need to move a filesystem from a
striped logical volume to raid5? And are there any implications moving
the filesystems which hold db2 tables to sharks? Is there anything I
have to do within db2? This is an aix environment.

An apple farmer has several farms and at them, numbered boxes to hold
the fruit.  The boxes can be numbered 1-99.   The farmer has two
tables to keep track of the fruit, one that tells what fruit the box
is supposed to carry, and the other to tell how much fruit weight the

Announcement!
Best DB2 Articles was started as a means to collect and share
information between IT Professionals who work with DB2 on any platform
and in any capacity.  I have been working with DB2 for over 30 years

I am a bit new to db2, and I am unable to find a proper command syntax where
I can print values during execution in a stored procedure
Pls help.
regards,

Ist this possible to get the causing column for a sql error -530
(foreign key) in an insert command?
What I mean:
    evaluate sqlcode

Why is it that this command doesn't work in DB2.
I have to create a view in which one of the columns has to be
null(Don't ask me why that should always be null, because the view in
Oracle and DB2 should have same columns and Oracle view has col as