CONNECT – PB Docs 125

CONNECT SQL statement

Description

Connects to a specified database.

Syntax

Parameter

Description

TransactionObject

The name of the transaction object containing
the required connection information for the database to which you
want to connect. This clause is required only for transaction objects
other than the default (SQLCA).

Usage

This statement must be executed before any actions (such as INSERT, UPDATE, or DELETE)
can be processed using the default transaction object or the specified
transaction object.

note.png Error handling

It is good practice to test the success/failure code
after executing a CONNECT statement.

Examples

[Example 1]

This statement connects to the database specified in the default transaction
object:

[Example 2]

This statement connects to the database specified in the transaction
object named Emp_tran:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x