1. Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 8 December 2020 18:19 PM UTC

Hi, all.

Please, consider the following situation:

In my Web app, I programmatically fill SQLCA from an INI file and connect to a specific database. In AEM, for the same app, SQLCA connects to a different database.

How does PS resolve this incoherence? Which database connection prevails in runtime, INI’s or AEM’s? 

mike S Accepted Answer Pending Moderation
  1. Tuesday, 8 December 2020 18:55 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

the connection is completely different in powerserver than powerbuilder.  

in powerserver, you set the cache name:

SQLCA.DBParm="CacheName='"  + yourcachename + "'"


which controls what database and server you are connecting to


the cachename is setup in AEM - and that is where the server and database information is stored

  1. Chris Pollach @Appeon
  2. Tuesday, 8 December 2020 21:12 PM UTC
Hi Mike;

The cache can also be dynamically built by the PS App at run-time and thus require "no" AEM setup or, your Apps can use a predefined cache as set out by AEM. (Note: not all supported PS DBMS types can use the dynamic cache feature).

Many apps only deal with one DB instance so the dedicated Transaction Object mapping is all they need.

I like using cache names for distributed (segmented) DB's, say for "regional" DBs or for various instances of a customer DB (CustA, CustB, ...etc) to keep the datum logically/physically separated.

Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.