Re: SYSTOOLS.SEND_EMAIL from CLLE

I agree with Marco. Since even the varying-length variables are 
troublesome, do a direct call to RPG. Varying can be done, but you have 
to have a couple bytes extra at the beginning to say how long the 
varying data is, then substring fro position 3 - if the varying is 
defined that way. And a DCBLOB might be possible, I've never tried.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:[email protected]> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023


On 8/3/2026 11:52 AM, Marco Facchinetti wrote:
> This is the interface:
>
> TO_EMAIL VARCHAR(5000) FOR SBCS DATA ,
> SUBJECT VARCHAR(255) ,
> BODY VARCHAR(5000) ,
> ATTACHMENT DBCLOB(5000) CCSID 1200 DEFAULT  NULL  ,
> CC_EMAIL VARCHAR(5000) FOR SBCS DATA DEFAULT  NULL  ,
> BCC_EMAIL VARCHAR(5000) FOR SBCS DATA DEFAULT  NULL  ,
> BODY_TYPE VARCHAR(6) FOR SBCS DATA DEFAULT  '*PLAIN'  )
>
> I doubt it is easy to define and use this kind of variables in CL, much
> simpler to pass the necessary data to a SQLRPGLE program.
>
> I know it does not answer your question, so since SEND_MAIL it's an
> interface for QSYS/SNDSMTPEMM maybe, in CL, it's better use the command
> itself.
>
> HTH
> --
> Marco Facchinetti
>
> Mr S.r.l.
>
> Tel. 035 962885
> Cel. 393 9620498
>
> Skype: facchinettimarco
>
>
> Il giorno lun 3 ago 2026 alle ore 18:16<[email protected]> ha
> scritto:
>
>> I have a CL that needs to send an email.  I have been trying to use
>> SYSTOOLS.SEND_EMAIL for emails in SQLRPGLE but I can't figure out how to do
>> it from within a CLLE program.  Google AI lies because it shows using a
>> "set
>> :var = SYSTOOLS.SEND_EMAIL." but it apparently the compiler doesn't handle
>> the variable like it does in SQLRPGLE.
>>
>>
>>
>> Does anybody have any insight other than using the old CL command like
>> SNDSMTPEMM or writing an SQLRPGLE program just to send the email?
>>
>> --
>> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>> To post a message email:[email protected]
>> To subscribe, unsubscribe, or change list options,
>> visit:https://lists.midrange.com/mailman/listinfo/midrange-l
>> or email:MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
>> Before posting, please take a moment to review the archives
>> athttps://archive.midrange.com/midrange-l.
>>
>> Please contactsupport-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related
>> questions.
>>
>> You can help support midrange.com by visitinghttps://donate.midrange.com
>> and making a contribution.
>>
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.

You can help support midrange.com by visiting https://donate.midrange.com and making a contribution.