Is there a way out to Print on the console during the execution of
Stored Procedures.

I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am
getting an error message telling me, that the routine could not be
found in the library path.
[IBM][CLI Driver][DB2/NT] SQL0444N  Routine "*_deposit" (specific name

In DB2, is it possible to update a table having a BLOB using
a statement such as "SELECT MY_BLOB_FIELD FROM MY_TABLE FOR UPDATE"
Then getting the Blob and writing to the Blob's output stream ?
I'm getting an AbstractMethodError suggesting that the DB2

Is any tools on market to replace UDB Admin client ?
Looking for   following options
1. Create task
2. Execute task

All:
Supra DBMS maintains logical links internally and provides data in the
way it was inserted.
When I move to DB2, how can I make sure that I can create a LIST OF

I'm able to connect to a local DB2 database, but unable to connect to a
remote DB2 database from Crystal Reports XI. In the control center I
have no problems connecting to the remote databases. SQLCODE is 30081,
SQLSTATE 8001.

I've downloaded FP9 for DB2 V8 for Linux (MI00105.tar). But it is not
possible to install. It says I should get an image for the kernel 2.6.
In the readme I found, I should install MI00117.tar. Where to find?
Regards,

I need to move a complete Schema from a iSeries (V5R3) environment to UDB2
V8.1 on a Windows server. This is a process that I need to run on a
regular basis. Any suggestions on tools or process would be appreciated.

Please let me know if any of u know any links or documents which
provides any coding standards for developing DB2 Stored Procedures.
I am in effort of building a comprehensive document on Coding Standards
on Stored Procedures.

How to get the header values in the sql with union.
For example,
select deptno as dep,deptname as dname,location as loc,mgrno as mgr
from dept

Thanks for your attention..I appreciate that.
-----Problem description -----------Start----------------------
Database : DB2 UDB 8.2 on Windows 2003
Client: VB6/ADO 2.7 on Windows 2003

I got a problem while loading a table on DB2 database. It is saying that
transation log is full and do more commits in between. Is it done by a DB2
or can I fix this at BD2 server?
Thanks in advance,

Db2 version: 8.1
OS: Windows
I have 2 questions:
1) What is the optimizer which db2 uses, rule based or cost based? If any

Sorry if I disturb this ng but i need to someone because I'm cry !
For my problem, and now I think for my .... i don't know I try tu put in C
program this peace of code, after the connect !
       EXEC SQL BEGIN DECLARE SECTION;

When you get the message :
String data right truncation. SQLSTATE=22001
What is usually the source of the problem?
Might a null value assigned get a PreparedStatement's