I am currently using DAYOFWEEK function and putting CASE statement to
get english day name. For example:
SELECT
 CASE DAYOFWEEK(CURRENT DATE)

I've just installed FixPack 7 on top of 8.1(5).
When I start db2cc I get 'This application failed to start because
icuiodb226.dll was not found'.  The control Center appears, and
something is working.

Hi ther
I'm new in DB2, currently i'm into java developmen
The problem that i'm facing is that when i use JSP page to save, th
date is correct when i pass(from JSP page) to database, but when

VALUES DB2XML.Content(DB2XML.xmlclob(CLOB('TEST1')), 'C:/Test1.xml');
SQL0443N  Routine "CONTENT" (specific name "*MLCONTENTCF") has returned
an
error SQLSTATE with diagnostic text "DXXC003E  Unable to write to the

Situation:
New server running Win2k3 with Active Directory.  DB2 scripts run fine
in Task Center.  Windows (OS) command scripts do not complete on their
own.

I am writting some user defined functions in out development mainframe
environment. How does these functions get migrated over to production?
What all is involved? Is it just that DBA should run the UDF SQL in
production?

We are getting ready to upgrade to FP10. If FP11 is imminent, we would
prefer to skip 10, rather than upgrade and regression test twice. Any hints?

We have an SQL that every time it's run, will crash the instance, a
complete shutdown, everyone out and shutdown. I told the guy running it
just to break it apart, and it works fine that way, but should I subimt
this to IBM as a bug, because I think that no SQL should ever crash ...

delete from MYTABLE where date(MYCOLUMN) = current date - 30
"MYCOLUMN" is of type timestamp.
This query doesnt' work. Anything I missed here? I am hoping to
automate it on a daily basis. Anyone knows a better way to do it? Much

                 In DB2, we have dayofweek function that returns a
numeric value for the current day (1 for sunday till 7 for saturday)
Is it possible to alter this function value, i mean 1 for monday till 7
for sunday?

I am fairly new on
UDB.
I am experiencing
a problem with a

We are using DB2 UDB version 7 as the database for our project. This is
installed on windows environment. The actual prod environment is DB2 on
mainframe.
When we execute simple select queries on our local database with

while  opening a new DB2 connection using ODBC connection i get the
following error message
ERROR [08004] [IBM][CLI Driver] SQL30061N  The database alias or
database name \"DATABASENAME              \" was not found at the

The syntax diagram of DROP SCHEMA requires RESTRICT. Is there an easy
way to drop an old, unnecessary, but populated schema?

I have a table like the one below
Pkey Sno
-----------------
AA     0