Connecting to the database

Once you establish the connection parameters by assigning values to the Transaction object properties, you can connect to the database using the SQL CONNECT statement:

// Transaction object values have been set.
CONNECT;

Because CONNECT is a SQL statement, not a PowerScript statement, you need to terminate it with a semicolon.

If you are using a Transaction object other than SQLCA, you must include the USING TransactionObject clause in the SQL syntax:

CONNECT USING TransactionObject;

For example:

CONNECT USING MyTrans;