I am receiving the following error when running an SQL stmt.
Does the file need to be journalled?
Additional Message Information
Message ID . . . . . . : SQL7008
Date sent . . . . . . : 12/12/06 Time sent . . . . . . : 16:30:25
Message . . . . : MISCCHG2 in QTEMP not valid for operation.
Cause . . . . . : The reason code is 3. Reason codes are:
1 -- MISCCHG2 has no members.
2 -- MISCCHG2 has been saved with storage free.
3 -- MISCCHG2 not journaled, no authority to the journal, or the journal
state is *STANDBY. Files with an RI constraint action of CASCADE, SET NULL,
or SET DEFAULT must be journaled to the same journal.
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
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