SQL>/

(EXPR)

--------------------

62

---1 row(s) selected.

SQL>

CLEAR Command

The CLEAR command clears the interface window so that only the prompt appears at the top of the window. CLEAR does not clear the log file or reset the settings of the session.

Syntax

CLEAR

Considerations

In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

Example

This CLEAR command clears the interface window:

SQL>clear

After the CLEAR command executes, the interface window appears with only the prompt showing:

SQL>

CONNECT Command

The CONNECT command creates a new connection to the Neoview platform from the current or existing Neoview Script session.

Syntax

CONNECT [username [/password][@hostname][,dsnName]]

username specifies the user name to log in to the database platform. If the user name is not specified, Neoview Script prompts for the user name.

password specifies the password of the user to log in to the database platform. If the password is not specified, Neoview Script prompts for the password.

hostname specifies the host name or IP address of the database platform to which you want the client to connect. If the hostname is not specified, the value is automatically used from the current Neoview Script session. If Neoview Script was invoked with the -noconnectlaunch parameter, you are prompted for a hostname value.

dsnName specifies the name of a data source. If the dsnName is not specified, the value is automatically used from the current Neoview Script session. If Neoview Script was invoked with the -noconnectlaunch parameter, you are prompted for a dsnName value.

Considerations

In the Neoview Script interface, you must enter the command on one line.

CLEAR Command 83