I have been given the task of taking a 3,200 line COBOL stored
procedure and duplicating the same functionality in UDB 7.2 on the
Windows platform with a procedural SQL stored procedure.  I have
fiddled with procedural SQL stored procs on UDB, but mostly

I am running DB2 in V5R4M0 with PTF group SF99504 on level 9
-> Is this DB2 an equivalent of the DB2 UDB version 9?

I'm trying to install/configure DB2 ESE 9 on SLES 9 working as a VM on
zSeries MF.  The installation process go swiftly up to the point when
installer is tyring to run Database Administration Server, then
installation is finished with "minor" errors.

I'm trying to track down the log file into which the following failure
will be written.
---
SQL4302N  Procedure or user-defined function

i overcame with a query
"SELECT <> FROM <db name> WITH U R"
here what is that "WITH U R" stands for?

Could someone please help me with the following logged error:
DPR_UPLD: Y_KEY = '';CUST_NBR = '';SQLCODE = '-0911';SQLLINE =
'INSERT
INTO PWBPRP.XYZ  (MNP_CD,X_KEY,Y_KEY,Z_KEY)  VALUES

Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase

I'm sure some (maybe many) of the folks in the group are familiar
w/ the Gamma/Helm/Johnson/Vlissides Design Patterns book (often
call Gang of Four or GoF).
My question:  Is there any such thing for databases?  I don't

Env: DB2 v9.1 Server / Win XP. DB is enabled for Archival Logging.
Was playing around with rebuild tablespace feature. My database 'CARD'
has tablespace named t1,t2,t3.
Taken couple of individual tablespace backup as below

i have a column in a table which stores tag lines which are usually
less than 500 charecter. when we display the data  through  the
browser some character  display as "boxes" or junks. i predict it may
be the newline or carriage return character.

This is a very general question, not pertaining to any vendor or
DBMS.
What is the difference between a DBMS & RDBMS ?
Can anyone pls provide a detailed explaination on this.

I got the most strange message for which I can't find any help  ....
Doing ....
C:\>db2adutl query logs db icmnlsdb
Query for database ICMNLSDB

I am using jdbc type2 connection via "COM.ibm.db2.jdbc.app.DB2Driver",
on Solaris
I first get this error when it tries to load the native
implementation:

I'm trying to insert large polygon data via sql statement. since the
data was over 32k I had to use sqlj to insert my data.
I made a class that inserts the data. ran sqlj, generated the .java
and .ser files then used