How to I drop instance under Linux?
for example i have created db2inst2 instance
i want to completely remove that instance and all database under that
instance

Is their a way out to find at what time a particular set of row was
inserted or updated
Which are the system table if any that provides this information.
Thanks

  Folks,
  I'm writing an SQL UDF to replace DB2's LIKE (which has some nasty limitations regarding concatenation), and I've reached a problem that I can't figure out.  It must be a coding or logic problem on my part, but I just can't see it.  Hopefully someone else can spot it.
...

Any good books or tutorials on SPL/PL or working with Stored Procedures
and UDFs?
Thanks in advance!
DG

I want to appear for DB2 UDB V8.1 for Linux, UNIX and Windows Database
Administration (Exam 701) certification.
Right now i am referring to the tutorial given in the IBM site for the
same.

i have read about create server and create nickname commands in DB2 UDB
can i use these commands to create nicknames for sql server tables ?
do i need Information Integrator or not ?
regards,

I want to change this query SELECT current timestamp FROM
sysibm.sysdummy1;
so it returns 2005-11-09-00.00.0.000000 not 2005-11-09-15.31.33.132000.
Basically stip the time of the timestamp

I am running SUN server and DB2 version 8.1
During the execution an application Tivoli (ITIM) the following error
has been taken place.
2005-10-26-17.43.10.884357   Instance:db2itim   Node:000

hi, we had a db2 udb v8.1.6 EE on windows installed, the install drive
crashed, so all the programs related to db2 lost, but seems still have
leftover in the system, such as db2 services, programs..., i try to do
uninstall on the db2 Enterprise edition server, doesn't work, i try to

I have a question about using "*" in (sub)queries.
This example query counts the number of records for a certain customer
starting with record "80172" and stops after 10 rows.
SELECT PK_ORDER,PK_CUSTOMER FROM

Have downloaded and applied FP10 to V8.1 Win32 Workgroup Sever Edition
and administration client.
Now nothing works.
As far as I can tell from the docs, I have to bind or re-bind something

  I want to write a standard java user defined function,  like this
example:-
  select db_fun("roll"), roll from student;
    **db_fun() will work for all tables of the all databse

hi
can any body helps me for the equal statement at DB2 ver 7.0 for this
statement at SQL?
Select top 10 column1 from table1

I have one table TABLE1 in X db, and another table TABLE2 in Y db.
When I execute the following:
CONNECT TO X;
SELECT * from TABLE1, TABLE2;

I asked this last year, but never received a satisfactory answer:
<<Has the promise of stored procedures written in VB6 been fulfilled in
8.2?  If there be a special syntax, and where do I find it, and where
are samples?