Release database parameter

Description

Specifies what version of Sybase Open Client Client-Library
(CT-Lib) software is in use on the client workstation.

Controls

• ASE, SYC SAP Adaptive
  Server Enterprise

Syntax

Parameter

Description

value

Specifies the version of Open Client Client-Library your application uses. The value corresponds to the value of the CS_VERSION property that is used to allocate a context structure for the client. Multiple values that specify the same client context are provided for backwards compatibility. Release number 15 or higher for ASE. Release number 15 or lower for SYC: 10.x CS_VERSION_100 11 CS_VERSION_110 11.5 CS_VERSION_110 12 CS_VERSION_110 12.5 CS_VERSION_125 12.5.1 CS_VERSION_125 15 CS_VERSION_15 15.5 CS_VERSION_155

Default

Release=’15’ for ASE, Release=’11’ for
SYC

Usage

The Release parameter must correspond to the version of Open
Client software installed on the client workstation. For example,
do not specify 12.5 or 12.5.1 if your Open Client version is 12.0,
even if your Adaptive Server version is 12.5 or 12.5.1.

To use Adaptive Server 15, you must install Open Client version
15 on the client computer and set the Release parameter to 15 to
establish an Open Client 15 client context.

The Open Client context is allocated by the first PBSYC126.DLL database connection.
This context acts as the parent context for all subsequent PBSYC126.DLL connections.
Therefore, you must specify the same value for the Release parameter
for all your connections.

If the client library is not loaded, the version that corresponds
to the value of Release is loaded.If the value of Release is 15
and that version is not available on the client, the library fails
to load. If the value of Release is less than 15 and that version
is not available, PBSYC126.DLL attempts to
load version 15 of the client library and fails only if neither
the requested version nor version 15 is available. If there is no
active client context, PBSYC126.DLL connects
using the value of the Release parameter. If there is an active
client context, the new connection fails if the value of the Release
parameter is higher than the current client context. The new connection
succeeds if the value of the Release parameter is the same as or
lower than the current client context.

The SYC driver links to the appropriate version of the client
libraries dynamically and the Open Client context is released when
all connections are closed. If you open multiple connections, the
first Open Client context established is used for all of them. If
you need to establish a new Open Client context in the development
environment, close all open connections and establish a new connection
with the Release parameter set to the context you require.

During each database login, PBSYC126.DLL automatically
determines the version of Adaptive Server being accessed. It customizes
its behavior to optimize performance and features for the combination
of the Adaptive Server version and the Open Client context specified
in the Release parameter. Specifying a value for Release that does
not correspond to the Open Client software on the client can cause
unpredictable results.

The values 12.5 and 12.5.1 both open an Open Client 12.5 context.
However, you should always specify Release=’12.5′ if
you are using Open Client 12.5 and Release=’12.5.1′ if
you are using Open Client 12.5.1. This ensures that PBSYC126.DLL correctly
handles the following scenarios that require Open Client 12.5.1
and Adaptive Server 12.5.1:

• Use the Date and Time datatypes
  introduced in Adaptive Server 12.5.1 in RPC calls that explicitly
  call for these datatypes in the stored procedure argument list.

• Use the Date and Time datatypes
  in Update where current of and Delete
where current of statements.

Retrieval, insert, update, and delete processing work correctly
against Date and Time datatypes
using any Open Client software and Adaptive Server 12.5.1 or later.
In the Database painter, the Date and Time datatypes
display in the list of metadata types when you are connected to
an Adaptive Server 12.5.1 server in any Open Client context.

Certain other features are supported only when you access
a specified version of a SQL Server
10/11 or Adaptive Server Enterprise database using its associated
Open Client software. For example, you must:

• Set
  the Release parameter to 11 or higher and use Open Client 11.x or higher
  and Adaptive Server 11.x or higher to take advantage of network–based
  security and directory services in your application.

• Set Release to 12.5 and use Open Client 12.5 or
  higher and Adaptive Server 12.5 or higher to access Char and VarChar columns
  with more than 255 characters.

• Set Release to 15 and use Open Client 15 or higher
  and Adaptive Server 15 or higher to access the UniText and
  64-bit integer (BigInt) SQL datatypes added
  in version 15 of Adaptive Server.

• Set Release to 15.5 and use Open Client 15.5 or
  higher to access the BIGTIME and BIGDATETIME SQL
  datatypes added in version 15.5 of Adaptive Server.

Examples

---