I have an SQL statement which relies on a numeric value
e.g.
where id = 6
I am using a BI tool which let's me pass in the id to the report

I have KSDS file. I don't know how much records it have. I want to
access last record only. I don't no key for last record.
Anoop

Help!
I am trying to write an SQL statement (without much luck) to extract
the total number of searches and orders from a particular customer,
grouped into days/months/weeks (depending on the report type.

I can easily convert a TIMESTAMP to a DATE which will give me results
in the format 'DD/MM/YYYY' however, what I want to do is convert the
TIMESTAMP to just 'MM/YYYY' or even better 'MMM/YYYY'.
I tried using the cast function as follows but it failed.

question: db2 LUW V8 UNION ALL  with table function month() have bad
query performance
Env:
db2 LUW V8 + FP14

Can anyone shed some light on what is causing this, please?
Using Perl 5.8.5 (64 bit) on RH enterprise Linux AS release 4
(2.6.9-22.ELsmp) I'm receiving the following error:
DBI connect('psygrid','db2inst1',...) failed: [IBM][CLI Driver]

Haw anyone seen the following error under the z/OS DB2 Administration
Server?
  BPXF024I (DASUSER) CEE0454S The message number 9512 could not be
102 found for facility ID CLB.

Colleagues,
Consider the following snippets of a snapshot:
Number of executions               = 13
Number of compilations             = 4294967295

Suppose I have the following scheam (parent->child) :
A->B->C->D,  E->F
Can someone help me with the sql query in db2 which will give me the
complete chain once i give it the parent table. eg. for input A, i

I have my server on AS400. I connect to it using DB2Connect.
In the AS400 server I have three kinds of tables one for English, one
for Chinese and one for Thai.
I need to use the DB2connect on my unix machine to read data from each

I m new to DB2..
I am using DB2 version8. I have a few queries (which i create
dynamically) stored in a table. The column which stores them is clob
32k. Each of these query has a ":wf_id" string in 2 places, which i

I use db2 v8 on AIX..
I could not connect to the database nor did any commands like activate
get db cfg for database
work..

 I have a DB2 database (version 7) running on Windows 2000 server and
recently facing problem to backup my database. I got an error "Disk
was full" after half way running the backup.  My database size is
about 10GB, I have tried to backup the database into a DDS tape (20GB)

Looked everywhere (Date, Celko, Elmasri, this ng, c.d.t, etc), but can't
find any discussion of the following:
Proof that these predicates will (or not) return the same rows
where (col1 concat col2 concat col3 ...) => <SomeSuitableString>

Is it possible to write a recursive (a function which calls itself) UDF
in DB2 (v.9) ?
When I load one, I get SQL0440N - function "XXX" not found...
Thanks in advance