Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

without log

2 posts in Windows NT Last posting was on 2000-07-05 04:39:38.0Z
André Castanheira Posted on 2000-07-04 13:00:26.0Z
Message-ID: <3961DFEA.221A7B7@cariocaengenharia.com.br>
Date: Tue, 04 Jul 2000 10:00:26 -0300
From: =?iso-8859-1?Q?Andr=E9?= Castanheira <andre.castanheira@cariocaengenharia.com.br>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: without log
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 3
NNTP-Posting-Host: ol40-018.openlink.com.br 200.188.40.18
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1942
Article PK: 1089390

Hi,

Is there a way to make a DML command ( insert or delete ) without
logging it ?

Thanks,
André


"Mark A. Parsons" <pegasys Posted on 2000-07-05 04:39:38.0Z
Message-ID: <3962BC0A.216EA9D2@_internet.co.nz>
Date: Wed, 05 Jul 2000 16:39:38 +1200
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: without log
References: <3961DFEA.221A7B7@cariocaengenharia.com.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
NNTP-Posting-Host: p425.ipa1-n8-16.iconz.net.nz 210.48.25.169
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1940
Article PK: 1089384


> Is there a way to make a DML command ( insert or delete ) without
> logging it ?

Assuming your talking about ASE ... no, all DML's are logged.

You can have the log automatically truncated afterwards by setting the
database option "trunc log on chkpt" ... but this doesn't stop the
initial logging from occurring.

(Yeah, there's a flag floating around somewhere that will allow you to
turn off logging ... but this is an undocumented feature and not
guaranteed by Sybase TS to *not* cause corruption.)
--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (200), Ltd pegasys@internet.co.nz