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

hi,
i have problem in design db of my small system
so i will describe it all to get the whole picture
here what i have:

Can I get a little help?  Given a very simple table of events, with
their durations, I want to consolidate time periods for an event that
(1) touch each other or (2) overlap each other.
CREATE TABLE Events

I am writing an application that will require database access.  This
application will be deployed onto users machines, often using portable
equipment such as laptops.
Before I can begin writing the application I need to research the

i came accross requirement of multiple foreign keys in a table
referencing the same primary key another table. i created the table
relations using the relations editor in access. even though i could
have multiple foreign keys to a table access did allow the referential

I'm using mimer DB and because of performance problems, I want to do
the following:
I have the following example table:
create table MyTable

I downloaded regain.  It indexes your system and allows searching
in a fashion much like google.  Jakarta Lucene engine??
My first search term was "mike"...zero hits.
Second search was "mike*"...470 hits

How do I view the "load" being placed on mysql, from the mysql command
line?  Do I need to be root?
And when I say load, I guess I mean the number of open queries or
conxes.  In general, any information that will tell me whether it's

I have written a perl script that tries to insert data into a table in
an Oracle database residing on an aix server. Running the perl script on
the server works fine, but if I try running it on my local machine
cygwin on Windows XP), I get this message:

Hey everyone,
I'm working on a project that will let the users store their budget,
and in the backbone I have a MySQL database. However, I'm not really
fluent in SQL. I have two questions:

Hello Friends,
I would like to know performance of Join. So give me your feedback on
following two CASES. which one is good and why? Also explain me Query
How it will execute,STEP BY STEP for both CASE?

I'm writing a PHP class for representing relationships between
tables.  One case of inter-table relationships that I believe I need
to support is that of a table with multiple foreign keys to another
single table.  But some people I have talked to don't see the need for

I've been trying all morning to figure out a way to display the
number
of days/months between CURDATE() and a future date (myqsl column).
I've tried BETWEEN and something like this:

Is there a way to quickly compare the table structures of the tables
of two databases and see what's different?
For example to see if the staging server's db has an extra column in
some table that the live server doesn't?