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 and SYC SAP 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.


Default value

Log=1

Usage

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

Examples

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"

    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.