Neoview Command Interface (NCI) Guide (R2.5)

SQL statement
breaking across lines, 45
displaying the elapsed time, 48
editing, 84, 87
preparing and executing, 54
repeating, 53, 103
running in the NCI, 53
running when launching NCI, 40
terminating, 46
SQL terminator
setting, 48
showing, 48
SQLPlus look and feel, 25
Standard prompt
customizing, 47
description of, 45
displaying the current time, 47
START DS command, 176
START SERVICE command, 176
STATUS DS command, 177
STATUS SERVER command, 178
STATUS SERVICE command, 180
STOP DS command, 182
STOP SERVER command, 183
STOP SERVICE command, 183
Synonyms
showing all synonyms in a schema, 51
wild-card search, 141
T
Tables
showing all tables in a schema, 50
wild-card search, 145
TDM_Default_DataSource, 35
Teradata look and feel, 25
Timeout, idle session, 47
Trace option, enabling, 29
Transaction, example of, 59
U
Update statistics operation, scheduling, 107
User profile
setting _JAVA_OPTIONS, 29
setting login environment variables, 68
setting the PATH, 34
V
VERSION command, 150
Views
showing all views in a schema, 51
wild-card search, 147
W
Wild-card characters, 75, 97, 131
Wild-card search
materialized views, 132
procedures, 135
schemas, 137
synonyms, 141
tables, 145
views, 147
WMS mode, 96
188 Index