is there any possibility to use pi() (3.14...) like it is in SQL Server in a
query to a DB2 database? How is the syntax therefore?
Thanks for good ideas!
Cheers,

Good Evening All,
I am working on a program that well need to get data via a UDF from
multiple DB2 subsystems then make make some updates to the date and
then do a "select col1 from SESSION.tmp group by col1".

I have a table which is the highest level table in my DB
design...ie...all tables have foreign keys that if the chain is
followed,  lead to this table.
This table had quite a few indexes (8) as well, however we have balanced

I need some help.  I am currently running a load script on db2 version
7 on an AIX 5.1.02 server in our production environment.  We have
upgraded our test server with db2 version 8 AIX 5.2..03.  The load
script does not run now.  I am getting a SQL3025N A parameter

I need to delete several million records from a single table but cannot get
DB2 8.1 to not create log files (I need to do this as fast as possible to
minimize downtime).  I figure that creating the log files consumes a lot of
resources so I turned LOGRETAIN OFF & USEREXIT OFF, but ...

We have a mainframe DB2 table with CLOB data type...
What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.
We tried unloading data with fixed format and tried loading in UDB

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:
SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =

I'm trying to fill an array in korn shell with entries from a db2
query.  I've tried a straight `set -A <array_name>=`db2 -x <query>`` ,
but that doesn't work.
Can this sort of thing be done?

I am trying to write a sql script to estimate size and count of rows of
all tables and indexes within a schema.
Here's what I have so far but need a little help.
#$1 is database name and $2 is schema name

I've been playing with Java UDFs for the last couple of days and I've got
some questions about scratchpads. I'm running DB2 LUW V8 (FP8) on WinXP.
Somewhere in the manuals, I found some remarks that said I could either
manage my scratchpad with the getScratchpad() and ...

Where i find information about?

Open Letter to IBMers involved with DB2 Developer Domain:
When are we going to see an RSS feed for the developerWorks DB2
site (a.k.a DB2 Developer Domain) ?
I've been waiting for over a year for dW to create an RSS feed for

I have a database that tracks players for children's sports clubs. I have
included representative DDL for this database at the end of this post.
A single instance of this database supports multiple clubs. I would like to
add support for letting each club define and store custom ...

I have a requirement to setup DB2 on a 4 node cluster using Veritas
(with the DB2 failover agent).
I may have a requirement to have more than one database running on the
cluster at a different DB2 version (8.1, 8.2) or Fixpak release (8.1

If you have tablespaces that were  SMS tablespaces and you redirect the
containers during a restore can you make them DMS constainers?
Thank,
Scott Shealy