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
T
Tables
showing all tables in a schema, 56
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
W
materialized views, 117 schemas, 121 synonyms, 124 tables, 128
views, 129
Windows launch file, location of, 34
140 Index