This is on DB2 V7 on OS/390
I have 2 tables PATIENT and SPECIMEN.
PATIENT columns are
IDENTIFICATION

I work with "IBM DB 2 Universal Database for Windows NT" Version 6. I want
to create Function, which are using in a Queries. I don't want to use
external function. I want to create a function, which returns the age of a
person. The parameters of the function or procedure are two ...

I would like to perform a redirected restore and was wondering what is
the best way to migrate all the data & strucuture but to modify the
original extent size of the tablespaces.  The tablespaces were
originally setup with an inadequate extent size and now we are trying

hi to every body
I'm a new db2 user/developer and I'ld like to know if exists a possibilities
to develop a package like an oracle pl/sql
someone have an information for me ? book, address ,. .... etc

I discover next problem
I have view definition with rank()
create view vTEST as
select c1, c2, c3, ...

I was able to create the structured type:
CREATE TYPE address_t  AS
           ( street         char(30),
             city           char(15),

Is there a way to revalidate (rebind) all inoperative packages
(SYSCAT.PACKAGES.VALID = 'X') via a stored procedure that scans invalid
packages from SYSCAT.PACKAGES and execute the CLP command REBIND or
something similar?

Why the first statement is not working.
I want to use EXCEPT
connect to UDBPERF;
select dept_id from new.dept m except (select 1 from new.dept p where

Is there any way in DB2 to automate the taking of a snapshot, for
example, a function that will cause a db2 snapshot to be taken every 5
minutes and written to a uniquely named file?
Am I better off attempting to do this with my poor knowledge of dos

We have an application through which users store various types of files and
attachments in a LOB in a DB2 7.2 database. Some of these files and
attachments can reach a size of 1 GB, although most are in the 10 MB range.
Logging is not enabled for the LOB columns in the database ...

Please forgive a newbie question.
In MSSQL I can execute a stored procedure (sp_helpsort) that returns the
sort order (listing characters) of a database. Is there a DB2 equivalent
to this query?

So yea... I rm-ed a rlv that our TS_FACT2 tblspace was using.  So our
db went to the crapper.  The tblspace didn't have any pertinent info,
so I'm ok with dropping the tblspace and starting over.
These are the commands and errors that I have found:

We use redirected restore to refresh test from prod on different AIX 5.2
servers. The databases have the same number, size and names of cooked
containers. The only difference is the fully qualified path contains a
different "SID": eg. "/db2/PRD/data1/..." versus "/db2/TST/data1/..." ...

As part of what I want in a report, I want the associated row from t2,
if there is one, with the largest date in a range based on the base row
from t1. I attempted the following:
left outer join IS3.service_ai t2   on T1.dam_BHID=T2.cow_BHID

I tried to create a table that had a column with graphic data type.
The database reported that the graphic data types were not supported on
my database.  I am using the DB2 v8.1.  How do I turn this feature on?
Thanks