I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which
are the possible ways to do it? Any help...

I am writing a SQL Procedure. I have to capture the exceptions after
the insert statement. Could you please suggest me the best way to
capture and the appropriate systax for that.
Thanks in Advance,

On running a load, I get the following summary:
What are the rows deleted ? There were more rows thatn that there to
begin with.
Number of rows read         = 64692

Is Admin client is mandatory to use db2exfmt ? I've only run time
client now so unable to generate the access plan using db2exfmt.

Environment:
DB2 v8.1with fixpack 9 on AIX, SQL bi-directional replication.
Server A: capture process
Server B: capture and apply process

I am new to DB2
I am converting an Oracle database to UDB.
There is a procedure that builds and writes ( line by line, manually )
delimited rows to a file.

we have a procedure with following structure ...
Insert into some regular tables using a unique 'call_id'
returning a cursor to caller with the rows relevant to this CALL .
CREATE PROCEDURE

Suppose i have a table which holds thousands of records with the
following structure
CREATE TABLE "test  "."T_CNTRY"  (
         "CNTRY_CDE" CHAR(2) NOT NULL ,

Could any one tell that, how to handle the exceptions mainly after the
insert statement.
I am writing a PL SQL Procedure, it must capture the exception if any.
Also I need the error description for that errror.

i need the odbc driver to connect to a remote db2 databse. I have
installed the IBM "run time client 8.2" which i have downloaded from
the ibm site. I install it and add a new Datasource with the "ODBC
system administrator" Tool in Windows (2000). When i then try to

is there a good visual modelling tool for db2? I used to use fabforce
DBDesigner but it seems to produce sql statements don't work well with
db2? Is there a tool from IBM, because I would access for academic purpose.
Regards,

I'm new to stored procedures, however, the passing of parameters using a
group item in the calling cobol program seems incorrect to me. Would
this work?
Calling COBOL pgm is calling a stored procedure using a group 01 level

DB2 LUW versions v7 and v8
We have an application that opens a cursor, retrieves the result set
into memory and summarizes it, saving data into another DB.
Due to high network bandwidth usage, we have decided to implement the

I have following requirement.
1)to find size of DB
2) no of rows in all tables in Database.
3)update date of all tables in Database.

Is it possible to take Exam 701 ( IBM certified DBA for LUW) without
Exam 700 (DB2 fundamentals) .
http://www-128.ibm.com/developerworks/db2/library/techarticle/0207fosdick/0207fo
sdick.html
(section : How to certify ) says the Exam 700 is a REQUIRED entry test.