I have to write a Shell script like ...
IF "select value from tablnema where condition;"      = some_value
then
depending upon the this value I will call some other script.sql

   I need your help here :
   I need to compute the product of a column, with conditions, over a
table, grouped by a key (it is a probability table).
   In fact I need the exact equivalent of :

I created database using
CREATE DATABASE TEST ON D: USING CODESET 1250 TERRITORY HR COLLATE
USING
SYSTEM

During some bulk loading of data .. I am frequently encountering the
"Transaction Log Full " error . I am using the  " import " command with
"commitcount" being 1000.
Even with such a low commitcount  I get this error . As suggested I

How can I convert the following T-SQL construct to SQL-PL?
if @ParameterType not in ('p1', 'p2', 'p3', 'p4', 'p4', 'p5')
begin
   print 'good parameter'

I am getting material for a second edition of my SQL PUZZLES book
together of the next few months.
1) If anyone has a new puzzle, send it to me.  You will get your name
in print, fame, glory and perhaps a free copy, depending on my

Anyone ever installed DB2 and SQL Server DBMS's on the same host so
that they both ran similtaneously?  If so, any tips on getting it done?
Thanks

What is the purpose of file system caching while creating a tablespace?
Memory on the test server gets used up pretty quickly after a user
executes a complex query(database is already activated), after some
investgation i found out that most of it being consumed by filesystem

Env : DB2 UDB 8.2 / AIX 5.3
When I try to use some DB2 Utilities against a partitioned table which
is not defined on a particular node (Node 0 in this case) I'm getting
this error.