CacheName database parameter
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.
Controls
-
JDB JDBC
-
ODBC
-
O90 Oracle9i
-
SYJ SAP Adaptive Server Enterprise
Using 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
|
1 |
CacheName='<span>value</span>' |
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
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:
|
1 |
SQLCA.DbParameter="CacheName='mydbcache'" |
Copy the syntax from the Preview page into your script.