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 ASA sample database through the PocketBuilder ODB database interface:

SQLCA.DBMS = 'odb'
SQLCA.DBParm = "ConnectString='DSN=ASA 9.0 Sample;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'"

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF