Sybase 12.4.2 manual Connection parameters, Short Parameter Form Argument Description

Models: 12.4.2

1 536
Download 536 pages 20.34 Kb
Page 93
Image 93

CHAPTER 2 Running Adaptive Server IQ

Connection parameters

Adaptive Server IQ connection parameters are listed in the following table. For a full description of each of these connection parameters, see Chapter 3, “Connection and Communication Parameters” in the Adaptive Server IQ Reference Manual.

 

Short

 

 

Parameter

form

Argument

Description

 

 

 

 

AutoPreCommit

AutoPreC

Yes/No

Force each statement to

 

ommit

 

commit before

 

 

 

execution

 

 

 

 

AutoStop

Astop

Yes/No

Prevent a database from

 

 

 

being unloaded as soon

 

 

 

as there are no more

 

 

 

open connections.

 

 

 

(Embedded databases)

 

 

 

 

CommAutoStop

CAstop

Yes/No

Unload network

 

 

 

communications ports

 

 

 

as soon as there are no

 

 

 

more open connections

 

 

 

from the client machine.

 

 

 

 

CommBufferSize

CBSize

Integer

Set the maximum size of

 

 

 

communication packets,

 

 

 

in bytes.

 

 

 

 

CommBufferSpace

CBSpace

Integer

Specify the amount of

 

 

 

space to allocate on

 

 

 

startup for network

 

 

 

buffers, in kilobytes.

 

 

 

 

CommLinks

Links

String

Specify network

 

 

 

communications links.

 

 

 

 

ConnectionName *

CON

String

Name a connection to

 

 

 

make switching to it

 

 

 

easier in multi-

 

 

 

connection applications.

 

 

 

 

DatabaseFile

DBF

String

Identify a database file

 

 

 

to load and connect to

 

 

 

(for embedded

 

 

 

databases).

 

 

 

 

DatabaseName

DBN

String

Identify a loaded

 

 

 

database to which a

 

 

 

connection needs to be

 

 

 

made.

 

 

 

 

73

Page 93
Image 93
Sybase 12.4.2 manual Connection parameters, Short Parameter Form Argument Description