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.

1	// Transaction object values have been set.

CONNECT;

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 <span>TransactionObject</span>;

1	CONNECT USING <span>TransactionObject</span>;

For example:

CONNECT USING ASETrans;

1	CONNECT USING ASETrans;

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.5

August 9, 2023

Was this article helpful?