MX Release 3.1 (H06.23+, J06.12+)

DISCONNECT command

The disconnect command terminates the connection to the database platform. The RMXCI session

remains open even after this command is run.

Syntax

DISCONNECT [WITH][status][IF{condition}]

status

is any 1-byte integer. The status is a shell return value, and the range of allowable values

is platform dependent.

condition

is the same as the condition parameter defined for the “IF...THEN command” (page 69). See

“Condition Parameter” (page 69).

Considerations

You must enter the command in one line.

Examples

The following command terminates the connection to the database platform. You can connect to

the database platform by using the connect and reconnect commands:

SQL>disconnect

Session Disconnected. Please connect to the database by using

connect/reconnect command.

ENV command

The env command displays the attributes of the current RMXCI session. You can also use the

session and show session commands to perform the same function.

Syntax

ENV

Considerations

• You must enter the command in one line.

• The env command displays the following attributes:

Current column separator, which controls the display of query results. For

more information, see “SET COLSEP command” (page 84).

COLSEP

Name of the data source, which you entered when logging in to the

database platform. For more information, see “Logging in to the database

platform” (page 23).

DATASOURCE

Current history options, which control how the commands are added to

the history buffer. For more information, see “SET HISTOPT command”

(page 86).

HISTOPT

Current idle timeout value, which controls the timeout value for an inactive

session. By default, the idle timeout is 30 minutes. For more information,

IDLETIMEOUT

see “Setting and showing the idletimeout value for the session” (page 35)

and “SET IDLETIMEOUT command” (page 87).

DISCONNECT command 61