AS400 File transfer from AS400
I transfered the database output into excel file using CPYTOIMP command and attached the excel file using SNDDST command.But i have issue that i didn't received the excel file through email only if the file size more.Anyone kindly tell me, how to write the data into multiple sheets or kindly advise me some idea to fix the issue.
Thanks in advance.
R.Siva
Software/Hardware used:
Software/Hardware used:
ASKED:
April 4, 2012 4:47 AM
UPDATED:
April 17, 2012 7:18 PM
Answer Wiki:
Hi tom,
I used to copy to import command to transfer the database record in the qtemp into Stream director path as a .xls file.
Code as like below.
CPYTOIMPF FROMFILE(QTEMP/EDITMPPF *FIRST) +
TOSTMF('QDLS/STREAM/' *TCAT &FNAME) +
MBROPT(*REPLACE) STMFCCSID(*STMF) +
STMFCODPAG(*PCASCII) STMFAUT(*FILE) +
RCDDLM(*CRLF) STRDLM(*NONE) +
RMVBLANK(*LEADING) FLDDLM(*TAB) +
DECPNT(*COMMA)
Then, attached the .xls file in the stream folder into Email.Code as below
SNDDST TYPE(*DOC) TOINTNET((&TO *PRI) (&CC1 *CC) +
(&CC2 *CC) (&CC3 *CC) (&CC4 *CC) (&CC5 +
*CC) (&CC6 *CC) (&CC7 *CC) (&CC8 *CC) +
(&CC9 *CC) (&CC10 *CC)) DSTD(&SUBJ) +
MSG(&INVNO) DOC(&FNAME) FLR(STREAM)
I am practically using so many programs.I have two issue came know.
1. How to change the FROM(SENDER) address dynamically based on inpur parameter.
2. How to handle the file size while attaching into Email.Because if the file size more, it's not attach the file & also not sending email.
Kindly tell me, you have any idea to handle the situation.
Thank you
To see all answers submitted to the Answer Wiki: View Answer History.
kindly anyone please tell me, how to change dynamic FROM email address in the SNDDST command.I have task to change the from address in the SNDDST based on parameter user sent.I checked in the internet with option to configure TCP using WRKDIRE.But i want the dynamic from address for the particular module only.
I transfered the database output into excel file using CPYTOIMP command…
The CPYTOIMPF command cannot create Excel files. It can create .CSV files that can be imported into Excel; and then Excel can put its output into an Excel file.
But SNDDST cannot send Excel files through e-mail unless you have properly encoded them first. If you are really sending Excel files, what did you use for the encoding?
Tom