If I create a procedure with BEGIN ATOMIC block I know these means that when
an error occurs all the SQL statements will be rolled back.
The question I have is:
If I select all records form a table and process them. The processing of

I want the criteria like this.
I have 10k of rows in my table and i have to fetch first 200 rows . And
next time when i execute the same query it should fetch next 200 rows
and that should be continued .For that is there any query for my

I want the criteria like this.
I have 10k of rows in my table and i have to fetch first 200 rows . And
next time when i execute the same query it should fetch next 200 rows
and that should be continued .For that is there any query for my

If we want to replace our current production server with DB2 UDB 8.1 on AIX 5.
3 and use redirected restore for the production databases to be “copied” into
our new db2 with server. Which backup is more appropriate for our databases
that have not too much but constant data change? ...

4) If the following commands are executed:
UPDATE DBM CFG USING DFT_MON_LOCK OFF
UPDATE MONITOR SWITCHES USING lock ON
And the DB2 instance is stopped and restarted, the monitor switch for

I need some very basic help.
I've just downloaded and installed db2 Express-C on SLES v9. I ran in to
the problem were you get a java error if you select typical install and
found the answer on IBM's db2 forums. So I was able to get it installed

How can we do an online restore of a tablespace using the incremental
backup's? we are on a partitioned database...
Also, how could we use backup copy made by the load (using the copy to
option in load) to revover the tablespace?

I received this error message while  executing an application
    SQL0901N  The SQL statement failed because of a non-severe system
error. Subsequent SQL statements can be processed.
(Reason "column number out of range".)  SQLSTATE=58004

Hi Frnds ,
I want to debug a stored procedure.
It is written in SQL. I am using Developement center for creating
stored procedures.

How to design a generalized database that is used to store datas from
any other database. The thing is that the tables and datas of the
source database is not known while designing this target database. The
design should be a generalized one to store data from any database. Can

Is there a way to export the tasks from Task Center to script files? Or do I
have to use copy&paste into a text editor....
I want to do this for documentation purposes.
Regards

We have an update sql that was running OK for several months completing
in under 2 minutes . Yesterday something changed and we had to kill this
update after it ran more than 6 hours. Update input table contained the
normal 100K rows and master table contained about 135 M rows.

I am trying to find the memory usage in db2, i've posted several topics
here but never found the answer,I would really appreciate any help ...
my question is i see 95 % of memory on my production machine being
used, but can't find what db2 processes are using it up?

One the more frequently asked questions is how to "sum" up strings by
virtue of concatenating them in an aggregate function.
Her eis a rather simpel solution that may be worth sharing (you'll be
teh judge):

Hi, I'd like someone to help me please...
I have installed DB2 ESE and DB2 Connect in Windows XP and I want to
connect to an AS400 server to create and manipulate databases in there.
I tried to connect to through the configuration asisstant and the