Hello to all and thanks for answer to my topics.
I made one stored procedure that delete one table, but when
call/execute the procedure this show
SQL0532N  A parent row cannot be deleted because the relationship

I am trying to INSERT only the first row returned from a subselect, is
this possible?  I'm on DB2 v8 on z/OS.
Non-working Example:
INSERT into some_table (

In this function there is an element TOTAL_EXEC_TIME defined as bigint.
I'm trying to figure out a bigint of what time scale.  Microseconds,
milliseconds, seconds?
I'm trying to get the average execution time for each statement  (

I need to get a unique identifier for tables created in DB2 v8.1. I
can't use the table name because I want to use the identifier as part
of a trigger name and the table names are already at the maximum
allowed length.

I've written a procedure that extracts records from the source table
and migrates them into several other tables. For each source record
several records in destination tables have to be created and updated,
so this operations need to be done in one UoW. Furthermore, the

Hiya everyone.
I'm toying with a little db server.
It's an AMD64 X2, so dual cpu 64 bit.
It's a box with a total of 2GB of memory.

The requirement is like this..
I have to update the table with the parameters from front end like at
some times i need to update one parameters and some times i have to
update more parameters..

some user is getting error mentioned in subject and sql is 220 lines
long
how can i fix this ?

We recently migrated our production database to V8 Fixpack 12.. Since
then db2advis stopped working with following error..
SQL0805N  Package "NULLID.DB2ADVMI 0X7541505252644557" was not found.
SQLSTATE=51002..

Hi to all !!!
I have one stored procedure that update and delete rows in differents
tables,  but when I try of delete of the main table this show problems
with  primary and foreign key. I DROP these keys and after AD these

Dear DB2 experts!
I'm stuck with the following issue: from a customer I got a DB2 backup
file, created on an AIX-32 machine that I cannot restore on my windows
platform. I admit that I posses only limited knowledge on the

I have a stored procedure running on DB2 V7 Z/os  calling a COBOL
program to do some inserts.  The stored procedure have 3 input columns
and one column is of varchar(32648)
The stored procedure is being called from a V7 DB2 connect client.

DB2 V8 FP12 LUW.
My system is under heavy wait-io times.
I have read the following article: http://tinyurl.com/p844z and it says
that prefetchsize should be the product of extentsize and the number of

Does DB2 have anything equivalent to Oracle's PRAGMA AUTONOMOUS_TRANSACTION
that allows a stored procedure to BEGIN, COMMIT or ROLLBACK a totally
independent transaction while possibly (but not necessarily) nested inside a
different ("parent") transaction?

Could anybody tell us how to use block comments in IBM DB2 Command
Center .The version of the client that I'm using is 8.1.6 . I need to
comment multiple lines that appear consecutively in an SQL statement.
Also using /* ......  */ did not work as a block comment.