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

ASE, SYC and SYJ 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 PowerBuilder 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 page or Transaction page in the Database Profile Setup dialog box.

Application Type the following in code:
```
SQLCA.DBParm="Log=0"
```

Example 2

To specify that PowerBuilder should not log text and image updates in the transaction log, clear the Log Text and Image Updates check box on the System page or Transaction page in the Database Profile Setup dialog box.