Filter
Top Products
syntax of, 127
SHOW TIME command, 128
SHOW TIMING command, 129
SHOW VIEWS command
example of, 57
syntax of, 129
SPOOL command
examples of, 64
syntax of, 130
Spooling (see Logging output)
SQL mode, 92
SQL parameters
displaying, 61
resetting, 61
setting, 61
SQL statement
breaking across lines, 52
displaying the elapsed time, 54
editing, 87
preparing and executing, 60
repeating, 59, 98
running in a Perl or Python program, 76
running in the Neoview Script interface, 59
running on a Perl or Python command line, 75
running when launching Neoview Script, 48
terminating, 52
SQL statements, supported in Neoview Script
ALTER MVGROUP statement, 133
ALTER SYNONYM statement, 133
ALTER TABLE statement, 133
ALTER TRIGGER statement, 133
ALTER VIEW statement, 133
BEGIN WORK statement, 133
COMMIT WORK statement, 133
CREATE INDEX statement, 133
CREATE MATERIALIZED VIEW statement, 133
CREATE MVGROUP statement, 133
CREATE SCHEMA, 133
CREATE SYNONYM statement, 133
CREATE TABLE, 133
CREATE TRIGGER statement, 133
CREATE VIEW statement, 133
DELETE statement, 133
DROP INDEX statement, 133
DROP MATERIALIZED VIEW statement, 133
DROP MVGROUP statement, 133
DROP SCHEMA statement, 133
DROP SYNONYM statement, 133
DROP TABLE statement, 133
DROP TRIGGER statement, 133
DROP VIEW statement, 133
EXECUTE statement, 133
GRANT statement, 133
INSERT statement, 134
LOCK TABLE statement, 134
MAINTAIN command, 134
POPULATE INDEX utility, 134
PREPARE statement, 134
PURGEDATA utility, 134
REORG command, 134
REVOKE statement, 134
ROLLBACK WORK statement, 134
SELECT statement, 134
SET SCHEMA, 134
SET TABLE TIMEOUT statement, 134
SET TRANSACTION statement, 134
UPDATE statement, 134
UPDATE STATISTICS statement, 134
SQL terminator
setting, 54
showing, 54
SQL utilities, 133
SQLPlus look and feel, 36
Standard prompt
customizing, 53
description of, 51
displaying the current time, 53
Synonyms
showing all synonyms in a schema, 57
wild-card search, 124
T
Tables
showing all tables in a schema, 56
wild-card search, 128
TDM_Default_DataSource, 46
Teradata look and feel, 36
Timeout, idle session, 53
Transaction, example of, 64
Type 4 driver
See JDBC driver, 26
U
UNIX launch file, location of, 34
UPDATE STATISTICS statement
description of, 134
example of, 76
User profile
setting _JAVA_OPTIONS, 39
setting login environment variables, 74
setting the PATH, 26, 44
Utilities, 133
V
VERSION command, syntax of, 131
Views
showing all views in a schema, 57
wild-card search, 129
W
Wild-card characters, 116
Wild-card search
materialized views, 117
schemas, 121
synonyms, 124
tables, 128
views, 129
Windows launch file, location of, 34
140 Index