Neoview Script Guide (R2.2)

Example

This / command executes the previously executed SELECT statement:

SQL>select count(*) from persnl.employee;

(EXPR)

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

--- 1 row(s) selected.

SQL>/

(EXPR)

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

--- 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.

CLEAR Command 87