I was wondering if anyone can tell me how to convert a character string to numeric in DB2 version 8.2. I have tried the following, but, it won't work:
select INTEGER('1234567899') from a.table1
Also tried decimal function, but, no luck.
The column in the table is ten characters ...

I have a parent table that has 2 child tables.  I need to drop and
recreate the parent table because there has been a change to one of the
column types.  What should I do prior to dropping the table to make
sure that when recreated and reloaded it will identify the child

Hai .. every one ......
           Can anyone tell the command that will list all the instance
names along with their creator names..............db2ilist is giving
only the names.... pls tell me the command in windows...........

I'm using IMPORT FROM FILE OF ASC import command. The FILE rows of fixed
length and also columns are of fixed length. In the FILE I have a date
field that can have one special value (00000000) which should be
interpreted as null. How do I specify that?

I have the subject system set up, and can connect to it with several
userids. I can login to it (ssh) with a new userid I created, but when I
try to use those credentials to connect to db2, I get password invalid.
I have checked the groups of the new userid and made its password ...

Folks,
I've got a database and tablespaces "managed by automatic storage".
I've deleted a lot of data from some tables.   I've then reorged them.   But
the tablespaces don't appear to shrink in size (they just have lots of free

v8.2
I've found that when I create a trigger no packages are created (at
least I can't find corresponding records in syscat.packages,
syscat.packagedep, syscat.trigdep).

I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box,
but I have some problems.
I've added to the classpath the following JARs
sqllib/java/db2java.zip

is there a way (Win 2003, DB2 UDB 8.1 Fixpack9), that the logs are
archived regularly? Our server writes logs (-> archive logs) only 1-3
times per day. I would like to have them more frequently, because I
move them (with OS tools) to another server for the case of desaster(

do I need to have 2 systems to play around with replication, or can I
perform replication from 1 db to another on the same system?
TIA

Hi, I am new to DB2 - Intelligent miner and I would like to perform
some mining on data. My problem is that I have transactions of the
following form
Transaction    ClientID    Unit    Article

two tables with the same table structure : tb_xxx and tb_xxx_tmp
in table tb_xxx , column "listno" is the primary key of itself and
foreign key of  dozen of  tables .
here is my sql .. " update tb_xxx set ( listno ) = (select listno from

I've got a database with a star schema and I'm kind of confused about
what the optimizer is doing with my queries.  I've got a fact table
(about 24 M rows), which I'm joining to 3 dimensions.  Each dimension
ID in the fact has it's own index.

v8.2
Is it possible to use db2move utility to load tables with these
columns' attributes?
Is this functionality is planned in v9?

db2 V8.2
I have been looking for a good way to log the 'reason code' when we hit
an sqlcode that uses them.  From what I can tell the reason code is
stored in sqlca.sqlerrmc.  But, there seems to be other information