I have:
select myTable.*,  
Case
When myTable.problem_CLOSE_date = myTable.problem_creation_date   then

Visual Basic 6.  ADO 2.8
I have an as400 DB2 V5R1 datasource.  Dates are defined as *ISO format
and have a range from '0001-01-01' to '9999-12-31'.  I am trying to
update a date field on the database with a value of '0001-01-01'

In a data warehousing application, what is the impact of imposing
referential integrity on the database side? Does it help or degrade the
performance considering the complex transformations that take place during
the ETL process.  I  have read a few articles suggesting not to impose

The way authorities are granted in DB2 are very vague.In one of our
production systems the users under staff group in AIX have sysmon
authorities and i have checked dbm cfg and there sysmon_group is empty.
So how every member of staff have sysmon authority.why so?

       I have an ODS for which I need to do a full online backup. It
is taking us 1 hour and 44 minutes to do this. The command is below:
db2 "backup database $DBNAME ONLINE to $DBPATH with 4 buffers buffer
4096 parallelism 2 compress include logs without prompting"

LUW V8 FP 12.
My application issues INSERT statements into a table:
INSERT INTO TABLE_A values (ID, TIMESTAMP, VALUE1), (ID, TIMESTAMP,
VALUE2), (ID, TIMESTAMP, VALUE3) ...

  I have DB2 8.1 on my system. I have created a procedure as follows.
CREATE PROCEDURE DB2ER000.XYZ() LANGUAGE SQL BEGIN INSERT INTO
DB2ER000.A
             ( C,D,E) VALUES (10,20,30);

I am currently facing a situation on migrating our DB2 UDB 8 Database
which sits on our AIX server to be migrated to DB2 UDB on mainframes
which is a version of 7.
I was not able to find any manuals on IBM site in relation to  the

My aim is to develop a SQL procedure to create a tablespace which a
qualified end-user can invoke/run.
Since tablespace creation requires SYSADM or SYSCTL authorization and I
want this to procedure to be run by qualified end-users (actually an

It is found that a DB is setup for sometime.
One day, the user suddenly cannot connect to DB.
We found that the case is as follow:
1. User can connect to DB by issuing command

       I am running into a problem ( only in this particular instance).
       I insert one row into a table - takes a fraction of a second
       try to do a bulk load of the same  --> takes 10 seconds.
      Anything that I need to be looking into to identify why bulk load

I"m just getting into DB2 and I'm not getting the node name alias
thing.
Are they just arbitrary? Something used for the purposes of easy human
recognition? On the server side, it seems that DB2 will use the name

I got error, SQL1768N  Unable to start HADR. Reason code = "7", when I
tried to start hadr primary database. Here are the hadr configuration
of my primary db:
HADR database role                                      = STANDARD

DB2 8.2 for Linux, FP 10 (also performs the same on DB2 8.2 for Windoes, FP
11).
Using the SAMPLE database, tables EMP and EMLOYEE.
In the followng stored procedure, 2 NULL columns (COMM) are selected into 2

I tried to do a LOAD in a scriptfile and get after the success LOAD an
error.
Look at the output:
...