Please correct me if I am wrong
1. no 2 processes can have exclusive lock on same object (by object,
same row or same table)
2. on deadlock incident between 2 processes only one of them will be

I'm fairly new to DB2.
I have been assigned to build a delete trigger that finds the data
type of each of the table's fields so that the trigger can then build
a string consisting of OLD values pre-wrapped in quote marks as

 I'm having a really hard time trying to figure this out so any help
would be great.
I'm working on DB2 V9.5 but I think my problem is generic sql.
I have 2 independent sql queries which are very similar with just a

Just want to know if there is a sleep command I could use to slow down
the process in a stored procedure. I know people would've asked this
question. I googled it, but everyone said that they haven't used in
the stored procedures. I want to know if the sleep cannot be done

Quoting http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/
com.ibm.db2.luw.sql.ref.doc/doc/r0000935.html :
 Group privileges are not considered for any table or
 view specified in the CREATE VIEW statement.

Data Studio Developer is only distributed on Windows and Linux/Intel.
This product is based on Eclipse and integrates Java code to provide
the capabilities of the product.
Part of the I(ntellectual) Property is from IBM so we can understand

I am new to DB2.
version info DB2 9.5 , Linux
some more info:-
create bufferpool bp1 size 140000 pagesize 8K ;

Background: The Payment Card Industry (PCI) Data Security Standard
(PCI DSS) is a standard for financial institutions. It requires
sensitive information, such as credit card numbers, to be "unreadable
anywhere it is stored" using hashing, truncation or encryption.

Learn DB2 system catalog tables
http://db2examples.googlepages.com/systemcatalogtables

DB2 V8.2 on AIX using C language applications.  I have these two
queries I would like to put together:
"SELECT SUM(products.loc1_size) FROM products WHERE (location1 =
'NFUSA1') AND (main_loc IN (SELECT main_loc FROM status WHERE

Environment is DB2/LINUX 9.5.0.
I wonder if it is possible to set the MESSAGE_TEXT dynamically when
using the SIGNAL statement.  The objective is to return more specific
information to the calling user or application. E.g. I would rather

Chris Eaton created a SP to to transpose rows to columns :
Here is an example of a rowtocol stored proc that takes a SQL statement as
the first paramter, a delimiter as the second parameter and the ouput (in the
3rd parameter) is the rows coverted to a column with the delimiter ...

I dont know whether this query exactly fits to this group or not.
Actually I am having a Application written in C++ which uses CLI API
to perform database operations.
Currently it is working on DB2 v8. now i want to move this application

I'm moving a mysql database over to using db2 V9.5
The database is used by our radius server to store network accounting
information from our switches.
One parameter is the length of a network session in seconds.

I understand at a high level database concepts and have come from SQL Server
and Windows
Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about control