MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

Re: SQL error



fixed

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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact