MIDRANGE dot COM Mailing List Archive

Re: SQL error


You probably need to set your SQL not to use commitment control.

On 12/6/2012 4:32 PM, Stone, Joel wrote:
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

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 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