Re: Help with a Trigger Problem

[rob@xxxxxxxxx]

I don't even know enough French to get slapped in a bar but I did a 
DSPMSGD RANGE(SQL0408) MSGF(QSQLMSG)
and it looks like the first error you are getting.
Message . . . . :   Value for column or variable &1 not compatible.  
Cause . . . . . :   The data type of the source value is not compatible 
with
  the data type of the target column or variable &1. If the statement is  
  INSERT or UPDATE, &1 is a column in table &2 in schema &3.  
    -- Any numeric type value can be assigned to any numeric, character, 
or 
  graphic type.  
    -- Any character or graphic value can be assigned to any character,  
  graphic, or numeric type.  
    -- Any binary value can be assigned to any binary type.  
    -- A date, time, or timestamp value can be assigned to any character 
or 
  graphic type.  
    -- Any character or graphic value can be assigned to a date, time, or  

  timestamp type.  
    -- A date value can be assigned to a date.  
    -- A time value can be assigned to a time.  
    -- A timestamp value can be assigned to a timestamp.  
    -- A value being assigned to a user-defined type must be promotable to 
the
  source type.  
    -- The DLVALUE function must be specified when assigning to a 
DataLink. 
Recovery  . . . :   Change the column, host variable, constant, or 
function 
  assigned to &1 to one that is compatible. Try the request again.  


I suspect your trigger program needs to do a little CASTing about.

Rob Berendt