RE: SQL0440 with Trigger and Stored Procedure

The problem is that SQL treats character literals as VARCHAR.

You need to either: change your stored procedure to accept VARCHAR
instead of CHAR.

Or explicitly tell SQL that the literals are CHAR and not VARCHAR like
so:
CALL MFPUT_SP1 (char('D'), 
                char('FTPSERVER '), 
                char('FTPUSER   '), 
                char('mylib     '), 
                char('MEMBER    '))

Or even

CALL MFPUT_SP1 (char('D'), 
                char('FTPSERVER' , 10), 
                char('FTPUSER' , 10), 
                char('mylib' , 10), 
                char('MEMBER' , 10))


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> msmith6@xxxxxxxxxxxx
> Sent: Tuesday, November 29, 2005 4:34 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL0440 with Trigger and Stored Procedure
> 
> > 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. 
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>