I am studying DB2 right know and trying to make some things to work. I
noticed that I might understood some things wrong. Could you help me
clarify a bit?
That's what I wanted to do: A function/procedure I can call in a SQL.

Linux DB2 V7 FP13 kernel 2.4.
Parts of our application login run on C++ procedures that are working
fine. I have taken an offline backup and restored it to a Linux V8
kernel 2.6 FP 14 server.

DB2 WSUE LUW v8.2 FP4 (aka v8.1 FP11)
RHEL AS 4
I am EXPORTing in IXF format from one schema and then LOADing into
another schema on another server.

I am trying to write an app in vfp 8.0 using cursoradapters connecting
to an as400 db2 database.  My goal is to set up a test data library
(called FRED) on the iseries identical to the production data library
and manipulate the library list the pc uses by changing the odbc

I need to give authrization/Privilege for a user such that he should be
able to run stored procedures but cannot change its code i.e he should not
be able to compile it.I looked in the documentation but for ROUTINES there
is only 'EXECUTE' privilege which is for running the SP's ...

Hi - a straight-forward question for which I would be grateful for an
explanation.
Why are ALL SQL/PL Stored Procedures associated with SYSIBM.SYSDUMMY1
even though the latter is NOT directly accessed via SQL within the SP?

I am new to Db2. This question may be very simple.
In SQL Server I can set database option as case sensitive or
insensitive. Because of this if I set option as case insensitive than
'a'='A' or 'suResH'='SURESH'

How to find out what all changes have been made to the Database and
which user has done the change.?
Is there any location where these kind of information is stored?
I have DB2 UDB v8.2 installed in RHEL and around 30 users who access

I have the following data in my DB2 table ("Employee") :
EMPID       MONTH           SALARY
E340          JAN                 3000
E340          FEB                 2000

Need a query which satisfies the following condition ::
I have a table with fields
emp_no   emp_name       supervisor
111          harry            222

I have a problem migrating an application from v5r2 to v5r3. The
problem is with the prepared statements.
To see what the problem is, i extracted a small piece of code and
debugged the application while running it on my local window machine

I can able to encrypt data on my development server using DB2
encryption function. My Development server configuration is Intel 3.2
GHz processor.
But when I go through document on Db2 build in encryption function its

Gurus,
Does the 'table identifier' (unsigned short, offset 4 in
DMSLogRecordHeader) relate to:
- tabname in syscat.tables

--------------------------------------------------------------------------------
I have HP-UX ia64 and db2 version 8.1 fp 6, i want to upgrade to 8.1
fixpak 11, but when i tried to install it, i received the message that
my db2 version should be at least 8.2 . I think that i need to ...

I have a table with this layout (example 2 rows with 4 columns)
PK1        STATE1       PROV1      PLAN1
pk2        state2          prov2          plan2
If STATE1 and PROV1 equals state2 and prov2 than I have to plug in pk2