The default Transaction object  Reading values from an external file

Chapter 16: Using Transaction Objects

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. Reading values from an external file

View this book as PDF