I just receive an error during my CLI ODBC insert statement:
INSERT INTO (.....) VALUES (?, ?, ?, TIMESTAMP( CAST(? AS
VARCHAR(10)),'00:00:00'), ?, ?, ?, ?)";
the ? in the CAST( ) Statement is represented by:

does the substr function work with timestamp datatype columns. I wanted
to use it for padding the various columns for a report. I can live
without it :) .. though just wanted to know if it works with the
timestamp data type.

I have a table with an index on PERNR. The table contains 350.000 rows,
349.000 of them PERNR is empty.
If I start a query "SELECT * FROM Mytable WHERE PERNR = '4711' DB2 don't use
the index and I wait 5 minutes for the result.

Audit trigger
Hello,
LUW DB2 V8 FP13
I am trying to create audit triggers in order to find out which

  We received an SQL 955 on a query.  Since a snapshot showed that
database wide memory was still available (high water mark was below
max) I figured it was the SORTHEAP parm being too small.  Yet the query
was rerun later when system was not as busy and it ran fine.  I don't

I'm currently trying to read out ddl-structures from a db2-database
with schemacrawler (http://schemacrawler.sourceforge.net/)
but without success. Some people in this newsgroup recommended this
tool for analyzing and diff-ing ddl-structures of databases.

I have a need (or desire) for something that may be a bit odd...
I have a table defined as follows:
CREATE TABLE "MGR_DEV1"."ICM_POSPAY_ISSUED_CHECKS"  (
         "UNIQRBACNT" DECIMAL(31,0) NOT NULL ,

anyone knows how to reset tablespace high watermarks counters?
thanks
alexandre

HI group
Am wondering if any DPF users use these two (2) api's to obtain the
target partition number, and so bypass the inter-pertition transfer of
data from co-ordinator partition to target partition, aka "LOCAL

Is there a way to ensure only the user who insert a row can see that
row and not anyone else (other than db2admin with full privileges)?
Aaron

Hi gurus,
Am trying to use SQLDBS in my program, like so:
CALL SQLDBS 'REORG TABLE 'schema'.'tabname ' INPLACE'
gives me a syntax error, yet when I take off INPLACE, it works fine. Does

Command Reference book stated for db2relocatedb command:
Copy the files/devices belonging to the databases being copied onto the
system where the new instance resides. The path names must be changed
as necessary. However, if there are already databases in the directory

I am servicable at writing SQL, but I can't find a whole lot of info
about what I need to do.  I need to write some queries that summarize
rows in a table based on a TIMESTAMP field.
We have a table that records accesses to an application in a timestamp

How does one cast a value that contains nulls into a number in the
WHERE clause?
I have a table called "fp":
file_id int

Some time back I had posted a message looking for a function to convert a
date column into a decimal(8,0) value.  There didn't seem to be a built in
function, so I've created the following UDF:
CREATE FUNCTION FB_FUNC.DATE_TO_DEC ( date_in DATE )