Re: Send Email

[Mike <koldark@xxxxxxxxx>]

> From what I have seen, if you do SQL inserts, updates, and deletes, you have
to either journal the file or use one of the options MKirkpatrick presented.

On 7/9/07, Guy Terry <guy.terry@xxxxxxxxxxxxxxxxxxx> wrote:
> Our RPG developer is trying to get HTML email coming out of his RPG apps.
> I
> showed him the third-party tools that will do this, but he preferred to
> write something himself. He's using RPG to call the QTMMSENDMAIL API. The
> RPG appears to have been based on something written by Raymond Everhart.
> (You can see it half way down the thread at
> http://www.systeminetwork.com/isnetforums/showthread.php?t=46141)
>
>
>
> Trouble is, he gets a CPF4328 'Member not journaled to journal *N' (full
> error below)
>
>
>
> He thinks the bit where it goes wrong is when it runs this subroutine:
>
>
>
> 0397.00 C/Exec SQL
>
> 0398.00 C+ Insert into Qtemp/EMAIL
>
> 0399.00 C+   VALUES(:Text)
>
> 0400.00 C/End-Exec
>
>
>
> We don't use journaling here, and this error has us stumped.
>
>
>
> Any ideas?
>
>
>
> Guy
>
>
>
> Message . . . . :   Member EMAIL not journaled to journal *N.
>
>
> Cause . . . . . :   Member EMAIL file EMAIL in library QTEMP is not
> journaled
>
>   to journal *N in library *N for commitment definition QILE.
>
>
>     The journal specified is used by commitment definition QILE. If *N is
>
>
>   specified for the journal, the file is not journaled. If the file is a
>
>
>   logical file, all based-on physical files may not be journaled to the
> same
>
>
>   journal as required by commitment control.
>
>
> Recovery  . . . :   Ensure the file being opened is journaled. For logical
>
>
>   files, make sure that the based-on physical files are journaled to the
> same
>
>   journal.
>
>
> Technical description . . . . . . . . :   The commitment definition
> identifier
>
>   is X'100101000000000820C4'.
>
>
> --
> 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.