Hallo colleques,
I get during the following error message "SQL1035N No database manager
command was issued. SQLSTATE=57019", when issuing the following
command on the Command Line Processor:

I need to convert a decimal field to char() but also trim the leading
zeroes. Any idea? I could not find any function to do that.

we installed db2 v8.1 on red hat linux 9.
Unfortunately, the backspace and the delete button doesn't work in the
right way. Instead of deleting chars, control characters are inputed.
That makes it very hard to input sql commands at the db2 command line

On occasions we have failures and in the db2diag.log this is in the
log identifying the failure. Please let me know if I have this right.
Obj={pool:1;obj:2;type:128}
pool is the tablespace id

Hi,
Does anybody have any relative performance comparisons of SQL
Procedures and
SQL Functions?

From time to time, the group receives questions about zrc= or undocumented
db2 return codes (hex or dec).
I'm just posting the link for future reference.
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&uid=swg21066178&lo
c=en_US&cs=utf-8&lang=en+en

Is there anyway in DB2 to convert rows to columns?
In other words, if I have the following table below...
MemberID    AccountNum     ZipCode
------------------------------------

I would shortly be working on DB2 UDB 8.1.2. I have no prior DB2
experience and need to be involved in the installation, maintainence
and tuning of the database.
Could you please recommend the best books around which will detail how

I am doing my first database project using java servlets.
We are going along fine but I have a question about how should one
access a database.
We have the URL, userid and pwd in a text secured file or maybe in

Helpful folks,
I have recently migrated our test server, which runs Win NT 4, from
V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I
am having major problems getting the previously defined federated

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.
Right now I am using DB2 connect version 7.2 to connect to db2 version

Please let me know.
thanks.
TP

Does Db2 version 8 require a 64 bit machine or will it work on
os390/zos non-64 bit machines?

I have been working on try to create web-based paging for our tables
which have over a million rows.
Based on what I have read, I have 3 options
1. retrieve all rows in resultset - not possiblefor me coz of the size

I'm currently experiencing a problem using ADO 2.7 with DB2 7
(DB2 UDB FOR OS/390 V7). I use ODBC like datasource.
After populating a disconnected recordset, reconnecting it, and doing
a UpdateBatch the application (VB6) disappears - it just stops and