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 the SQL Anywhere demo database through the PocketBuilder ODB database interface:

SQLCA.DBMS = 'odb'
SQLCA.DBParm = "ConnectString='DSN=SQLAny 10 Demo;UID=dba;PWD=sql'"

The following PowerScript statements assign values to the properties of SQLCA required to connect to a Sybase UltraLite 9.x database through the PocketBuilder UL9 database interface:

SQLCA.DBMS = "UL9"
SQLCA.DBParm = "ConnectString='DBF=\UltraLite\uleq.udb;UID=dba;PWD=sql'"