SQL0440 with Trigger and Stored Procedure

[msmith6@xxxxxxxxxxxx]

> from: Colin Williams <colinwilliams007@xxxxxxxxx>
> subject: Re: SQL0440 with Trigger and Stored Procedure
> 
> If the program is definitely in that library, I would suspect it 
> doesnt like
> the parameters for some reason!
> 
> Its expected you to pass 10 long  CHAR fields, is that definitely 
> what you
> calling it with?

In the trigger definition I created, I padded the parameters with 
spaces to make sure they were the length the Stored Procedure was 
expecting.
      CREATE TRIGGER MFPUT_T1 AFTER INSERT ON mylib/MFPUT CALL 
MFPUT_SP1 
       ('D', 'FTPSERVER ', 'FTPUSER   ', 'mylib     ', 'MEMBER    ')

What kicks this whole thing off is adding a record to a database. It 
has three fields of no real concern.  None of the data in it is used 
in this procedure.  I'm just using it as the event.