Release
database parameter
Description
Specifies what version of SAP Sybase Open Client Client-Library
(CT-Lib) software is in use on the client workstation.
When to specify Release
You must specify a value for Release before connecting to the
database.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
Syntax
|
1 |
Release='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies the version of Open Client Client-Library The value corresponds to the
|
Default value
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
PBSYC180.DLL database connection. This context acts as the parent
context for all subsequent PBSYC180.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,
PBSYC180.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, PBSYC180.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, PBSYC180.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 PBSYC180.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
To specify that your PowerBuilder application accesses an Adaptive
Server Enterprise 15 database using an Open Client Client-Library 15
context:
-
Database profile
Select 15 from the Release drop-down list on the Connection
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Release='15'"