Re: SQL error

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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?
>
> Why?
>
> Thanks
>
>
>                           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
> ______________________________________________________________________