Neoview Script Guide (R2.2)

SHOW SQLPROMPT command, 130
SHOW SQLTERMINATOR command, 131
SHOW SYNONYMS command
example of, 61
syntax of, 131
SHOW TABLE command
example of, 60
syntax of, 132
SHOW TABLES command
example of, 60
syntax of, 134
SHOW TIME command, 135
SHOW TIMING command, 135
SHOW VIEWS command
example of, 61
syntax of, 136
SPOOL command
examples of, 68
syntax of, 137
Spooling (see Logging output)
SQL mode, 97
SQL parameters
displaying, 65
resetting, 65
setting, 65
SQL statement
breaking across lines, 56
displaying the elapsed time, 58
editing, 91
preparing and executing, 64
repeating, 63, 103
running in a Perl or Python program, 80
running in the Neoview Script interface, 63
running on a Perl or Python command line, 79
running when launching Neoview Script, 52
terminating, 56
SQL statements, supported in Neoview Script
ALTER MVGROUP statement, 139
ALTER SYNONYM statement, 139
ALTER TABLE statement, 139
ALTER TRIGGER statement, 139
ALTER VIEW statement, 139
BEGIN WORK statement, 139
CALL statement, 139
COMMIT WORK statement, 139
CREATE INDEX statement, 139
CREATE MATERIALIZED VIEW statement, 139
CREATE MVGROUP statement, 139
CREATE SCHEMA, 139
CREATE SYNONYM statement, 139
CREATE TABLE, 139
CREATE TRIGGER statement, 139
CREATE VIEW statement, 139
DELETE statement, 139
DROP INDEX statement, 139
DROP MATERIALIZED VIEW statement, 139
DROP MVGROUP statement, 139
DROP SCHEMA statement, 139
DROP SYNONYM statement, 139
DROP TABLE statement, 139
DROP TRIGGER statement, 139
DROP VIEW statement, 139
EXECUTE statement, 139
EXPLAIN statement, 140
GRANT EXECUTE statement, 140
GRANT SCHEMA statement, 140
GRANT statement, 140
INSERT statement, 140
LOCK TABLE statement, 140
MAINTAIN command, 140
MERGE INTO command, 140
POPULATE INDEX utility, 140
PREPARE statement, 140
PURGEDATA utility, 140
REORG command, 140
REVOKE EXECUTE statement, 140
REVOKE statement, 140
ROLLBACK WORK statement, 140
SELECT statement, 140
SET SCHEMA, 140
SET TABLE TIMEOUT statement, 140
SET TRANSACTION statement, 140
UPDATE statement, 140
UPDATE STATISTICS statement, 140
SQL terminator
setting, 58
showing, 58
SQL utilities, 139
SQLPlus look and feel, 36
Standard prompt
customizing, 57
description of, 55
displaying the current time, 57
Synonyms
showing all synonyms in a schema, 61
wild-card search, 131
T
Tables
showing all tables in a schema, 60
wild-card search, 134
TDM_Default_DataSource, 48
Teradata look and feel, 36
Timeout, idle session, 57
Transaction, example of, 69
Type 4 driver
See JDBC driver, 26
U
UNIX launch file, location of, 34
UPDATE STATISTICS statement
description of, 140
example of, 80
User profile
setting _JAVA_OPTIONS, 40
setting login environment variables, 78
setting the PATH, 26, 46
Utilities, 139
146 Index