HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 124)

Considerations

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

does not require an SQL terminator.

• You can execute this command only in SQL mode.

Example

This command shows that the SQL prompt for the current session is SQL>:

SQL>show sqlprompt

SQLPROMPT SQL>

SHOW SQLTERMINATOR Command

The SHOW SQLTERMINATOR command displays the SQL statement terminator of the current

Neoview Script session.

Syntax

SHOW SQLTERMINATOR

Considerations

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

does not require an SQL terminator.

• You can execute this command only in SQL mode.

Example

This command shows that the SQL terminator for the current session is a period (.):

SQL>show sqlterminator

SQLTERMINATOR .

For more information, see “Setting and Showing the SQL Terminator” (page 54).

SHOW SYNONYMS Command

The SHOW SYNONYMS command displays all or a set of the synonyms in the current schema

of the Neoview Script session.

Syntax

SHOW SYNONYMS [wild-card-pattern]

wild-card-pattern

is a character string used to search for and display synonyms with

names that match the character string. wild-card-pattern matches

an uppercase string unless you enclose it within double quotes. To

124 Neoview Script Interface Commands

1 2 ... 119 120 121 122 123 124 125 126 127 128 129 ... 141 142

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 124