I'm playing with scripts to gather database size and count information
- can anyone tell me what the capacity output of the get_dbsize_info
procedure includes? It's about 25% larger than the number I get adding
up allocated pages (multiplied by page size, of course), and even if I

When you're constructing sql in php or anywhere else and don't know
whether an INSERT will work, use MERGE with a VALUES clause as shown
below rather than either intercepting the diagnostic or doing a SELECT
to check first.

I am currently on a project which the source data come into the
databases is always dirty (not surprisingly); however, due to the
design of the database, it is very difficult to impose referential
integrity (esp. Foreign Keys) on these tables. Am I just not thinking

I have a field which has data as YYYYMMDD, and I have to find the age
of the person by substracting it from current date. can you please
please advice...
thanks

I tried this:
ALTER TABLE Dokumente
DROP COLUMN docPrioID
but I get this errormessage:

Maybe someone has an idea for this:
table "customer_article" contains prices for every article by customer
and has about 400.000 now.
customer char(5)

Running DB28.2 on AIX 5.2.
I have two questions if its possible for anyone to assist.
1. Is it possible to make use of a 'Shadow Catalog' on DB2 UDB v8.2 on
AIX?  If so, how? Can anyone give me an example of the SQL to create

I'm looking to materialize out a pretty complex query/view to
facilitate retrieval of the underlying data for presentation to a
screen. Given the table sizes and a few left outer joins the query
itself can take minutes to return (and only actually returns a couple

I am accessing db2 for zOS from a windows xp client and trying to find out
how many times a select or update sql statement is executed.
I am able to do this easily in db2 for windoze by by bringing up the monitor
and generating a pre-defined report.  I can also do it thru sql ...

Please update the DB2 documentation as follows:
The DB2 Data Recovery and High Availability Guide and Reference clearly
states that tablespace paths (or relative paths) must be the same on both
primary and standby databases so that DDL statements (for containers) can be

I need to compare two columns in two tables and to find the rows with
partially matched result. For example, 'Jim' is deemed as matching
'Jimmy' and 'Jeff ' as matching 'Jeffery'. In Microsoft jet
(or in sql server similarly) this can be done by using:

Folks,
 We have table that cointains timesheet entries for the employees.
 Given user name, start date, and end date I want to get sum of hours for
 each project, for each week.

Hey hey all..
I'm using a DB2 8.2 in an 64bit environment in SLES9.
Server is a HP Proliant DL385
For storage I'm using a NetApp Fas250 filer.

___________________________________________
ENVIRONMENT
___________________________________________
(1) Server = DB2 UDB DPF, 8.2.3 on AIX, 64-bit instance.

///C# Code
OdbcConnection con = new OdbcConnection(connection string);
con.Open();
OdbcCommand cmd = new OdbcCommand("select nsilunique_id from