Search results for query: *

You cannot execute a trigger, from ODBC or SQL. They are executed automatically by DB2 whenever an update, insert, or delete is performed (depends on the type of trigger). You can remove *drop) the trigger with the following SQL: DROP TRIGGER myTrigger; HTH Andy

What you need is to do the query recursively. There is a cookbook for DB2 located at: http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM that has how to do recursion. HTH Andy

it is NOT possible to change anything about a column except to increase the size of a VARHAR. You have two alternatives: 1) create a view the way you want the table to look. 2) export the data, drop the table, recreate it, import the data HTH Andy

I believe you want: Select CURRENT TIMESTAMP from sysibm.sysdummy1 Andy

Select days(date1) - days(date2) as num_days from .... HTH Andy

select schemaname from syscat.schemata Andy

Check out: http://www-3.ibm.com/software/data/db2/linux/validate/ It will let you know what versions of Linux are supported. Andy

Sul, I do not think it can be done. EXPORT is a DB2 command and SP only allow SQL statements. Andy

Alec, How about: Select * from mytable where month(mydate) = month(current date - 1 MONTH) HTH Andy

Yes, I believe it can be done. Look at functions: TRANSLATE, POSSTR, RTRIM, LTRIM, SUBSTR Andy

I suggest you read the manual to see just exactly what you can do in a trigger or a udf. Look in the SQL Reference manual on CREATE TRIGGER and CREATE FUNCTION. Andy

1) not allowed 2) not allowed Sorry to not be bearer of good news. Andy