Log

Description

Specifies whether the database server should log updates of text and image data in the transaction log. By default, the database server logs updates of text and image data in the transaction log.

Applies to

SYC Sybase Adaptive Server Enterprise

Syntax

Log = value

Parameter	Description
value	A value that specifies whether the database server should log updates of text and image data in the transaction log. Values are: 0 Do not log text and image updates in the transaction log. Specify this value only if your database server allows you to disable logging. 1 (Default) Log text and image updates in the transaction log.

Parameter

Description

value

A value that specifies whether the database server should log updates of text and image data in the transaction log. Values are:

0 Do not log text and image updates in the transaction log. Specify this value only if your database server allows you to disable logging.
1 (Default) Log text and image updates in the transaction log.

Default

Log = 1

Usage

You should set the Log parameter to 0 only if your database server allows you to disable logging.

Examples

Example 1

To specify that DataWindow Designer should not log text and image updates in the transaction log:

Database profile Clear the Log Text and Image Updates check box on the System tab or Transaction tab in the Database Profile Setup dialog box.
Application Type the following in code:
```
SQLCA.DbParameter="Log=0"
```