Versions Compared

Old Version 1

changes.mady.by.user user-eb51a

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Rivera

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The CONNECT command connects to a remote database. By default, a connection object is in auto-commit mode, which means that it automatically commits changes after executing each statement.

Syntax:

Command

Keyword

Value

Developer notes

CONNECT

DRIVER

value

Required. Database driver name.

DATABASE

value

Required. Database name.

USER

value

Required. Database server user login.

PASSWORD

value

Required. Database server user password.

Example

    CONNECT DRIVER(DB2) DATABASE(SALES) USER(user) PASSWORD(password)

...