Do you remember an old product working with DB2 V6.1 (LUW) : Net.Data ?
This product has been discontinuated in 2004, and it is said that we should
use Websphere App Server. Now, migrating thru export/import the db2 database
to version 9.1, has someone migrated in the past from Net ...

I am having some problem with the below mentioned trigger.
CREATE TRIGGER D.TBA
AFTER UPDATE OF TBAA.CIC ON TBAA
REFERENCING NEW AS NEW_ROW

Folks -
DB2 V9.2 on SUSE 9
Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path  (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out

I need to install DB2 on free *nix distro, anyone have some exp with that?
I don't have RedHat or SuSe.
Anyone tried CentOS?

I want to output something this way:
Select 'This is 'A' book' from ...
how to do this?

Would appreciate any comments on how I can move my information
integrator mapping configuration to a new machine. Will a normal DB2
backup and redirected restore work?
Thanks a lot.

db2 does not recognize '' as null?
say i have T1(C1 INT,C2 CHAR(4))
and i insert (1,'') , it would not be same as (1,NULL)
what db2 consider '' as? how does it store value '' as if not as NULL

is there a way to write a script  (not stored procedure) that looks
for all the
objects (triggers, events, materialized views, indexes, stats, tables)
created

I'm coming from the Informix world and I have a customer using DB2
8.2.3 for Linux on Red Hat Enterprise ES.
The customer is performing filesystem backups of the containers etc
every night but they are not shutting down the database server while

I'm accessing DB2 v7 on z/OS from Java running on NT (Database server
= DB2 OS/390 7.1.1)
Tried both JDBC type 4 and type 2.
I'm getting regularly SQL0407N errors like this:

I am developing a new trigger and I would like to print Old and New
values of few columns. I know I can create new table and insert Old
and New values, but I would like to have simpler solution for this.
In Oracle,

I am currently trying to create a materialized query table which
should be in-sync all the time. So my first attempt was to use the
"REFRESH IMMEDIATE" option of the create table statement. However, due
to the complexity of the underlying query, this is not allowed.

Hello I'm a newbie to this and I need help, please
My question is, we currently have a IDMS db and will be converting to DB2.
What are the things I should do?  The IDMS has not been documented very well,
and there are  a number of duplicate fields.  I was thinking about

  I encountered a problem while INSERTing a 160KB well formed XML
document into the XML field. I heard that DB2 9 can store up to 2G
bytes XML document, but my insertion was failed with just 160KB XML.
DB2 complains that the "string constant is too long" (SQLSTATE 54002).

last week , i get my db version from DB2/AIX64 8.1.10 down to DB2/
AIX64 8.1.5  .
After that , a application called "CalRate" has something wrong .
when it tries to open a cursor , it presents a error : SQL0901N The