beautypg.com

Connection parameters – Sybase 12.4.2 User Manual

Page 93

background image

CHAPTER 2 Running Adaptive Server IQ

73

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
.

Parameter

Short
form

Argument

Description

AutoPreCommit

AutoPreC

ommit

Yes/No

Force each statement to
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.