[AS400]Send double-bye record to personal mail-box

If you know that CA/400 can download the doble-bye record, then do you know how to send this output file to personal mail-box thru the Sequel Script ?

 

answer is: use the PC command "RMTCMD" on PC.

 

the format is: RMTCMD sequel/runscript script(library/scriptname) //IP Address

 

the email address should have writen in the script. for example:

1. there is a sequel script,named WOTDYOPN in library KEINLIB:(it's to send QTEMP/WOTDYLST2(double-bye file) to Angeli)

EXECUTE SQL('select * from qtemp/wotdylst2') PCFMT(*XLS) +
TOSTMF('work order list(on yesterday)') REPLACE(*YES) +
RECIPIENT('[e-mail];wang.dong.q+
[e-mail]') EMLMSG('This is for Angeli to +
analys work order opened on yesterday! This mail will be +sent at 8:50am every working day !') TEXT('work order +
opened on yesterday')

2. IP adress of AS400 is 192.168.231.215

 

3.check the mail box:

4.check the file:

 

if you run the sequel script on AS400 directly ,then you will recieve the unreadable character.

1. run the sequel script on AS400 directly

2. get the unreadable code

the best words to explain this kind of difference is: the default CCSID of e-send-mail command is '37', it can not identify the Chinese as send email. If you use the PC command 'RMTCMD' to call the script on AS400, it seems to override the CCSID '37' by the default CCSID of PC,which is '1388'.

I hope somebody will tell me that I am getting a wrong comprehension in one day.