× 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.



Any TABLE can be journaled with STRJRNPF; i.e. need not be done implicitly. But as I had noted in an earlier reply, there is no requirement to journal if *NC [COMMIT(*NONE)] is correctly in effect, either for the connection or for the statement [using the clause WITH NC]. In an earlier reply I had also noted that the "not journaled" error message SQL7905 gives recovery, and I included in my message as well, that the QSQJRN *JRN could be created into a library to effect implicit TABLE journaling. Plus alluding that there is more general implicit journaling available via QDFTJRN or STRJRNLIB.

http://archive.midrange.com/midrange-l/201206/msg00173.html
http://archive.midrange.com/midrange-l/201206/msg00190.html
http://archive.midrange.com/midrange-l/201206/msg00179.html

Though apparently this message will similarly go unnoticed [¿maybe NNTP postings are not getting sent via the email LIST as individual messages <or in Digests?] or otherwise just being ignored... So perhaps I am just wasting my time trying both to correct the misinformation and to describe the functionality and possible means to effect a desirable resolution. Ughh.

Regards, Chuck

On 08 Jun 2012 05:46, Brian Piotrowski wrote:
But what if I want to keep the table in a library that already
exists? Can I modify the current library to include this statement?
<<SNIP>>

Alan Campin on Thursday, June 07, 2012 4:19 PM wrote:

Easiest way is to create an SQL library. Do a STRSQL and type a
CREATE COLLECTION and enter a library name. It will create a
library with journal and all SQL objects. Any table that is created
in it is automatically journaled.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.