|
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] How was the table created? Basically you have a few options 1 - Delete and recreate the library using the SQL command CREATE COLLECTION instead of the OS/400 command CRTLIB. The CREATE COLLECTION will automatically create the necessary journals, and a plethora of other objects for this library. 2 - Create the journals and receivers yourself. See GO CMDJRN 3 - Ignore the message and just be aware that commitment control and some forms of referential integrity will not be available to you. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin "Ren Fu Ping" <fupingren@yeah.net> Sent by: rpg400-l-admin@midrange.com 04/23/2002 06:03 AM Please respond to rpg400-l To: <rpg400-l@midrange.com> cc: Fax to: Subject: Database Journaled This is a multi-part message in MIME format. -- [ Picked text/plain from multipart/alternative ] Message . . . . : Table ACRX10W1 in NTCOMMON created but could not be journaled. Cause . . . . . : The table ACRX10W1 was created in NTCOMMON, but the table could not be journaled. The journal QSQJRN in NTCOMMON may be damaged, removed, unable to accept journal entries, or may not be created. The SQL name for the table is ACRX10W1 and the system name for the table is ACRX10W1. For a distributed table, journaling could not be started on all of the systems. The journal QSQJRN in NTCOMMON must exist, and be able to accept journal entries, on each of the systems in the node group. Recovery . . . : The table was created, but until the table is journaled, COMMIT(*CHG), COMMIT(*CS), and COMMIT(*ALL) will not be allowed for table ACRX10W1. If journal QSQJRN does not exist in NTCOMMON, create the journal (CRTJRN command) and start journaling (STRJRNPF command). If the journal is in error, correct the problem to the journal If the table is distributed, correct the problems on all the systems in the node group and start journaling (STRJRNPF command). Hello, Everybody An CL programm running in batch has display the error message on the above, but running in interactive has nothing, this CL programm is calling an SQLRPG that compiled by option commit(*NONE). How to solve it? thanks for any suggestion. Regards! Ping -- _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.