I find that I am constantly using IMPORT and LOAD to create temporary
tables to use in queries. It all works fine, but it's time consuming
and boring. Is there a better way? I was reading about federation, but
it was not clear if this was total overkill for what I want to do. For

How do I make a NULL entry from a left join NOT mess up a concatination?
ie if both values are present this statement will work equaling "AF, CD"
however if value is NULL then the concatination fails.
,( #My_AF.activity_CD ||', '|| #My_AP.activity_CD) as History

Is it possible to insert a '\0' value or for that matter any control
character into a DB2 CHAR/VARCHAR field ? So if i do a 'select
hex(column) from table' i should see a 0 in the output. How can i do it
from the command prompt ?

Folks,
 I am having problem with an application that uses static SQL,
 the application basically browses through the table given start and
 end key most of the time it is processed from begining to end.

I saw the following alert
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=D600&uid=swg212
48542&loc=en_US&cs=utf-8&lang=en,
which states for AIX, ensure that the JDK is DST compatible.  The
question is, how do you verify this?

I'm currently on DB2 LUW v8.1 fixpack 5
 DB21085I  Instance "xxxx" uses "32" bits and DB2 code
 release "SQL08015" with level identifier "02060106".
 Informational tokens are "DB2 v8.1.0.48", "s040212", "MI00069",

I created a function which i need to modify now.
I tried the alter function command but it throws the following error
message:
db2 => alter function DB2INST1.*/*/(**(),**()) not fenced

i have a problem determining the workstation name of the client user.
i try to do a
  SELECT CURRENT CLIENT_WRKSTNNAME .....
but i get an empty string.

First of all: i apologize for my english...i'm still learning...
If i create a view it seems that DB2 manage this view like an
updateable view.
But I need to create a view "read only", so DB2 never enables lock on

A few questions about SET INTEGRITY.
1) Docs: The SET INTEGRITY statement is under transaction control.
Using two sessions (different user, even) i tried the following.
Session 1: UPDATE COMMAND OPTIONS USING C OFF

I have a query in reorgchk. When I was examining the output of reorgchk
I found a column TSIZE in Table Statistics & ISIZE in Index Statistics.
Can any one let me know the formula for TSIZE & ISIZE? How to calculate
the size?

I recently wrote a user defined function in SQl to run in db2 and it
works fine.  But I seem to get a warning saying that the performance is
sub-optimal.
Here is the warning message:

Currently I'm using DB2 UDB on 8.1 (Server version) and client version
is 7.1.6.
Please let me know whether there will be any issues in the following
Upgradations.

Has any one used either one of the below mentioned registry variables
in any of the environments. Were there any performance issues related
with this. Any inputs regarding these variables, regarding to the db2
performance will be greatly helpful.

Hi experts,
I am having a hard time coding a trigger to handle multiple validation
conditions in DB2 UDB V8.1.9.. I thought that a single trigger might be
better than one-trigger-per-condition, but so far, no cigar. Here is