RE: SQL error -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Just curious, what would be a use of journaling a file in QTEMP?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, December 07, 2012 8:37 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL error

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.

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.