Re: iSeries sql send msg/reply problem

[rob@xxxxxxxxx]

Try MSGDTA and not MSGKEY on your RCVMSG.  Not only can you drop it back 
down to 1 character but you will actually get the data you give a rip 
about.
I suggest using MSGID and MSGDTA instead of MSG on your SNDPGMMSG.  Not 
only can you ensure that they only enter the correct message, but, if you 
need to change languages (my sister-in-law teaches in Florida) it's easier 
to hire a translator to convert message files.
See:
ADDMSGD MSGID(USR0010) 
        MSGF(ENGLISH/USRMSG) 
        MSG('Is file name ok? 1=Yes, 5=No')
        SECLVL('Double check it dude.') 
        LEN(1) 
        VALUES(1 5) 


Rob Berendt