we are running DPF Version 8.2 on windows 2000 (don't blame me).
We try to truncate a table. However when I issue
import from NUL of del replace into [tbcreator.tbname]
and take a snapshot for that application I see the following SQL

Using db2 CLP I am trying to get the following SQL statement to
display "0.33". But, as you can see, it doesn't.
db2 => select round(float(1) / 3, 2) from sysibm.sysdummy1
1

the following SQL-Statement does not compile, I receive SQL0338N as an
error. The erroneous parts of the statement are the left-outer-Joins,
but I don't know how to solve the problem, any hints?
Thanks in advance,

Suppose I have an index like this:
CREATE INDEX CUSTOMER_NAMES ON CUSTOMER_DATA(LAST_NAME, FIRST_NAME);
Will the execution plan be different if I make a query in the
following forms?

I am trying to load some data into a DB2 database using the LOAD command.
In some of my string data there are real double quotes ".
How can I tell the load that these are "Real" quotes and not delimiters?
TIA

I have an identity column on a table that is filling in gaps when I
complete inserts.
For example if i had rows with these ID's
1

Is it possible to create a Function Template in UDB 8.2 with a TABLE
return type?
I would like to have a function federated that has a table return
type.

Following is an academic question from DB2 certification exam. Could
you pls provide your inputs on this.
To be able to use a staging table for a deferred MQT table MQT_EDW,
put the following DB2 statements in the correct order:

I'm trying to use LINUXAIO on my EMT64 db2 v9 FP 2 database server,
but I keep getting the following error in my db2diag.log.  Funny
thing, the file is actually in /usr/lib.  For some reason DB2 can't
find it.  I read some other posts where people said that you have to

I am trying to compile a cobol program using the DB2 extensions to MF cobol.
I am getting the following error.
Micro Focus Server Express         V4.0 revision 000 20-Jul-07 11:32 Page
 1

Can someone brief me on the backup restore story for  DB2's Database
Partitioning ?
Can I backup\restore the whole database in a single command or I have
to do it node by node ?

Is there a db2 tool or utility that will map Oracle structures and
data to DB2?
For instance Microsoft has a tool called "Microsoft Sql Server
Migration Assistant for Oracle".

I am just confused because of the following scenario.
*   I have turned on the new 8.2 registry variables skipdeleted,
skipinserted, evaluncommitted to ON
*  I gave a select * from <>, it was waiting for a lock,  it needed an

Let me know whether IBM supports 64bit client application in a 32bit
instance.
There are 2 inconsistent descriptions.
According to V8 Information center, DB2 does not support running a 64-

Hi Google Group,
Can you please let me know the answer to this question on DB2 V 8.1
Certification
For which of the following database Objects can Locks NOT be obtained