CacheName

Description

Allows PowerBuilder to specify an EAServer connection cache by name. This database parameter applies only when a PowerBuilder custom class user object is deployed as an EAServer component.

Applies to

NoteUsing the SYJ interface Sybase EAServer uses a slightly different version of the CT-Lib software. Therefore, at runtime, you need to use the SYJ database interface rather than ASE and SYC to connect to an Adaptive Server Enterprise database. The SYJ Database Profile Setup dialog box provides a convenient way to set the appropriate connection parameters and then copy the syntax from the Preview page into the script for your Transaction object.

You cannot use the SYJ interface, however, to connect to the database in the PowerBuilder development environment. Therefore, during the development phase (before the component has been deployed to EAServer), you must use ASE or SYC to connect to the database.

Syntax

CacheName='value'

Default

None

Usage

When you create a PowerBuilder custom class user object that uses an EAServer connection cache, you must specify a user name, password, server name, and connectivity library. However, if the “enable cache-by-name access” option has been enabled on EAServer, you just need to enter the connection cache name to specify the connection cache.

For information on how to use PowerBuilder to build EAServer components, see Application Techniques.

This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.

Examples

Example 1

On the EAServer page in the Database Profile Setup dialog box, select the Access Cache By Name check box and enter the EAServer cache name in the Cache Name box. The PowerScript syntax for the CacheName DBParm parameter displays on the Preview page:

SQLCA.DBParm="CacheName='mydbcache'"

Copy the syntax from the Preview page into your script.

See also