Assigning values to the Transaction object

Before you can use a default (SQLCA) or nondefault (user-defined) Transaction object, you must assign values to the Transaction object connection properties. To assign the values, use PowerScript dot notation.

Example

The following PowerScript statements assign values to the properties of SQLCA required to connect to a Sybase Adaptive Server Enterprise database through the PowerBuilder Adaptive Server Enterprise database interface:

sqlca.DBMS="SYC"

sqlca.database="testdb"

sqlca.LogId="CKent"

sqlca.LogPass="superman"

sqlca.ServerName="Dill"