could someone plz help me on this one,its kinda urgent
i hav a result set which looks something like this
country_code           sum(amount)
1                              100

I need to be selecting records based on the value of a string-format
currency value.
Specifically, I have a table with a field of type varchar(50).  Stored
in this field is a dollar-formatted value, complete with the dollar

is there a way (script or command) to get a list of all existing db2-users?
Our system: Windows 2000 server and UDB 7.2 / 8.2
Is there also a way to get the same information for a database running on
AIX?

Firstly, for documentation purposes. In the view syscat.columns there is
a column named remarks, pointing to, I suppose, to the corresponding
column in sysibm.syscolumns. Is that column reserved for DB2's use of
can I use it to document the columns of my tables? Likewise,

I have a production database that I need to change the logging type
from circular to archived so that I can do online backups.  The
database is not particularly large, but is used by many people.  What
impact from the users perspective can I expect?  Is the only impact

I am loading data from ascii delimiter file and some of the rows are
getting rejected while loading.
1.0|11487.0|FQ|105061.0|332735.0|01|X.NNIE HATFIELD|1992-06-25
00:00:00|1992-

Hi, thanks already for your info in a previous post Ian, Dave and Gert.
What I understood from your answers (and believe me when I tell you I know
nothing about DB2) the best and easied way to move the databases is to
backup both databases, stop the database server (db2stop force) ...

I am doing a rollforward and want to query the status of the
rollforward.  I issue the command: DB2 Rollforward database namdwh
query status.
I get the following error:

I tried create this function with DB2 Express and received the error
message:
-104
Thiago.FUNCTION1: 9: [IBM][CLI Driver][DB2/NT] SQL0104N  An inexpected

I have tables created in my DB2 database created under a schema. Now i
want to get connected to these tables with a username different from
this schema name from my java application. When i give the user name in
my JDBC connection parameters, Its appending this username to the

  I am a programmer ,coding in IBM COBOL and the DB is DB2 V6 on OS/390.
  As below, for the performance issue, Does anyone know which one is better
??
  To get a record that field A has a maximum value,

I've got a table full of search terms, one search term per row.
ID CATEGORYID SEARCH_TERM
1  1   cat
2  1   mat

I have a pretty simple query like
select
    t1.c1,t1.c2,t1.c2,
    t2.c1,t2.c2

I have got a tab delimited file from a customer, and I have to import this
file into a db2 table. Is there a way to do this without changing the tab
character to something different? And if so, how do I specify coldel in the
import statement?

this might sound strange, but I'm desperately seeking for a solution for
this (personal) issue.
Ages ago, I built a DB2 database under OS/2, even with a VX-Rexx
graphical interface. I maintained the OS/2 PC for a long time but