Is it possible to use inline SQL PL over JDBC? If so, which statement
type is required and what syntax does the inline SQL PL take? A
CallableStatement, for example, need to be enclosed within curly
braces: eg:

I understand that static recursive stored procedure calls is not
supported in v8 and instead the call to another SP needs to be made
using dynamic SQL. Could anyone please let me know if there is any
performance difference between both of the above methods.

Is there any quick way to load XML into db2 table? we are at db2 V8.2
at FP11 ( unix )

I installed following pkg. on my laptop (Fedora Core 6) :
db2exc_91_LNX_x86.tar.gz
After resolving some dependency-problems the install was fine.
(I understand that a laptop isn't very well suited for DB2 but .... I

I'm looking for a built-in hashing/digest function in DB2, e.g. MD5 or
SHA1. It seems there is no such thing. Or have I overlooked something?
If I were to add md5sum to db2 as a c- or java-based function: Is there a
repository of popular ready-to-compile DB2-functions somewhere?

How do I describe non-table objects, like UDF functions and
procedures, using db2's normal command line interface?
Database server = DB2/LINUX 9.1.0 Express-C running on Linux 2.6
Intel-32.

I have recently been looking on dice.com (and other sites) and noticed
a striking difference in the number of listings for DB2 DBAs for the
OS390 platform.  Most of the listings are AIX.
Anyone else notice this?  Also, is DB2 on OS390 dying?

Hello, I need to merge a small table (of rows less than 100,sometimes
even 0 rows) to a big table (of rows around 4 billion). I used the PK
of the big table as merge key but merge does a table scan so it runs
for ever.

In PostgreSQL, when you create a function, you may choose between SECURITY
INVOKER or SECURITY DEFINER:
http://www.postgresql.org/docs/8.2/static/sql-createfunction.html
When a function has SECURITY INVOKER (the default), the SQL it contains is

Can anyone tell me how to migrate data from MySQL to DB2? Does DB2
offer such migration tools?
Thank you.
Roy

When is DB2 UDB v8.2 scheduled to go out of support?
Cheers

I'm new at DB2, and have just installed a DB2 Version 9 Enterprise trial.
Had no visible problems installing the database, but I cannot create the
sample Database, or any other database.
When I try to create a database, I get

As a converted sybase dba, I have a question.  In sybase a command can
be executed multiple times by placing a
go 1000
at the end of the statement.  Such as:

I'm trying to complete the samples from the excellent 2003
developerWorks article "Bringing the Power of Regular Expression
Matching to SQL" by Knut Stolze:
http://tinyurl.com/3bhrnn

Hi group,
Have a problem with event monitor so my db2diag.log is getting filled
like any thing..
Running DB2 V8.1 Fixpack 6 in AIX server.