DB2

Constraint problem
This is an actual problem in a manufacturing environment. An order goes to one and only one customer. An order will have products that are specified by either the customer or by us; there are no other sources. We use DUNS numbers to identify companies, both customers and ourselves (assume our DUNS = '999999999')... 1 Nov 2009 01:19

how many records contribute to a page.
Hi How to determine how many records contribute to a page in a table ( provided the structure of the table and pagesize ). ... 29 Oct 2009 08:43

Running db2updv95 in HADR environment
After a fixpack upgrade on Db2 LUW 9.5, can one run db2updv95 on the Primary database and have everything replicate over to the Standby? Obviously, db2updv95 cannot be run on a standby. Same question for bind of packages Primary (does bind get run on Standby?). ... 26 Nov 2009 10:49

auto commit in sql procs
Is there a default auto-commit done in sql procs? If so,how I disable it? ... 23 Oct 2009 06:39

Delete Backup History
Hi How to delete the backup history of the database without any recycle of instance or db. Thx ... 27 Oct 2009 18:07

Aligning rows horisontaly (again)
Assume we have a database with cardholders. Each physical card is customized with the retailers logo. As the cards expires there must be blank cards in stock for each retailer. The sql below creates the list I want, but is there another way of doing it using OLAP functions. with T1 As ( select RE... 23 Oct 2009 16:40

String functions in SQL
I have a need to clean up some name records in a bunch of tables - over the years names have been entered in all cap, lower case, mixed case, and some really strange combinations of punctuation. This has left us with a mess when trying to search/match client records by name. The data in question may be entered a... 16 Oct 2009 19:37

dealing with invalid date
First of all I want to acknowledge that I do not believe that the following should have been done in the first place. And perhaps I can influence those on the project to realize what a bad idea it was to go this direction. That being said, I wonder if this issue can be addressed without changing the database desi... 16 Oct 2009 08:34

How to change Enterprise server edition to Workgroup server edition ?
If you are already installed the software 1) uninstall the features specific to enterprise using db2uninst -f 2) remove the enterprise license 3) Install workgroup license using db2licm -a The easy option would be uninstall ESE and reinstall Workgroup If you are planning to install workgroup using image in Li... 1 Oct 2009 20:42

DB2 position function (again!)
Hello, In a previous thread, I asked you why my code in a prepared statement didn't work. I've again several bugs. Here's an example with the table : db2inst1(a)dev01:~$ db2 "describe select * from rsskeyword" ... 30 Sep 2009 06:48