On 06 Dec 2012 23:25, Birgitta Hauser wrote:
Tables in QTEMP are never journaled and you are running the statement
in an environment where commitment control is started and used.
To avoid this error messages you may add WITH NC (= With No Commit)
to the end of the statement.

I often will journal a TABLE in QTEMP, so assuredly the claim "never" is false, given that counter example. I do not recall, but I believe the QDFTJRN could also be used for implicit journaling for the QTEMP library; when I journal, I typically use QCMDEXC to STRJRNPF. Additionally, if the TABLE was created as a GLOBAL TEMPORARY TABLE, using the appropriate syntax, even that would have the TABLE implicitly journaled; GTTs are created in [IIRC] the SCHEMA named SESSION which is just a synonym for QTEMP.

Return to Archive home page | Return to MIDRANGE.COM home page