I tried to do a sqc program with a "SELECT  column INTO :host_variable
FROM table" statement and  got an error SQL4942N="The statement
selects an incompatible data type into host variable"
My column is Decimal(6,2) data type definition, and my host variable

I recently learned about the "SELECT FROM NEW/OLD/FINAL TABLE"
statement and I wanted to replace our old code, where we used
"identity_val_local()" to get auto generated values after an insert.
So I tried the following:

is it possible to write compound sql without stored procedure or
trigger.
can i just run in command center of db2.
regards,

I have a function that has a varchar about 300 characters.  When I run
the insert command from a function I receive the error SQL0433N -
Value ....  is too long SQLSTATE=22001.
If I run the query outside of the function it seems to work fine.  I

I have a many row and many column table that is in a 16K page size.
I have four indexes on the table.
I am running row compression on the table.
The table does not have a primary key.

admin guide says that
pool_data_p_reads - pool_async_data_reads will give me number of
physical reads that were performed synchronously (that is, physical
data page reads that were performed by database manager agents).

If I would create tablespaces that do not use filesystem caching on an
NFS share... What would this change in performance? Is this of any use?
And is it safe? I've read some applications have trouble in using direct
I/O on NFS shares (though none of which were DB2).

I recently installed four AIX 5.3 boxes (ML03 and 04). I then
installed various versions of db2 V8.1 -- FP9a and FP11
when i run db2cc on two of the boxes as the instance owner, it loads
up.

I have DB2 Express-C v9.1 installed on my machine. It is Linux UBUNTO 6.10.
I've installed unixODBC version 2.2.11.
My /etc/odbcinst.ini:
[ODBC]

Is there any way to get a db2 9.1 Windows UDB database which is in
inconsistent state to start without recovery?
We were loading data from a source and the database crashed.  The
Server was restarted after this. DB2 has completed the forward phase

Using the following query:
select substr(reg_var_name,1,24) as reg_var_name, substr(reg_var_value,
1,12) as reg_var_value, level from table(sysproc.reg_list_variables())
as registryinfo;

We are exploring doing some development with MS Visual Studio 2005 to
access our DB2 UDB for Windows databases.  Are there any other options
to accessing DB2 with Visual Studio that may be more robust than ODBC?

The table is a many row and many column table that is in a 16K page
size. I am running row compression on the table. A have an index that
over time have come to have a low index cluster ratio.
The table does not have a primary key. I have 3 other indexes on the

With VALUES you can do something like:
SELECT * FROM (VALUES ('A', 1), ('B', 2), ('C', 2)) AS TEMP(LETTER, NUMBER)
which will give you:
LETTER  NUMBER  

I am trying to run a SQL query as follows:
SELECT INVMST.INUMBR, INVMST.IDESCR,
CASE WHEN SUM(INVCHS.CHQT01) = 0 THEN SUM(INVCHS1.CHQT01) ELSE
SUM(INVCHS.CHQT01) END as QTY1,