I am facing a problem while migrating a Sybase SQL query to DB2 UDB.
The query involves left outer joins.
The Sybase query syntax is as follows :
select * from A, B, C

Dear friends
I am conducting a survey on Relational Database usage and would like
your help. The study is part of my MBA Dissertation.
Could you kindly spare 5 minutes to take part in this survey?

After updating to FP10, everytime i want to execute a stored procedure
it gives me an error "Java or .NET interpreter startup or communication
failed". In the db2diag.log there is an info just bevore the error
saing that it attempts loading "libjvm.so" and also there is something

I now really need Net Search Extender.  I got it with Developers'
Edition 8.1, and I can't find an update.
Over two years, following the docs scrupulously, I have been unable to
make it work.

I am debugging a problem where one version of a JDBC
driver connects to an AS400 DB2 instance, and another
doesn't. I am told to suspect that the DBMS may not
accept UTF clients. I have no contact with either

running DB2 UDB 7.2 F.P 12 on WIndows
Developers debug old application
and need to get value passed to db2 by application
I run db2cli trace and event monitor and both cases I get

I think this question has been asked before...
I have instance DB2T, within which I would like to create multiple
schemas. I want to then create the same set of tables within each
schema. My questions are -

    Have any function in the DB2 database that can generate unique id
for each string like oracle, mysql,sybase,sqlserver database.
    In mysql:-
       select  md5(concat_ws("Row name")) from tablename;

Is it possible? Thanks!
Carmelo

How do I move an exsisting DB from one instance to
another instance on the same server?
Thanks

I'm ashamed to ask this question because I did it before, but have not
done it in a few years.
For a brand new database, client server, V8.2, Win32, I need to connect
all clients to the server.

I need to UPDATE tablea only when JOINed tableb and tablec have certain
properties. Due to a severe shortcoming on my part, I can not picture a
syntax which will allow this. Some help would be appreciated. Examples,
pointers to either relevant manual pages or examples, etc. I ...

I currently have two databases shareing the same
instance on the same AIX server. I need to move one
of the exsisting DB's from that exsisting instance
to a newly created instance . I appriceate you

I am new to db2 and I am trying to create a script to see if
db2 is alive and functioning.
What I am looking for is a call or function that is equivalent
to Oracle's tnsping that I can call to see if db2 is alive.

Anyone has an idea on how to generate a DBRM from the catalog for an
old program where the original DBRM library is now no more?
Need to bind this program to a different database for testing purposes
but since DBRM is missing (and possibly source too, not sure) would