I HAV 2 TABLES
   A                                                          B
A1            A2                                       B1
      B2

Ok, this should be simple, but I banging my head on this one:
Is there an Update statment that can accomplish the same as this Merged
statement?
MERGE INTO New_Table NT

I am new to DB2, I want to add one column to table which will be
storing checksum.
As in sql server checksum, checksum_Binary are build in function when
parameters string are passed which returns me integer. So are there any

Hi Friends ,
I want to know the exact difference between collection ID and
qualifier.
I also  want to know in detail : When we perform BIND operation on a

I have a task to extract DB2 table data to csv file from shell script.
i have to execute a sql query and the retreived data should be moved to
csv file. If i get a solution, ll be very much thankful
regards

Recently, I got a new client running DB2 UDB EE V7 on Windows 2000. (I
am not a Windows guy and do not like it at all.)
I found that this database is backed up (online) daily. However, I am
unable to find out where the backup is scheduled. It is not in the

After installation all the application windows remain empty. Can anyone
tell me what I have to do to get it this working? The DB2 instance is
running. Any help is highly appreciated.

I have just started working on DB2 which the syntax is a lot different.
I am trying to create a SQL stored procedure for generating reports.
I want to use temporary database which in this example it is trult not
needed but due to past experience it is key to developing good reports

I have coded a stored procedure which is planned to run only once in
production to process historic data from DB2 8.2 database.
It accesses data from a partitioned table and based on some condition
it would insert the result to another table and update the same row

some developers seem to have a good sense of humor. The following
was found after (stupid enough) restoring a DB created with FP9a on a
FP8 test-system (DIAGLEVEL=4):
2006-03-17-13.13.47.909513+060 I54072G437         LEVEL: Info

DB2 for iSeries - V5R2
I have a table with a non-unique index, column name SEDOL.
I need to extract the 2nd row from each set of SEDOL rows in the table.
If only one SEDOL row exists then select that one row.

I just dropped 350 tables, only 2 left to be dropped.
When I try to drop these 2 tables, I get the following error:
SQL0911N  The current transaction
has been rolled back because of a deadlock or timeout.  Reason

Dear friends,
I have just run into a strange DB2 problem.  Something i'd some of you
would answer, if only shortly.
My basic question is:

Hi, I'm not sure, whether this is the right place for my question. If not,
please point me to the correct group.
I have to port an application (from OS/2 to WinXP) that runs on PC and
connects to a DB2 database on MVS-host. The application is written in C and

We are facing problem with our production server. We have IBM DB2 7.2
running on Windows 2000 Server. Day before OS is crashed and the NT
admin has re-installed the whole OS again on C:\ dirve by formatting.
Luckliy we have DB2 Installation on F:\websphere\sqllib. and data file